pg_dump Error

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

Responses

Browse pgsql-admin by date

  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)