pg_dump Error
От | Nigel Bishop |
---|---|
Тема | pg_dump Error |
Дата | |
Msg-id | 72558D9A7573814BB4082A28843E03D40B414D@intyodc01.uk.ioko365.com обсуждение исходный текст |
Ответы |
Re: pg_dump Error
|
Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: