On Wed, Apr 27, 2011 at 7:50 AM, Dinakaran Kanagaraj
<Dinakaran.K at fs.mphasis.com> wrote:
> Hi,
>
>
>
> I have postgresql 8.4.3. I tried executing pg_dump using the command :
> ./pg_dump -U admin -p 15432 SIEM -f /home/karan/dumpfile
>
>
>
> After giving the password it throws the below error. Please let know how to
> fix this.
>
>
>
> pg_dump: SQL command failed
>
> pg_dump: Error message from server: ERROR:  permission denied for relation
> databasechangeloglock
>
> pg_dump: The command was: LOCK TABLE public.databasechangeloglock IN ACCESS
> SHARE MODE

This doesn't sound much like a Slony issue.

That's not a table used by Slony, so this shouldn't be affected by any
of Slony's behaviour.

I imagine that perhaps the "admin" user isn't allowed access to your
relation, databasechangeloglock.  That seems like a permissions
problem for the user you might be trying to use to do backups.

You might want to redirect this to pgsql-general or pgsql-admin,
though they would probably need a bit more detail to infer anything
useful about a problem like this.