Обсуждение: Re: Problem starting two postgresql clusters on the same host

Поиск
Список
Период
Сортировка

Re: Problem starting two postgresql clusters on the same host

От
Michael Banck
Дата:
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

Problem starting two postgresql clusters on the same host

От
Ibrahim Shaame
Дата:
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

Re: Problem starting two postgresql clusters on the same host

От
Ibrahim Shaame
Дата:
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@gmail.com> 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