pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Database in recovery mode
2+ messages / 2 participants
[nested] [flat]

* Database in recovery mode
@ 2000-08-04 18:48  Michael Richards <michael@fastmail.ca>
  0 siblings, 1 reply; 2+ messages in thread

From: Michael Richards @ 2000-08-04 18:48 UTC (permalink / raw)
  To: pgsql-sql

Hi.

I've got a postgres system that keeps going into recovery mode. I 
can't really find any docs on this. All of the postgres processes 
will be in the STOP state and when I try to connect it will say "The 
database is in recovery mode".

I suspect there is a query that is causing it to crash in some 
specific way that causes it. This is happening about once per day.

Any ideas?

-Michael
_________________________________________________________________
     http://fastmail.ca/ - Fast Free Web Email for Canadians

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

* Re: Database in recovery mode
@ 2000-08-06 05:45  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Michael Richards <michael@fastmail.ca>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2000-08-06 05:45 UTC (permalink / raw)
  To: Michael Richards <michael@fastmail.ca>; +Cc: pgsql-sql

"Michael Richards" <michael@fastmail.ca> writes:
> I've got a postgres system that keeps going into recovery mode. I 
> can't really find any docs on this. All of the postgres processes 
> will be in the STOP state and when I try to connect it will say "The 
> database is in recovery mode".

> I suspect there is a query that is causing it to crash in some 
> specific way that causes it. This is happening about once per day.

Sounds like that to me too.  Are any core dump files showing up in the
database directory (PGDATA/base/DBNAME/core)?  If so a stack trace
from the corefile would be informative.  Also, make sure you are
collecting a postmaster log --- do NOT start the postmaster with -S,
instead direct its stdout and stderr into a logfile --- and see if
anything interesting is recorded therein.  You might want to start the
postmaster with -d2 so that the actual queries are logged too.

			regards, tom lane



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


end of thread, other threads:[~2000-08-06 05:45 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-08-04 18:48 Database in recovery mode Michael Richards <michael@fastmail.ca>
2000-08-06 05:45 ` 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