Problem with database I need to repair...
От | Ligia Pimentel |
---|---|
Тема | Problem with database I need to repair... |
Дата | |
Msg-id | ah9p3j$ekf$1@news.hub.org обсуждение исходный текст |
Ответы |
Re: Problem with database I need to repair...
|
Список | 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..
В списке pgsql-admin по дате отправления: