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

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,
> Vijay
>
>
> On Thu, Dec 20, 2018 at 2:38 PM Vijaykumar Jain <vjain(at)opentable(dot)com <mailto:vjain(at)opentable(dot)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(dot)pathria(at)goevive(dot)com <mailto: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/pg1start|
>
> |
>
> |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 <http://goevive.com>
>

--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt