I run the same config (FreeBSD 9 with PG 9.1.x) on couple of servers, and they seem to be working fine without any error messages. The only other setting I have in my sysctl.conf is kern.maxfiles .
Amitabh On Wed, Aug 15, 2012 at 1:27 PM, Carl von Clausewitz <clausewit...@gmail.com > wrote: > Hi All,**** > > ** ** > > I’ve just made a clean install for PostgreSQL 9.1 > (postgresql-server-9.1.4, postgresql-contrib-9.1.4) on a FreeBSD 9 (FreeBSD > 9.0-RELEASE-p3 FreeBSD 9.0-RELEASE-p3 #0: Tue Jun 12 02:52:29 UTC 2012 > r...@amd64-builder.daemonology.net:/usr/obj/usr/src/sys/GENERIC amd64). * > *** > > ** ** > > I’ve restored from TAR backup our databases, and everything looked fine. > Without changing any setting in postgresql.conf (or in kernel settings) – > only “track_counts=on”, after 2-3 days, I’m receiving huge number (~5-10 > PCS in every second) of error messages like that in /var/log/postgresql.log: > **** > > ** ** > > *** Aug 15 06:27:26 eurodb postgres[77652]: [43-1] WARNING: corrupted > statistics file "pg_stat_tmp/pgstat.stat"**** > > ** ** > > The logs are going to the syslog, and there are no more Warning, Error, or > other messages. If I do a full Vacuum on the database, and I restart the > system, everything works fine, no more error messages, until 2-3 days – and > everything starts from the beginning. **** > > ** ** > > Two weeks ago, we just bought a new server, I’ve installed the same > version of FreeBSD and PostgreSQL, and there is the same problem on that > machine too – without any usage, or load, this is a test server for us now. > **** > > ** ** > > The disks (SATA3 HDD), and the controllers has been tested, they are OK. > All the directories’ permissons are the defaults, pg_stat_temp is owned by > pgsql:pgsql – so I think this is not a permission issue. **** > > ** ** > > I’m trying to tune my config with pgtune, and I’ve made some changes on > sysctl for the following: **** > > ** ** > > kern.ipc.semmni="512"**** > > kern.ipc.semmns="1024"**** > > kern.ipc.semume="64"**** > > kern.ipc.semmnu="512"**** > > ** ** > > I will restart the machines today, and will see, what’s going on. Did > anybody has seen this problem before? On our early version 9.0.8 PostgreSQL > server, there wasn’t any kind of problem, but it was a FreeBSD 8.2. How can > I investigate, what could be the problem? Kernel settings? Or any other > idea? **** > > ** ** > > Thank you in advance. **** > > ** ** > > Best regards,**** > > Csaba**** >
