Re: pg_dump: Attempt to lock table "contexthelp" failed. - Mailing list pgsql-general

Zengfa Gao <zfgao@yahoo.com> writes:
> On one system, PgSQL 7.2.1 is running on Redhat 7.3
> system. On another system, I run following script:

> !/bin/sh
> export PGPASSWORD=ZVCfH6sFtHW
> pg_dump -h pgql_hostname -U myuser mydatabase >
> mydumpfile

> I got following errors:

> pg_dump: Attempt to lock table "contexthelp" failed.
> ERROR:  LOCK TABLE: permission denied
                      ^^^^^^^^^^^^^^^^^

> This script works fine if I change pgsql_hostname to
> localhost.

Evidently "myuser" is a superuser locally, but not on the remote system.
Or the tables have different ownership on the two systems.

            regards, tom lane