Re: Testing hot standby on same server sharing same tablespace directory

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