On 30 Listopad 2011, 17:23, BK wrote: > 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. Silly idea - the wal_level option is commented out by default. Are you sure you've removed the '#' at the beginning? Tomas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
