On 04/28/2016 08:45 AM, Sreekanth Palluru wrote: > > 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 ? Both instances will start and initially appear to function, but you are guaranteed to run into unexpected behaviour and some kind of corruption. Try e.g. creating and populating a table, then pausing replay on the standby; then drop and recreate/repopulate the same table. > I was expecting some sort of warnings from Postgres or am I missing something No, there's nothing which could warn about this particular scenario. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
