On Wed, Apr 27, 2011 at 7:50 AM, Dinakaran Kanagaraj <[email protected]> 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. _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
