Jose Martinez writes:
> Hi,
>
> I made some changes to?postgresql.conf and I want them to take effect without
> having to restart the server.
Check your server log for any report of a syntax error in your .conf
file.
If there is one, that will prevent the changes being loaded.
pg_reload_conf(
On Thu, Jan 3, 2013 at 4:02 PM, Scott Ribe 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
> > wil
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 postg
> Hi,
>
> I made some changes to postgresql.conf and I want them to take effect
without
> having to restart the server.
>
> I tried
>
> select pg_reload_conf();
> /usr/pgsql-9.1/bin/pg_ctl reload
>
> but when I do 'show all', I see no changes take effect.
>
> There settings I tried to change are:
>
On Thu, Jan 3, 2013 at 2:25 PM, Jose Martinez wrote:
> Hi,
>
> I made some changes to postgresql.conf and I want them to take effect
> without having to restart the server.
>
> I tried
>
> select pg_reload_conf();
> /usr/pgsql-9.1/bin/pg_ctl reload
>
> but when I do 'show all', I see no changes ta
On Thu, Jan 3, 2013 at 11:25:41AM -0500, Jose Martinez wrote:
> Hi,
>
> I made some changes to postgresql.conf and I want them to take effect without
> having to restart the server.
>
> I tried
>
> select pg_reload_conf();
> /usr/pgsql-9.1/bin/pg_ctl reload
>
> but when I do 'show all', I see
Hi,
I made some changes to postgresql.conf and I want them to take effect
without having to restart the server.
I tried
select pg_reload_conf();
/usr/pgsql-9.1/bin/pg_ctl reload
but when I do 'show all', I see no changes take effect.
There settings I tried to change are:
-effective_cache_size
