Hi I'm getting an error with pg_dump:
I'm using pg_dump -v -C -U username database > ./dumpfile.dmp and it errors with: pg_dump: saving database definition pg_dump: reading namespaces pg_dump: reading user-defined types pg_dump: reading user-defined functions pg_dump: reading user-defined aggregate functions pg_dump: reading user-defined operators pg_dump: reading user-defined operator classes pg_dump: reading user-defined tables pg_dump: Attempt to lock table "Foo" failed. ERROR: MySchema: permission denied pg_dump: *** aborted because of error Issueing a SELECT * FROM PG_TABLES; Shows: MySchema | Foo | postgres | t | f | f If I try to drop this it errors saying the table foo doesn't exist. Where did this object come from and how can I resolve the pg_dump error TIA Nigel ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
