Re: Shared data dir for multiple postgresql nodes

Le jeu. 20 déc. 2018 à 16:28, Ron <ronljohnsonjr(at)gmail(dot)com> a écrit :

> On 12/20/18 2:41 AM, Prince Pathria 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
>
>
> I don't think Postgres will even let you install the second node in the
> same directory.
>
> Also, you should name the directories /postgres/data Postgres expects to
> be installed in a directory named "data".
>
>
No, the directory's name doesn't matter.

In fact, if you install Postgres from postgresql.org packages, it'll
> install it in "X.Y/data", where X is the major version number, and Y is
> the minor version number.
>
>
>

--
Guillaume.