Re: Shared data dir for multiple postgresql nodes

Поиск
Список
Период
Сортировка
От Shreeyansh Dba
Тема Re: Shared data dir for multiple postgresql nodes
Дата
Msg-id CAGDYbUPdwVWDe7mtD-mJf8N=JeWj7AkpzoSqpysfyu8b=DP_XQ@mail.gmail.com
обсуждение исходный текст
Ответ на Shared data dir for multiple postgresql nodes  (Prince Pathria <prince.pathria@goevive.com>)
Ответы Re: Shared data dir for multiple postgresql nodes  (Prince Pathria <prince.pathria@goevive.com>)
Список pgsql-admin
Дерево обсуждения 
Hi Prince,

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
The first thing you can not run the same instance with a different port in the single data directory, as we suspect you are trying to run two instances with the different port in the same data directory.
However, you can run two DB instance on the same server using different data directory with a different port, you may face below issue if you are planning to keep two DB instance on the same server.

 Application, disk IO performance will decrease
 Due to a cause of any disaster both the instance will crash.
 Data loss,downtime,data corruption etc.. 

Thanks & Regards,
Shreeyansh DBA Team
Phone: +91-9552687400
www.shreeyansh.com


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 по дате отправления:

Предыдущее
От: Robert Simmons
Дата:
Сообщение: Re: pg_attribute getting bloated in size
Следующее
От: Shreeyansh Dba
Дата:
Сообщение: Re: Bulk_insert in postgresql like Microsoft SQL server