pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed8.4 process killed- what sort of recovery options do I have?
2+ messages / 2 participants
[nested] [flat]
* 8.4 process killed- what sort of recovery options do I have?
@ 2010-11-18 17:42 Wells Oliver <woliver@padres.com>
2010-11-18 18:04 ` Re: 8.4 process killed- what sort of recovery options do I have? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Wells Oliver @ 2010-11-18 17:42 UTC (permalink / raw)
To: pgsql-admin
For whatever reason- investigations still pending- the postgres process
froze up and I had to do a killall b/c pg_ctlcluster would not revive
the thing. Everything seems to be in working order, but I'd like to know
if there's any kind of consistency check I should run in light of
events. Also, what's the best way to track down the reason for the
crash? Just get into /var/log/postgresql and poke around?
Thanks.
--
Wells Oliver
Developer, Baseball Systems
San Diego Padres | 100 Park Boulevard | San Diego CA 92101
619-795-5359
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: 8.4 process killed- what sort of recovery options do I have?
2010-11-18 17:42 8.4 process killed- what sort of recovery options do I have? Wells Oliver <woliver@padres.com>
@ 2010-11-18 18:04 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2010-11-18 18:04 UTC (permalink / raw)
To: Wells Oliver <woliver@padres.com>; +Cc: pgsql-admin
Wells Oliver <woliver@padres.com> writes:
> For whatever reason- investigations still pending- the postgres process
> froze up and I had to do a killall b/c pg_ctlcluster would not revive
> the thing. Everything seems to be in working order, but I'd like to know
> if there's any kind of consistency check I should run in light of
> events. Also, what's the best way to track down the reason for the
> crash? Just get into /var/log/postgresql and poke around?
I don't think you need to worry about your data. Crash recovery is a
well-tested aspect of Postgres ;-). As for figuring out what happened,
did you force core dumps? Stack traces from the dumps would be most
useful.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-11-18 18:04 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-11-18 17:42 8.4 process killed- what sort of recovery options do I have? Wells Oliver <woliver@padres.com>
2010-11-18 18:04 ` 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