Re: Problem with database I need to repair...

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