WARNING: owner of type appears to be invalid?

From: "Marc Sherman" <msherman(at)projectile(dot)ca>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: WARNING: owner of type appears to be invalid?
Date: 2001-05-23 14:01:35
Message-ID: CGEPKMKAIFJINAOACFFEGEPFCGAA.msherman@projectile.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I recently installed postgresql 7.1.1, and now when I run pg_dumpall
(which I do in a nightly script for backups), I get the following
messages, duplicated for each database in the system:

WARNING: owner of type 'pg_inherits' appears to be invalid
WARNING: owner of type 'pg_index' appears to be invalid
WARNING: owner of type 'pg_statistic' appears to be invalid
WARNING: owner of type 'pg_operator' appears to be invalid
WARNING: owner of type 'pg_opclass' appears to be invalid
WARNING: owner of type 'pg_am' appears to be invalid
WARNING: owner of type 'pg_amop' appears to be invalid
WARNING: owner of type 'pg_amproc' appears to be invalid
WARNING: owner of type 'pg_language' appears to be invalid
WARNING: owner of type 'pg_largeobject' appears to be invalid
WARNING: owner of type 'pg_aggregate' appears to be invalid
WARNING: owner of type 'pg_ipl' appears to be invalid
WARNING: owner of type 'pg_inheritproc' appears to be invalid
WARNING: owner of type 'pg_rewrite' appears to be invalid
WARNING: owner of type 'pg_listener' appears to be invalid
WARNING: owner of type 'pg_description' appears to be invalid

Does anyone know what's causing this, and how I can fix it?

- Marc

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-05-23 16:08:58 Re: WAL and backup recovery
Previous Message Dario Brignardello 2001-05-23 12:26:19 WAL and backup recovery