Re: [pgadmin-support] Lost database - Mailing list pgsql-general

From Albe Laurenz
Subject Re: [pgadmin-support] Lost database
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17C7DE0D@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Re: [pgadmin-support] Lost database  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
John R Pierce wrote:
> if the postgresql server was running when that file backup was made(*),
> its pretty much worthless, it will have data corruption and errors
> throughout.

Well, it would be better than nothing.
You can pg_resetxlog and manually clean up the inconsistencies.
That's better than nothing at all.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Spiros Ioannou
Date:
Subject: Re: While only running pg_dump, postgresql performs writes inside base/ directory. How can we stop this?
Next
From: Wojciech Skaba
Date:
Subject: Bitmap Heap Scan slowdown