Corrupted Database

From: "Martin Kuria" <martinkuria(at)hotmail(dot)com>
To: owe(dot)kristiansen(at)norgit(dot)no, pgsql-admin(at)postgresql(dot)org, webmaster(at)can-host(dot)com, cobalt-developers(at)list(dot)cobalt(dot)com, tgl(at)sss(dot)pgh(dot)pa(dot)us, bryan(at)arcamax(dot)com, olly(at)lfix(dot)co(dot)uk, kaygee(at)netset(dot)com, allan(at)itsolutions(dot)co(dot)za, Mtanoviceanu(at)Soundbreak(dot)com, keithmur(at)mindspring(dot)com, ljcq(at)beane(dot)sc(dot)uevora(dot)pt, lockhart(at)alumni(dot)caltech(dot)edu, php-dev(at)lists(dot)php(dot)net, mgeier(at)cdmsports(dot)com, gena(at)rt(dot)mipt(dot)ru
Subject: Corrupted Database
Date: 2002-07-13 11:51:26
Message-ID: LAW2-F141DP0thdA3Si0000fd68@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi, my linux machine crushed and my postgresql 6.5 database was corrupted.

I have /var/lib/pgsql/data intact, When I reinstalled Linux in a new
machine, Can I copy this directory back in the new postgresql database, and
will it work, because I have tried to do that but it did not work.

Note: I had not backed my data so no pg_dump done , how else can I recover
the data please do advice, I have /var/lib/pgsql/data directory which
contains the databases, but how do I make the databases work please do
assist thanks again

Kind Regards

Martin Wainaina Kuria
Programmer/Database Administrator
Bsc. Computer Science
Kenyaweb.com Ltd
www.kenyaweb.com

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Oliver Elphick 2002-07-13 13:44:45 Re: Corrupted Database
Previous Message Portatiles.net 2002-07-13 11:33:16 Novedad Mundial