Re: Problem starting two postgresql clusters on the same host

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