Zengfa Gao <zfgao(at)yahoo(dot)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