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/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend