Re: Unable to reload postgresql.conf without restarting - Mailing list pgsql-admin

From Matheus de Oliveira
Subject Re: Unable to reload postgresql.conf without restarting
Date
Msg-id CAJghg4L7ebvAUznA9aDs2OOSSkfBuYJ-SXnpNwo0MkKZ7aDNcQ@mail.gmail.com
Whole thread Raw
In response to Re: Unable to reload postgresql.conf without restarting  (Scott Ribe <scott_ribe@elevated-dev.com>)
List 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 by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Unable to reload postgresql.conf without restarting
Next
From: Walter Hurry
Date:
Subject: Re: Migración