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: | Raw Message | Whole Thread | 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 |