Skip site navigation (1) Skip section navigation (2)

Re: execute user-defined BKI

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Howard Bagcat <howard(at)mu(dot)edu(dot)ph>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: execute user-defined BKI
Date: 2004-07-21 10:13:30
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Am Mittwoch, 21. Juli 2004 11:28 schrieb Howard Bagcat:
> Now, my problem pg_dump and pg_dumpall displayed a lot of WARNING messages,
> like:
> "pg_dump: WARNING: owner of table "triggers" appears to be invalid."

Then you need to manually recreate all those users with the right user IDs.  
The user IDs are shown in the owner column of the respective system tables 
(e.g., pg_trigger).

Peter Eisentraut

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2004-07-21 14:53:49
Subject: Re: [HACKERS] Point in Time Recovery
Previous:From: Howard BagcatDate: 2004-07-21 09:28:15
Subject: Re: execute user-defined BKI

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group