Pg_dump postgreSQL 8.1.3-1 and win2k

From: "Séguier, Géraldine" <Geraldine(dot)Seguier(at)spotimage(dot)fr>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Pg_dump postgreSQL 8.1.3-1 and win2k
Date: 2007-01-10 17:34:29
Message-ID: 746EFBA80FE09B41926B64E015DEABE9010B839D@SISA-EXCHCLU.toulouse.spotimage.int
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm trying to dump a schema and I receive this error :
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

The schema was created by a superuser "X", and the dump has been done by another user "Y" which has the privileges : ALL on this table.
grant ALL on table pg_ts_dict to Y;
The owner of pg_ts_dict is "X".

Thanks for your answer,

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alexander Burbello 2007-01-10 18:03:18 Lob datatype
Previous Message Sriram Dandapani 2007-01-10 16:50:38 vacuum very slow