Re: [GENERAL] orphan records in pg_class

2014-09-16 Thread Michael Paquier
On Tue, Sep 16, 2014 at 1:46 PM, Andrzej Pilacik wrote: > I inherited a 8.4.9 500gb database. After doing some analysis on it I found > two issues that I am not sure how to handle. You should target a dump for an upgrade to a newer version, 8.4 has been EOL'd recently. And this version is missing

[GENERAL] orphan records in pg_class

2014-09-16 Thread Andrzej Pilacik
I inherited a 8.4.9 500gb database. After doing some analysis on it I found two issues that I am not sure how to handle. 1. There is an object in pg_class that I can only query by oid or by using ilike instead of = . That objects also only exists in pg_class, it does not exist in pg_depend nor d