Re: [External] Shared data dir for multiple postgresql nodes
От | Achilleas Mantzios |
---|---|
Тема | Re: [External] Shared data dir for multiple postgresql nodes |
Дата | |
Msg-id | ee4ad7e4-f32c-564e-d38c-f53aa9368d07@matrix.gatewaynet.com обсуждение исходный текст |
Ответ на | Re: [External] Shared data dir for multiple postgresql nodes (Vijaykumar Jain <vjain@opentable.com>) |
Список | 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,VijayOn 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,VijayOn 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 54322. listening on port 5433What 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
-- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt
В списке pgsql-admin по дате отправления: