Deep Trouble - Mailing list pgsql-general

From Abe Asghar
Subject Deep Trouble
Date
Msg-id 00a901c03832$e0a67720$2701a8c0@co.uk.atlas.co.uk
Whole thread Raw
In response to A better stop  ("Warren Flemmer" <warren@netlab.co.za>)
List pgsql-general
    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-general by date:

Previous
From: "Warren Flemmer"
Date:
Subject: A better stop
Next
From: Franck Martin
Date:
Subject: RE: storing binary data - PGSQL book/documentation