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

From: Vijaykumar Jain <vjain(at)opentable(dot)com>
To: Prince Pathria <prince(dot)pathria(at)goevive(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: [External] Shared data dir for multiple postgresql nodes
Date: 2018-12-20 09:09:52
Message-ID: CAE7uO5jEdAdBqZtNBa=eAHbvftUJ4XM_ORJn4GZXzABJ_Nn=cA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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>
> 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
>>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2018-12-20 09:18:16 Re: [External] Shared data dir for multiple postgresql nodes
Previous Message Vijaykumar Jain 2018-12-20 09:08:21 Re: [External] Shared data dir for multiple postgresql nodes