Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Guido BarosioDate: 2004-06-29 11:27:13
Subject: Re: pg_dump Error
Previous:From: HarryDate: 2004-06-29 08:39:25
Subject: Re: cygwin installation problem (windows platform)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group