Re: [GENERAL] corrupted statistics file "pg_stat_tmp/pgstat.stat"

2012-08-15 Thread Carl von Clausewitz
) output is unlimited. I'll be back (:-)) within few days with the results. Thank you all the informations. Regards, Csaba -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Wednesday, August 15, 2012 3:34 PM To: Carl von Clausewitz Cc: pgsql-general@postgresql.o

Re: [GENERAL] corrupted statistics file "pg_stat_tmp/pgstat.stat"

2012-08-15 Thread Carl von Clausewitz
Alban Hertroys [mailto:haram...@gmail.com] Sent: Wednesday, August 15, 2012 3:33 PM To: Carl von Clausewitz Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] corrupted statistics file "pg_stat_tmp/pgstat.stat" On 15 August 2012 09:57, Carl von Clausewitz wrote: > I’ve restored f

Re: [GENERAL] corrupted statistics file "pg_stat_tmp/pgstat.stat"

2012-08-15 Thread Tom Lane
"Carl von Clausewitz" writes: > 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 err

Re: [GENERAL] corrupted statistics file "pg_stat_tmp/pgstat.stat"

2012-08-15 Thread Alban Hertroys
On 15 August 2012 09:57, Carl von Clausewitz wrote: > I’ve restored from TAR backup our databases, and everything looked fine. What exactly is in that TAR backup? Is that a tar/gzipped PG dump or a file-system snapshot? If the latter: - did you halt the database while creating the snapshot or at

Re: [GENERAL] corrupted statistics file "pg_stat_tmp/pgstat.stat"

2012-08-15 Thread Amitabh Kant
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 wrote: > Hi All, > > ** ** > > I

[GENERAL] corrupted statistics file "pg_stat_tmp/pgstat.stat"

2012-08-15 Thread Carl von Clausewitz
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