Re: Problem starting two postgresql clusters on the same host

Поиск
Список
Период
Сортировка
От Michael Banck
Тема Re: Problem starting two postgresql clusters on the same host
Дата
Msg-id 61fe493f.1c69fb81.5e2db.903c@mx.google.com
обсуждение исходный текст
Ответ на Problem starting two postgresql clusters on the same host  (Ibrahim Shaame <ishaame@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: any impact to DML sql statements when checkpoint starting
Следующее
От: Ibrahim Shaame
Дата:
Сообщение: Problem starting two postgresql clusters on the same host