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

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

pgsql-admin by date

Next:From: Alexander BurbelloDate: 2007-01-10 18:03:18
Subject: Lob datatype
Previous:From: Sriram DandapaniDate: 2007-01-10 16:50:38
Subject: vacuum very slow

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