Deep Trouble - Mailing list pgsql-hackers

From Abe Asghar
Subject Deep Trouble
Date
Msg-id 009901c03830$fd771780$2701a8c0@co.uk.atlas.co.uk
Whole thread Raw
In response to pgsql is 75 times faster with my new index scan  (devik@cdi.cz)
List pgsql-hackers
    Hi guys,

Havin some trouble.

One of my databases appeared to be empty suddenly after having a large
amount of data in it.  I contacted our server company and they gave me the
postgres dir.

I have put back the folder of the newsdatabase from the base dir into the
base dir of Postgres and recreated the database.

That's fine.

However now the database is empty.  When I do a cat on the file of the same
name as one of the tables - it has loads of data in it.  However when I go
in to Postgres and try to list the table it comes back with ) rows.

Any ideas I am desperate.

I am using linux redhat and Postgres

Thanks
Abe



pgsql-hackers by date:

Previous
From: Gilles DAROLD
Date:
Subject: Re: [GENERAL] PL/Perl compilation error
Next
From: Bruce Momjian
Date:
Subject: Re: pgsql is 75 times faster with my new index scan