David Kerr <d...@mr-paradox.net> writes: > I just restored a DB from a cold backup (pg_ctl stop -m fast)
> When starting the DB I see: > LOG: corrupted statistics file "global/pgstat.stat" Is that repeatable? It wouldn't be too surprising to see this once when starting from a filesystem backup, if you'd managed to capture a partially written stats file in the backup. > When I look at the filesystem I don't see a global/pgstat.stat file but i do > see a > pg_stat_tmp/pgstat.stat This is normal --- global/pgstat.stat is only supposed to exist when the system is shut down. Transient updates are written into pg_stat_tmp/ > Are those stats related to pg_stats style statistics? No, this file is for the stats collection subsystem, http://www.postgresql.org/docs/9.1/static/monitoring-stats.html regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
