From: | Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com> |
---|---|
To: | Prince Pathria <prince(dot)pathria(at)goevive(dot)com> |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Shared data dir for multiple postgresql nodes |
Date: | 2018-12-20 11:43:41 |
Message-ID: | CAGDYbUPdwVWDe7mtD-mJf8N=JeWj7AkpzoSqpysfyu8b=DP_XQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Shreeyansh Dba | 2018-12-20 12:17:14 | Re: Bulk_insert in postgresql like Microsoft SQL server |
Previous Message | Robert Simmons | 2018-12-20 09:20:54 | Re: pg_attribute getting bloated in size |