| From: | Micahael Long <mlong(at)datalong(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | pg_dump w/ 8.0b2 and win2k |
| Date: | 2004-10-03 06:13:09 |
| Message-ID: | 415F9875.3020507@datalong.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I am trying to dump a schema that was created on the windows version of
postgres. I am getting an error that I don't understand.. I can dump the
entire database with the superuser but dumping one schema doesn't seem
to work.
pg_dump -v -U proporg > temp1.sql
pg_dump: reading schemas
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
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 conversions
pg_dump: reading user-defined tables
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: permission denied for
relation pg_ts_dict
pg_dump: The command was: LOCK TABLE public.pg_ts_dict IN ACCESS SHARE MODE
pg_dump: *** aborted because of error
tia,
Mike
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Long | 2004-10-03 06:22:23 | Re: Users and multiple server environment |
| Previous Message | Tom Lane | 2004-10-03 05:45:42 | Re: Users and multiple server environment |