Re: Strange problem with turning WAL archiving on - Mailing list pgsql-general

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
(inthe 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
thereforit 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general