Re: Problem starting two postgresql clusters on the same host - Mailing list pgsql-admin

From Michael Banck
Subject Re: Problem starting two postgresql clusters on the same host
Date
Msg-id 61fe493f.1c69fb81.5e2db.903c@mx.google.com
Whole thread Raw
In response to Problem starting two postgresql clusters on the same host  (Ibrahim Shaame <ishaame@gmail.com>)
List pgsql-admin
On Sat, Feb 05, 2022 at 12:41:37PM +0100, Ibrahim Shaame wrote:
> I have created two postgresql clusters on the same host, which work
> perfectly when started individually and manually. But when putting them on
> start script, only one loads and the other fails. Any hint? My installation
> is postgresql 14.1 on Slackware 15 and my rc.postgresql looks like this:
> 
> # Start PostgreSQL:
> postgresql_start() {
>   if [ -x /data/apps/postgresql/pgsql141/bin/pg_ctl ]; then
>     su - postgres -c "/data/apps/postgresql/pgsql141/bin/pg_ctl -D
> /data/apps/postgresql/pgsql141/data start &"
>  su - postgres -c "/data/apps/postgresql/pgsql141/bin/pg_ctl -o "-p 5433"
> -D /data/apps/postgresql/pgsql141/data2 start & "

Is this verbatim, or a copy-pasto? You have four " in there, you need to
escape the "-p 5433" like \"-p 5433\" or else the command will stop at
-o".


Michael



pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: any impact to DML sql statements when checkpoint starting
Next
From: Ibrahim Shaame
Date:
Subject: Problem starting two postgresql clusters on the same host