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