Re: log entries after pitr recovery

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chris Hoover" <revoohc(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: log entries after pitr recovery
Date: 2006-07-21 21:18:03
Message-ID: 7984.1153516683@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Chris Hoover" <revoohc(at)gmail(dot)com> writes:
> ,11962,,2006-07-13 16:11:16.281 EDT,,360,,,,LOG: invalid server process ID
> -1

See 8.1.4 fix:

2006-03-30 17:11 tgl

* src/backend/storage/smgr/smgr.c (REL8_1_STABLE): Suppress
attempts to report dropped tables to the stats collector from a
startup or recovery process. Since such a process isn't a real
backend, pgstat.c gets confused. This accounts for recent reports
of strange "invalid server process ID -1" log messages during crash
recovery. There isn't any point in attempting to make the report,
since we'll discard stats in such scenarios anyhow.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message roberto ms 2006-07-22 20:11:46 Postgres won´t restart after system crash
Previous Message Chris Hoover 2006-07-21 19:42:15 log entries after pitr recovery