Restoring postgres from data directory.

From: Stef <svb(at)ucs(dot)co(dot)za>
To: pgsql-admin(at)postgresql(dot)org
Subject: Restoring postgres from data directory.
Date: 2007-04-10 08:49:49
Message-ID: 20070410104949.148fdadf@svb.ucs.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Elmers 2007-04-10 11:59:26 Re: Problems with precompiled pgsql on mac
Previous Message Randall Smith 2007-04-09 20:41:17 Re: HP support for Etch