[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    [ADMIN] tablespace backup and recovery from or to remote machine
From:       Karuna Karpe <karuna.karpe () os3infotech ! com>
Date:       2011-12-15 11:57:57
Message-ID: CAC-LqboK66=7+4E2-OVYnNdYfWnz0hy-QdVkMQRrTRvyqLOupA () mail ! gmail ! com
[Download RAW message or body]

Hello,


          I am doing streaming replication in 2 remote machines.  On
primary server I have two tablespaces. Then I start baseback and copy data
directory on primary to standby server I use rsync command.

rsync -r /opt/PostgresPlus/9.0/data/ root@192.168.0.115:
/opt/PostgresPlus/data_standby

When I run rsync command I got following error massage.

          skipping non-regular file "pg_tblspc/16387

For that I again run rsync command as follow:

rsync -rk ../data/ root@192.168.0.115:/opt/PostgresPlus/data_standby

It is run properly.  But all data in the tablespace on primary server is in
one location only (i.e. ../pg_tblspc/16387), there is no any symbolic
link.  But I want this all data in '../pg_tblspc/16387' this directory to
another location that '/opt/PostgresPlus/tablespace1' on standby server.

Is this possible that creating link between '../pg_tblspc/16387' to
'/opt/PostgresPlus/tablespace1' dynamicaly?

and Is it possible that we define exiting tablespace location at the time
of restore database on another server?

Please give me solution for that.


Thank You.

Regards,
Karuna Karpe.

[Attachment #3 (text/html)]

Hello,<br><br><br>=A0=A0=A0=A0=A0=A0=A0=A0=A0 I am doing streaming replicat=
ion in 2 remote machines.=A0 On primary server I have two tablespaces. Then=
 I start baseback and copy data directory on primary to standby server I us=
e rsync command. <br>
<br>rsync -r /opt/PostgresPlus/9.0/data/ root@192.168.0.115:/opt/PostgresPl=
us/data_standby<br><br>When I run rsync command I got following error massa=
ge.<br><br>=A0=A0=A0=A0=A0=A0=A0=A0=A0 skipping non-regular file &quot;pg_t=
blspc/16387<br>
<br>For that I again run rsync command as follow:<br><br>rsync -rk ../data/=
 root@192.168.0.115:/opt/PostgresPlus/data_standby<br><br>It is run properl=
y.=A0 But all data in the tablespace on primary server is in one location o=
nly (i.e. ../pg_tblspc/16387), there is no any symbolic link.=A0 But I want=
 this all data in &#39;../pg_tblspc/16387&#39; this directory to another lo=
cation that &#39;/opt/PostgresPlus/tablespace1&#39; on standby server. <br>
<br>Is this possible that creating link between &#39;../pg_tblspc/16387&#39=
; to &#39;/opt/PostgresPlus/tablespace1&#39; dynamicaly?<br><br>and Is it p=
ossible that we define exiting tablespace location at the time of restore d=
atabase on another server?<br>
<br>Please give me solution for that.<br><br><br>Thank You.<br><br>Regards,=
<br>Karuna Karpe.<br>


[prev in list] [next in list] [prev in thread] [next in thread]