Problem with database I need to repair...

From: "Ligia Pimentel" <pimentel_ligia(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Problem with database I need to repair...
Date: 2002-07-19 18:21:15
Message-ID: ah9p3j$ekf$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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..

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Robson Martins 2002-07-19 20:53:17 pg_dump
Previous Message Tony Reina 2002-07-19 18:01:15 Re: Large Dump Files