From: cypisek <cypisek77@gmail.com>
To: pgsql-admin@postgresql.org
Subject: delete orphans from pg_class
Date: Tue, 16 Sep 2014 13:55:07 -0700 (PDT)
Message-ID: <1410900907358-5819256.post@n5.nabble.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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 does it show up in any other system tables. Of
course, it does not show up in the database through pg_admin. This object
is a sequence. It is preventing me from taking a pg_dump of that schema
because it is telling me that the object does not exist. Can I just
remove this object from the pg_class table.
2. Same story for a pg_toast_xxxxxxxx table. It has a very high age of
relfrozenxid and I worry that soon, this will become an issue. Vacuum full
on all databases on this cluster does not help since the toast table does
not really belong to any real table. Can I remove this row from pg_class
or would it cause an issue? Do I have any other options to remove this
object?
Thank you.
Andrzej
--
View this message in context: http://postgresql.1045698.n5.nabble.com/delete-orphans-from-pg-class-tp5819256.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: cypisek77@gmail.com
Subject: Re: delete orphans from pg_class
In-Reply-To: <1410900907358-5819256.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox