Postgres Pro
Downloads
Home   >   mailing lists

Re: Adding another cluster on same machine - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Adding another cluster on same machine
Date
Msg-id CAKFQuwajc0uEXkGRBo2vuCxK9Dv9WR_qHZvbcye9tfKn8HOz5Q@mail.gmail.com
Whole thread Raw
In response to Re: Adding another cluster on same machine  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
Tree view
On Fri, Dec 4, 2020 at 10:10 AM Ron <ronljohnsonjr@gmail.com> wrote:

The problem might be that you have to do the initdb after "systemctl start  postgresql-10.service".

No.  You definitely need to initialize the database cluster before you try starting it.

> -bash-4.2$ /usr/pgsql-10/bin/postgresql-10-setup initdb -D
> /var/lib/pgsql/10/data-log -p 5433
> systemctl: invalid option -- 'D'
> failed to find PGDATA setting in -D.service

This made-up command is the problem.

After some searching I found this:

https://git.postgresql.org/gitweb/?p=pgrpms.git;a=blob_plain;f=rpm/redhat/master/non-common/postgresql-10/master/postgresql-10-README-systemd.rpm-dist;hb=HEAD

The section titled: "MULTIPLE POSTMASTERS (For the same PostgreSQL version)"

Though, if you don't care about systemd just ignore all the RPM-specific stuff and follow the instructions in the PostgreSQL documentation.  IOW, don't use "postgresql-10-setup".

David J.


pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: Adding another cluster on same machine
Next
From: Jwiencek3
Date:
Subject: Re: Adding another cluster on same machine