Re: Adding another cluster on same machine

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Adding another cluster on same machine
Date: 2020-12-04 19:37:16
Message-ID: CAKFQuwajc0uEXkGRBo2vuCxK9Dv9WR_qHZvbcye9tfKn8HOz5Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Dec 4, 2020 at 10:10 AM Ron <ronljohnsonjr(at)gmail(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jwiencek3 2020-12-04 20:48:34 Re: Adding another cluster on same machine
Previous Message Ron 2020-12-04 17:10:04 Re: Adding another cluster on same machine