| From: | Karuna Karpe <karuna(dot)karpe(at)os3infotech(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org, Ashish Nauriyal <ashish(dot)nauriyal(at)enterprisedb(dot)com> |
| Subject: | tablespace backup and recovery from or to remote machine |
| Date: | 2011-12-15 11:45:57 |
| Message-ID: | CAC-LqboK66=7+4E2-OVYnNdYfWnz0hy-QdVkMQRrTRvyqLOupA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)192(dot)168(dot)0(dot)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(at)192(dot)168(dot)0(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | P R | 2011-12-15 16:01:24 | Resuming Incomplete Pg-restore Tasks |
| Previous Message | Brian Mutinda | 2011-12-15 05:44:37 | PostgreSql Startup Error |