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.
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
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