Robert Fitzpatrick <[EMAIL PROTECTED]> writes:
> I try to use dblink_connect while logged into the database as the
> superuser and it returns OK, but if I disconnect and use the same
> command as follows, it give and error, password is required. Even if I
> try to use the superuser login in the connect string below while
> connected as a non-superuser, I get the error...
This probably means that the remote database is not in fact prompting
for a password on this connection. For security reasons dblink wants
non-superuser callers to supply a password that actually gets used
--- otherwise they are effectively able to masquerade as the local
superuser to the remote database.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
