From: | "Nigel Bishop" <Nigel(dot)Bishop(at)ioko(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | pg_dump Error |
Date: | 2004-06-29 09:38:03 |
Message-ID: | 72558D9A7573814BB4082A28843E03D40B414D@intyodc01.uk.ioko365.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Guido Barosio | 2004-06-29 11:27:13 | Re: pg_dump Error |
Previous Message | Harry | 2004-06-29 08:39:25 | Re: cygwin installation problem (windows platform) |