Postgres Pro
Downloads
Home   >   mailing lists

Pg_dump postgreSQL 8.1.3-1 and win2k - Mailing list pgsql-admin

From Séguier, Géraldine
Subject Pg_dump postgreSQL 8.1.3-1 and win2k
Date
Msg-id 746EFBA80FE09B41926B64E015DEABE9010B839D@SISA-EXCHCLU.toulouse.spotimage.int
Whole thread Raw
Responses Re: Pg_dump postgreSQL 8.1.3-1 and win2k  (Adam Radłowski <adamr@informatyka.gdansk.pl>)
List pgsql-admin
Tree view
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,
 

pgsql-admin by date:

Previous
From: "Sriram Dandapani"
Date:
Subject: vacuum very slow
Next
From: Alexander Burbello
Date:
Subject: Lob datatype