From: Stef <svb@ucs.co.za>
To: pgsql-admin@postgresql.org
Subject: Restoring postgres from data directory.
Date: Tue, 10 Apr 2007 10:49:49 +0200
Message-ID: <20070410104949.148fdadf@svb.ucs.co.za> (raw)
Hi all,
I've got a postgres 7.3.4 database. and somehow the pg_control file got corrupted
when the machine ran out of space, and someone ran pg_resetxlog -f.
So basically the database starts up, but I can only see template1 and template0.
Is there a way to link in the data that is in the "base" directory so that postgres sees
that database again?
Kind Regards
Stefan
--
Confidentiality Notice: http://ucs.co.za/conf.html
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-admin@postgresql.org
Cc: svb@ucs.co.za
Subject: Re: Restoring postgres from data directory.
In-Reply-To: <20070410104949.148fdadf@svb.ucs.co.za>
* 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