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