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.
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?