Re: Shared data dir for multiple postgresql nodes

Thanks everyone!

Happy to help :)
Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com

On Thu, Dec 20, 2018 at 5:13 PM Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
wrote:

> Hi Prince,
> pg_ctl -D /data/postgres -o "-p 5432" -l /var/log/pg1 startpg_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(dot)pathria(at)goevive(dot)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
>>
>