Thread: 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 -- http://yosemitecampsites.com/
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. -- http://yosemitenews.info/