Re: Unable to reload postgresql.conf without restarting

Поиск
Список
Период
Сортировка
От Matheus de Oliveira
Тема Re: Unable to reload postgresql.conf without restarting
Дата
Msg-id CAJghg4L7ebvAUznA9aDs2OOSSkfBuYJ-SXnpNwo0MkKZ7aDNcQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Unable to reload postgresql.conf without restarting  (Scott Ribe <scott_ribe@elevated-dev.com>)
Список pgsql-admin


On Thu, Jan 3, 2013 at 4:02 PM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
On Jan 3, 2013, at 10:30 AM, Matheus de Oliveira wrote:

> They should have been reloaded. Have you set them by role, database or tablespace?
> Or even, has them been set, by mistake, twice at postgresql.conf? If so, the last one
> will be used.

Also make sure you're changing the right postgresql.conf, that the server wasn't started with a different one than you think.


Yep. The config_file parameter can be used to check it:

SHOW config_file;

Regards,
--
Matheus de Oliveira
Analista de Banco de Dados PostgreSQL
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

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

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: Unable to reload postgresql.conf without restarting
Следующее
От: Walter Hurry
Дата:
Сообщение: Re: Migración