Data in tables got deleted

[ngoyal]

Hi,

I need help with Postgres. We have been running Postgres successfully on our production server for 4 months now but last week we noticed something strange:-

1. The data in the tables got deleted. The result of select count(*) on all tables was zero(0). We could not find anything in the logs and there were no signs of any kind of hacking.

2. We could not see any tables using "\d" on psql command. But we were able to run all queries on all the tables.

Any help regarding this problem would be of great help.

Thanks.

 

[gwinn7]

This probably seems like a silly question, but are you running multiple databases, or multiple identically structured databases? One thought came to mind is that you may be unknowningly signed into an empty copy. Is this at all possible? What happens when you try psql to view the available databases in the catalog?

Have you signed on as the Postgres superuser to view database objects?

Gary
gwinn7

 

[ngoyal]

Gary,

We are running only one database with one schema. We checked several times to make sure we were connected to the correct database. When I do psql -l I was able to see the database.

I was signed in as Postgres superuser.

Thanks.