Hi Christoph, On 09/20/2011 03:36 PM, Christoph Berg wrote: > Re: Paolo Scarabelli 2011-09-20 <[email protected]> >> To fix the problem I had to purge and reinstall 9.1 (erasing all the >> data) and restored the database from a backup (Note that at this point I >> restored only the smaller of the databases). > > Did you also restore the postgresql.conf?
No, I left everything as default (as installed by the deb package). > Please check the following: > > $ grep -H shared_buffers /etc/postgresql/*/*/postgresql.conf > $ sysctl -a 2> /dev/null | grep kernel.shm $ grep -H shared_buffers /etc/postgresql/*/*/postgresql.conf /etc/postgresql/9.1/main/postgresql.conf:shared_buffers = 24MB # min 128kB /etc/postgresql/9.1/main/postgresql.conf:#wal_buffers = -1 # min 32kB, -1 sets based on shared_buffers $ sysctl -a 2> /dev/null | grep kernel.shm kernel.shmmax = 33554432 kernel.shmall = 2097152 kernel.shmmni = 4096 > If the sum of the first output(s) is larger than kernel.shmmax, there > is the problem. It doesn't seem to be the case, however I forgot to mention this is not the first time I upgrade postgres on this machine, sure I did it from 8.3 -> 8.4 -> 9.0 -> 9.1, perhaps the upgrade script kept importing some old settings from the previous version. This weekend I will purge 9.1, reinstall 9.0 and restore all the databases. Then I will repeat the upgrade process again to see if I can repeat the issue. Thanks again, Paolo. -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected]
