Thread: Re: Corrupted Database

Re: Corrupted Database

From
Oliver Elphick
Date:
On Sat, 2002-07-13 at 12:51, Martin Kuria wrote:
> 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

You must install a copy of PostgreSQL 6.5 to match your database.  Later
versions of PostgreSQL will not work with it.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Let your character be free from the love of money,
      being content with what you have; for He Himself has
      said, "I will never desert you, nor will I ever
      forsake you."
                              Hebrews 13:5