[Fwd: [ADMIN] zero_damaged_pages having no effect]

2004-10-12 Thread Dan Hrabarchuk
; !> > > Is there some extra trick here? I just want to delete the bad tuples. I can > restore the data from another source. > > I really don't care if I need to take the database server down at 2am and use a > hex editor to clean this. I need my boss off my back. Please he

Re: [Fwd: [ADMIN] zero_damaged_pages having no effect]

2004-10-12 Thread Dan Hrabarchuk
Thank you Tom. So in my case, where should I start? I want to be able to dump this database to a new machine. Given my corruption, how should I go about this? My current plan is to use Slony, but I'm worried that the corruption will interfere with the transfer. How can I get the db server to simp

[ADMIN] Enabling --log-update

2004-10-04 Thread Dan Hrabarchuk
/audittrail/projdisplay.php I need to have the database available while the dump is done. Thanks is advance Dan Hrabarchuk ---(end of broadcast)--- TIP 8: explain analyze is your friend

[ADMIN] Duplicating a large database.

2004-10-05 Thread Dan Hrabarchuk
ished projects that I can complete (or at least get working enough :)? Thanks for the help Dan Hrabarchuk ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[ADMIN] [Fwd: Re: Question about pgfsck]

2004-10-07 Thread Dan Hrabarchuk
SQL admin do? A database disaster guide. Thanks Dan Hrabarchuk -Forwarded Message- > From: Martijn van Oosterhout <[EMAIL PROTECTED]> > To: Dan Hrabarchuk <[EMAIL PROTECTED]> > Subject: Re: Question about pgfsck > Date: Thu, 07 Oct 2004 10:38:33 +0200 > > The

Re: [ADMIN] hardware question

2002-09-26 Thread Dan Hrabarchuk
A note on your last point. We have a bunch of older SUN boxes around here. e450, e250, etc. The 2MB L2 cache un the UltraSparc 2 does allow for a high load. And for their era they were sweet chips, still are. But the #1 reason in my mind to move from Sun to an Lintel box would be cost. Sun is ex