From: Tom Lane <tgl@sss.pgh.pa.us>
To: Oscar Serrano <oserra@fondos.net>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: postgres crash. HELP
Date: Sun, 07 May 2000 12:17:33 -0400
Message-ID: <18362.957716253@sss.pgh.pa.us> (raw)
In-Reply-To: <NDBBKNFDELOHICEHIMGGIEFHCDAA.oserra@fondos.net>
References: <NDBBKNFDELOHICEHIMGGIEFHCDAA.oserra@fondos.net>
"Oscar Serrano" <oserra@fondos.net> writes:
> Suddenly in the directory where I have all the tables, now there is about
> 1000 files with names like this:
> [ and a bunch of apparently-duplicated entries in system catalogs ]
Looks pretty messy :-(. What version are you running?
I hope you have a fairly recent pg_dumpall backup, because otherwise
you are likely to be in trouble. If the backup is new enough that you
can just restore from it without losing much, then I'd recommend just
initdb and restore. If you have newer data than what is in the backup,
but the schema is still the same, you could probably use pg_upgrade to
recover the system tables from the backup and then move your current
user data into the database. (It looks like the trouble is just in the
system tables, so your user tables are most likely OK.)
If you want to try the pg_upgrade method, make sure you have the latest
pg_upgrade script (from 7.0RC5, current nightly snapshot, or direct from
CVS server) --- previous versions are known to have problems in
multi-user databases. Then, follow the man page's directions for
pg_upgrade, except don't bother trying to make a "pg_dumpall -s" dump
from your corrupted database; instead use your last good backup file
as the input script for pg_upgrade.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, oserra@fondos.net
Subject: Re: postgres crash. HELP
In-Reply-To: <18362.957716253@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox