Deep Trouble

From: "Abe Asghar" <abe(at)fish(dot)tm>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Deep Trouble
Date: 2000-10-17 11:54:21
Message-ID: 009901c03830$fd771780$2701a8c0@co.uk.atlas.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-10-17 12:05:17 Re: pgsql is 75 times faster with my new index scan
Previous Message chris markiewicz 2000-10-17 11:37:33 do triggers/procedures run instantly?