Re: Problem starting two postgresql clusters on the same host

[Ibrahim Shaame <ishaame@xxxxxxxxx>]

Thank you Holger and others. That was it changed the in -p 5433 into one quote and it works

Thanks

On Sat, Feb 5, 2022 at 12:41 PM Ibrahim Shaame <ishaame@xxxxxxxxx> 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 & "
  fi 

####

Incidentally, when I change to postgres user and run the command of the second cluster in a terminal it runs perfectly. Otherwise if I source it in a terminal, be root or postgres user I get an error message:

pg_ctl: no operation specified

Thanks in advance

Ibrahim Shaame