Re: [External] Shared data dir for multiple postgresql nodes

[Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxx> 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@xxxxxxxxxxx> 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