What release of PostgreSQL are you using? It shouldn't have gotten
corrupted.
---------------------------------------------------------------------------
Ligia Pimentel wrote:
> 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..
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026