Re: 7.3 pg_ctl anomaly

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 7.3 pg_ctl anomaly
Дата
Msg-id 13936.1039012445@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 7.3 pg_ctl anomaly  (Ed L. <pggeneral@bluepolka.net>)
Список pgsql-general
"Ed L." <pggeneral@bluepolka.net> writes:
> When I run this command in 7.3,
>     pg_ctl -w -o "-p 15432" start
> it successfully starts the database, but the -w flag doesn't seem to
> notice the successful start and continues to wait until finally
> saying "postmaster does not start" and giving up.

I believe the issue is that pg_ctl doesn't understand that you're
starting the postmaster on a nonstandard port.  Its method of detecting
postmaster startup is to try to log in with psql, so if it's trying
the wrong port this is exactly what will happen.

I have not tried it, but I think it'd work to do this instead:

    export PGPORT=15432
    pg_ctl start

Making your example work as given would mean teaching the pg_ctl
script to parse postmaster options, which seems like way more
trouble than it's worth ...

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Diogo Biazus
Дата:
Сообщение: mod_auth_pgsql
Следующее
От: Matthew Gabeler-Lee
Дата:
Сообщение: Re: 7.3 no longer using indexes for LIKE queries