Hi
I am testing hot standby on same server (version 9.5.2) , everything works well. I have a doubt regarding sharing of tablespace directory by these two databases .
I have created a tablespace and moved few objects and I happen to see that same directory was being used by standby node aka slave node and to my surprise it still works without any issues.
Is this expected ? I was expecting some sort of warnings from Postgres or am I missing something
Master $PGDATA
[pg952@pdb-poc01 pg_tblspc]$ pwd
/opt/v9.5.2/data/pg_tblspc
[pg952@pdb-poc01 pg_tblspc]$ ls -ltr
total 0
lrwxrwxrwx. 1 pg952 dba 17 Apr 27 16:10 16495 -> /opt/v9.5.2/tbsp1
[pg952@pdb-poc01 pg_tblspc]$
I can access the tables
[pg952@pdb-poc01 pg_tblspc]$ psql -d abcd -p 5432
psql (9.5.2)
Type "help" for help.
ssint=# select count(*) from t_random;
count
---------
8000000
(1 row)
ssint=#
Standby/Slave $PGDATA
[pg952@pdb-poc01 pg_tblspc]$ pwd
/home/postgres95/data/pg_tblspc
[pg952@pdb-poc01 pg_tblspc]$ ls -ltr
total 0
lrwxrwxrwx. 1 pg952 dba 17 Apr 27 16:10 16495 -> /opt/v9.5.2/tbsp1
[pg952@pdb-poc01 pg_tblspc]$
[pg952@pdb-poc01 16412]$ psql -d abcd -p 54321
psql (9.5.2)
Type "help" for help.
ssint=# delete from t_random;
ERROR: cannot execute DELETE in a read-only transaction
ssint=# select count(*) from t_random;
count
---------
8000000
(1 row)
ssint=#
-Sreekanth