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(
> 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