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

Поиск
Список
Период
Сортировка
От Vijaykumar Jain
Тема Re: [External] Shared data dir for multiple postgresql nodes
Дата
Msg-id CAE7uO5jEdAdBqZtNBa=eAHbvftUJ4XM_ORJn4GZXzABJ_Nn=cA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [External] Shared data dir for multiple postgresql nodes  (Vijaykumar Jain <vjain@opentable.com>)
Ответы Re: [External] Shared data dir for multiple postgresql nodes
Список 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 по дате отправления:

Предыдущее
От: Vijaykumar Jain
Дата:
Сообщение: Re: [External] Shared data dir for multiple postgresql nodes
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: [External] Shared data dir for multiple postgresql nodes