Re: Strange problem with turning WAL archiving on

Hi Albe,

On Nov 30, 2011, at 2:31 PM, Albe Laurenz wrote:
> Verify the current setting with
>
> SELECT setting, source, boot_val, reset_val,
> sourcefile, sourceline
> FROM pg_settings WHERE name = 'wal_level';
>
> If the setting is not right (which is likely the case), try to find out
> the cause.

This query shows that the settings are still on minimal. Strange. As I can see there is just one postgresql.conf file (in the data directory) of the 9.1 installation. Everything is changed inside it according to the specs. Wal_level is on archive. I even tried renaming the file, to see if when I reboot PostgreSQL I would get an error. I got an error and therefor it is the .conf that the DBMS uses.

> Did you change the correct postgresql.conf?
> Are there more than one lines for wal_level in the file
> (try "grep wal_level postgresql.conf")?

I tried greping, there is just one nstance of it and is set on archive.

Any other ideas what could have gone wrong in this strange situation?

Best regards,
BK

>
> Yours,
> Laurenz Albe
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general