Re: recover corrupt DB? - Mailing list pgsql-general

From Dan Armbrust
Subject Re: recover corrupt DB?
Date
Msg-id 82f04dc40905040651h1c4bbacct72147c3e0f764e73@mail.gmail.com
Whole thread Raw
In response to Re: recover corrupt DB?  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: recover corrupt DB?
List pgsql-general
> These reports seem to come up a bit, with disk full issues resulting in
> the need to pg_resetxlog, dump, and re-initdb, but I wouldn't be too
> shocked if they all turned out to be on xfs or something like that.
>

My particular disk-full condition was on ext2.  Nothing exotic.  Also,
the process that filled the disk was postgres - if that makes any
difference - I had left a debug level turned up in the postgres config
file, and it was logging every single db query.  Since it wasn't set
up to remove old log files - it filled the disk.

Nothing else unusual occurred that I'm aware of - things went weird
for the lab tester, he cleared some space, rebooted the system, and
postgres didn't come back online.

pgsql-general by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: diff-/patch-functionality for text-type data insidePostgreSQL
Next
From: Torsten Zühlsdorff
Date:
Subject: How to return SETOF RECORD?