From: Adam Radłowski <adamr@informatyka.gdansk.pl>
To: "Séguier, Géraldine" <Geraldine.Seguier@spotimage.fr>
Cc: pgsql-admin@postgresql.org
Subject: Re: Pg_dump postgreSQL 8.1.3-1 and win2k
Date: Mon, 15 Jan 2007 05:15:27 +0100
Message-ID: <45AAFFDF.2030206@informatyka.gdansk.pl> (raw)
In-Reply-To: <746EFBA80FE09B41926B64E015DEABE9010B839D@SISA-EXCHCLU.toulouse.spotimage.int>
References: <746EFBA80FE09B41926B64E015DEABE9010B839D@SISA-EXCHCLU.toulouse.spotimage.int>
I had this same problem on Win2003, but I resolved it in short way,
without analysis of problem - I make dumps as owner of database.
I suppose, there is a problem with full access to system tables with "no
owner" privilleges to dumped database.
I think it could be problem on all supported platforms, but when I saw
it on Win (one server), I make on other servers (Linux) dumps as owner
without testing, if I can to do it as normally privilleged user.
Brgds
Adam
Séguier, Géraldine napisał(a):
> 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,
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: adamr@informatyka.gdansk.pl, Geraldine.Seguier@spotimage.fr
Subject: Re: Pg_dump postgreSQL 8.1.3-1 and win2k
In-Reply-To: <45AAFFDF.2030206@informatyka.gdansk.pl>
References: <746EFBA80FE09B41926B64E015DEABE9010B839D@SISA-EXCHCLU.toulouse.spotimage.int> <45AAFFDF.2030206@informatyka.gdansk.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox