Re: [External] Shared data dir for multiple postgresql nodes - Mailing list pgsql-admin

From Vijaykumar Jain
Subject Re: [External] Shared data dir for multiple postgresql nodes
Date
Msg-id CAE7uO5jEdAdBqZtNBa=eAHbvftUJ4XM_ORJn4GZXzABJ_Nn=cA@mail.gmail.com
Whole thread Raw
In response to Re: [External] Shared data dir for multiple postgresql nodes  (Vijaykumar Jain <vjain@opentable.com>)
Responses Re: [External] Shared data dir for multiple postgresql nodes  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-admin
ah i did not see that -D /data/postgres on both.

yes on this.
--Corruption is probably the first thing you'll have to assume.

Regards,
Vijay


On Thu, Dec 20, 2018 at 2:38 PM Vijaykumar Jain <vjain@opentable.com> wrote:
then what is the point of multi master :) 
if the server goes down, both go down.

other than that, having multiple servers may act as noisy neighbors to each other.


Regards,
Vijay


On Thu, Dec 20, 2018 at 2:11 PM Prince Pathria <prince.pathria@goevive.com> wrote:
Hi,
I'm asking this out of curiosity, if I have 2 postgres nodes on same server,
1. listening on port 5432
2. listening on port 5433

What issue's I might face if I do it like this? Assuming I'm doing this for multimaster approach.

pg_ctl -D /data/postgres -o "-p 5432" -l /var/log/pg1 start
pg_ctl -D /data/postgres -o "-p 5433" -l /var/log/pg2 start

Happy to help :)
Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com

pgsql-admin by date:

Previous
From: Vijaykumar Jain
Date:
Subject: Re: [External] Shared data dir for multiple postgresql nodes
Next
From: Achilleas Mantzios
Date:
Subject: Re: [External] Shared data dir for multiple postgresql nodes