Re: pg_ctl -w start does not know that it has started postmaster

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_ctl -w start does not know that it has started postmaster
Дата
Msg-id 18508.1101158175@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_ctl -w start does not know that it has started postmaster  (Aaron Hillegass <aaron@bignerdranch.com>)
Список pgsql-bugs
Aaron Hillegass <aaron@bignerdranch.com> writes:
> I have a script that must start the postmaster before continuing, so I
> do this:

> sudo -u postgres /Library/PostgreSQL/bin/pg_ctl -w start

This is not going to work very well because sudo doesn't update the
environment --- for example if PGUSER is set in your environment then
that's the username pg_ctl will try to use to connect with.  Perhaps
try

sudo su -l postgres -c '/Library/PostgreSQL/bin/pg_ctl -w start'

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Data corruption/loss when altering tables (fwd)
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Data corruption/loss when altering tables (fwd)