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

From Achilleas Mantzios
Subject Re: [External] Shared data dir for multiple postgresql nodes
Date
Msg-id ee4ad7e4-f32c-564e-d38c-f53aa9368d07@matrix.gatewaynet.com
Whole thread Raw
In response to Re: [External] Shared data dir for multiple postgresql nodes  (Vijaykumar Jain <vjain@opentable.com>)
List pgsql-admin
On 20/12/18 11:09 π.μ., Vijaykumar Jain wrote:
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.

Most likely 2nd PostgreSQL "master" will not even start.


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


-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt

pgsql-admin by date:

Previous
From: Vijaykumar Jain
Date:
Subject: Re: [External] Shared data dir for multiple postgresql nodes
Next
From: Robert Simmons
Date:
Subject: Re: pg_attribute getting bloated in size