pg_dump warings
I did something foolish and now I'm getting warnings every time
pg_dump runs (hourly from cron). Anybody have a suggestion on how
to fix this?
pg_dump: WARNING: owner of data type "accountuser" appears to be invalid
pg_dump: WARNING: owner of data type "adminuser" appears to be invalid
pg_dump: WARNING: owner of data type "alias" appears to be invalid
pg_dump: WARNING: owner of data type "domain" appears to be invalid
pg_dump: WARNING: owner of data type "domainadmin" appears to be invalid
pg_dump: WARNING: owner of data type "search" appears to be invalid
pg_dump: WARNING: owner of data type "pg_toast_41251" appears to be invalid
pg_dump: WARNING: owner of data type "virtual" appears to be invalid
pg_dump: WARNING: owner of data type "log_id_seq" appears to be invalid
pg_dump: WARNING: owner of data type "log" appears to be invalid
pg_dump: WARNING: owner of data type "pg_toast_41268" appears to be invalid
pg_dump: WARNING: owner of table "accountuser" appears to be invalid
pg_dump: WARNING: owner of table "adminuser" appears to be invalid
pg_dump: WARNING: owner of table "alias" appears to be invalid
pg_dump: WARNING: owner of table "domain" appears to be invalid
pg_dump: WARNING: owner of table "domainadmin" appears to be invalid
pg_dump: WARNING: owner of table "search" appears to be invalid
pg_dump: WARNING: owner of table "virtual" appears to be invalid
pg_dump: WARNING: owner of table "log_id_seq" appears to be invalid
pg_dump: WARNING: owner of table "log" appears to be invalid
Hi,
On Sun, 2006-04-30 at 21:42 +0000, Rick Ellis wrote:
I did something foolish and now I'm getting warnings every time
pg_dump runs (hourly from cron). Anybody have a suggestion on how
to fix this?
Create the user again with the same userid (I mean revert what you did).
You can get this info from pg_tables and pg_authid(or pg_shadow,
depending on your PostgreSQL version).
Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
In article <1146438618.5923.10.camel@laptop.gunduz.org>,
Devrim GUNDUZ <devrim@commandprompt.com> wrote:
Create the user again with the same userid (I mean revert what you did).
You can get this info from pg_tables and pg_authid(or pg_shadow,
depending on your PostgreSQL version).
It turned out to be some tables had been created that shouldn't
have been and the user that created them had been deleted. So
the cure was deleting the tables.
Thank you very much. You provided just the clues I needed.