I was able to get things up and running OK.
Don't have any WAL that I'm aware of, but it managed to have another
power failure hours later.
I seems that the UPS is more POS than UPS. I think the battery is dead.
On Dec 2, 2007, at 3:52 AM, Greg Smith wrote:
On Sat, 1 Dec 2007, Joshua
On Sat, 1 Dec 2007, Joshua D. Drake wrote:
change wal_sync_method to open_sync and fsync=on isn't nearly as bad as
it sounds.
Just be warned that there's been one report that some Linux versions have
bugs that make open_sync problematic:
Tom Lane wrote:
Tom Allison [EMAIL PROTECTED] writes:
2007-11-30 19:35:20 EST PANIC: could not locate a valid checkpoint
record
Ugh :-(. pg_resetxlog should get you back into the database, but it's
anybody's guess whether and how badly the contents will be corrupted.
I would recommend
Tom Lane wrote:
Tom Allison [EMAIL PROTECTED] writes:
2007-11-30 19:35:20 EST PANIC: could not locate a valid checkpoint
record
Ugh :-(. pg_resetxlog should get you back into the database, but it's
anybody's guess whether and how badly the contents will be corrupted.
I would recommend
On Sat, 01 Dec 2007 15:22:38 -0500
Tom Allison [EMAIL PROTECTED] wrote:
regards, tom lane
Cool, thanks.
I wonder what I'm supposed to do with my debian installation since
there doesn't seem to be any such thing as pg_resetxlog. Or is it
hiding somewhere?
I don't recall if it is
On Sat, 01 Dec 2007 15:32:50 -0500
Tom Allison [EMAIL PROTECTED] wrote:
I tracked it down and did a reset.
I only have one large table right now.
And now I've decided to start using fsync=on!!! :)
change wal_sync_method to open_sync and fsync=on isn't nearly as bad as
it sounds.
joshua
Tom Allison escribió:
I wonder what I'm supposed to do with my debian installation since there
doesn't seem to be any such thing as pg_resetxlog. Or is it hiding
somewhere?
On one debian I have:
/usr/lib/postgresql/8.1/bin/pg_resetxlog
/usr/lib/postgresql/8.2/bin/pg_resetxlog
Joshua D. Drake escribió:
On Sat, 01 Dec 2007 15:22:38 -0500
I wonder what I'm supposed to do with my debian installation since
there doesn't seem to be any such thing as pg_resetxlog. Or is it
hiding somewhere?
I don't recall if it is in contrib or not.. try?:
apt-file is your friend:
Tom Allison [EMAIL PROTECTED] writes:
2007-11-30 19:35:20 EST PANIC: could not locate a valid checkpoint
record
Ugh :-(. pg_resetxlog should get you back into the database, but it's
anybody's guess whether and how badly the contents will be corrupted.
I would recommend trying a dump/reload