pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
log entries after pitr recovery
2+ messages / 2 participants
[nested] [flat]

* log entries after pitr recovery
@ 2006-07-21 19:42  Chris Hoover <revoohc@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Chris Hoover @ 2006-07-21 19:42 UTC (permalink / raw)
  To: pgsql-admin

I have been testing pitr with my development system.  After the system
rolled forward, I recieve a ton of errors right after it come on line.  I'm
assuming these are fine and just the system cleaning up, but I wanted to
make sure.

Thanks,

Chris

,11962,,2006-07-13 16:11:16.281 EDT,,360,,,,LOG:  invalid server process ID
-1
,11962,,2006-07-13 16:11:16.281 EDT,,361,,,,LOG:  invalid server process ID
-1
,11962,,2006-07-13 16:11:16.281 EDT,,362,,,,LOG:  invalid server process ID
-1
,11962,,2006-07-13 16:11:16.281 EDT,,363,,,,LOG:  invalid server process ID
-1

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: log entries after pitr recovery
@ 2006-07-21 21:18  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Chris Hoover <revoohc@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2006-07-21 21:18 UTC (permalink / raw)
  To: Chris Hoover <revoohc@gmail.com>; +Cc: pgsql-admin

"Chris Hoover" <revoohc@gmail.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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-07-21 21:18 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-07-21 19:42 log entries after pitr recovery Chris Hoover <revoohc@gmail.com>
2006-07-21 21:18 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox