Robert Fitzpatrick <lists@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
