This morning I had a problem with a linux server that was reseted
accidentally (someone pushed the wrong button). Anyway, we couldn't recover
the database because the log file was corrupted and we had to
pg_resetxlog...
We restored yesterday's backup and are now working again on one database,
but we have a problem with the second database...
The database General is obviously corrupted, and we found this out when we
where trying to access one of the tables. when we are connected to the
General database and try to access any table, we get
No relations found.
but when we try to create the tables again, we can't because we get
relation 'x' already exists.
The worst part is I can connect to the database, but the general catalog
obviously is not recognizing it.
chequesdegerencia=# \c General
You are now connected to database General
General=# ls
General-# \l
List of databases
Database | Owner | Encoding
-------------------+----------+-----------
chequesdegerencia | postgres | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
(3 rows)
Does anyone have any ideas on this?
Thank you.
PS. I'm already installing a new computer and moving all to the fresh
computer, but I wonder..