pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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,
> 
>  



view thread (2+ messages)

Message-ID: <45AAFFDF.2030206@informatyka.gdansk.pl>
Permalink:  ../45AAFFDF.2030206@informatyka.gdansk.pl/
Also on:    postgresql.org/message-id/45AAFFDF.2030206@informatyka.gdansk.pl

 · 

reply

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