Re: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start

Поиск
Список
Период
Сортировка
От David Rovner
Тема Re: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start
Дата
Msg-id F543E86A0B415E41806A68AA76E3C7F401A0FE9D@mailman.teve.inc
обсуждение исходный текст
Ответ на Re: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Wednesday, October 10, 2007 10:57 AM
> To: David Rovner
> Cc: Steve Crawford; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] persistent 'psql: FATAL: "listen_addresses"
cannot be
> changed after server start
>
> "David Rovner" <DRovner@princetonservergroup.com> writes:
> > PGOPTIONS is set to -i
>
> Well, that's equivalent to --listen_addresses=*, so that's your
problem.
>
>             regards, tom lane

Yes. Found it. My .bash_profile had PGOPTIONS set to -i. Some leftover
debug before I started using the "service postgresql start" methods.
There had been a 2 month gap since I've been on the box with that
change.

Thanks for all your help!

Dave

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start
Следующее
От: Decibel!
Дата:
Сообщение: Re: warm/hot backup of Postgresql