[ADMIN] Data corruption / recover

2013-02-28 Thread Daniel Paval
Hi, We're dealing with the following situation (PG version is 7.4.30): somehow, a DB has gone missing from pg_database (psql \l listing doesn't show it anymore). More, while you can still \c to it, a \d table listing only shows a fraction of the tables. A \d on the existing tables shows

Re: [ADMIN] Data corruption / recover

2013-02-28 Thread Scott Marlowe
On Thu, Feb 28, 2013 at 7:21 AM, Tom Lane t...@sss.pgh.pa.us wrote: Daniel Paval d...@scorpionsoftware.ro writes: We're dealing with the following situation (PG version is 7.4.30): 7.4? I sure hope you're going to migrate onto something less obsolete once you get out of this problem. In any

Re: [ADMIN] Data corruption / recover

2013-02-28 Thread Daniel Paval
On 28.02.2013 18:48, Scott Marlowe wrote: On Thu, Feb 28, 2013 at 7:21 AM, Tom Lane t...@sss.pgh.pa.us wrote: Daniel Paval d...@scorpionsoftware.ro writes: We're dealing with the following situation (PG version is 7.4.30): 7.4? I sure hope you're going to migrate onto something less obsolete