M4N - Dennis Brouwer writes:
> We are trying to recover this database on a different server and
> re-indexed all (but one) tables, only one -unimportant- table refuses to
> be re-indexed or even dropped. We desperately want to drop this single
> table (it's recreated constantly) but we can not
While implementing a warm standby server lightning struck, the WAL files
supposed to be shipped to the warm standby server caused the filing
system to be out of disk space. In order to quickly reclaim disk space
we removed some of the WAL files written to pg_xlogs (very stupid we
know). A corru
"Mike C" <[EMAIL PROTECTED]> writes:
> On 10/8/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>> If you're lucky, REINDEX might solve your problems.
> My problem is that I can't even start postmaster to perform the
> reindex on now. As soon as I try start (via pg_ctl, 8.1.10):
> ...
> postgres_report[24
On 10/8/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Mike C" <[EMAIL PROTECTED]> writes:
> > I have a corrupt database. I copied the database directory offsite and
> > restored from a backup. I'm now trying to recover data in the corrupt
> > database added since the last backup. Any advice on how to
"Mike C" <[EMAIL PROTECTED]> writes:
> I have a corrupt database. I copied the database directory offsite and
> restored from a backup. I'm now trying to recover data in the corrupt
> database added since the last backup. Any advice on how to approach
> this?
If you're lucky, REINDEX might solve y
Hi,
I have a corrupt database. I copied the database directory offsite and
restored from a backup. I'm now trying to recover data in the corrupt
database added since the last backup. Any advice on how to approach
this?
It looks like my SAN raid controllers failed (both of them) after
putting in n
Hi there.
I have the following problem... 3 days ago I had a Hard Disck crash. I
recovered my data folder, but when I coppied it to the new instalation
of postgresql I see only my databases without any of the tables.
Any idea?
---(end of broadcast)-
Title: Database Recovery
I need help restoring a postgres database. My postgres server was destroyed by a tornado, but the raid drives containing the data are still intact. I built a new machine and mounted the raid drives, but I can't get the new installation of postgres to load the old da
