Re: pg_dump on remote machine - Mailing list pgsql-admin

Hello,

> Yes I can get connected by psql -h 172.16.30.2 (dbname) and I can also connect
to the remote DB using phpPgAdmin. I have given the permissions on
pg_hba.conf file.

Hmmm,
when you connected with psql -h 172.16.30.2 (dbname),
are you able to get data with the select-command?
If not, you must grant access with the grant-command.

And you should look to the logfile of postgresql.

Bye Thomas