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.
