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