From: | "Kiss Attila" <kiss(dot)attila(at)dardanis(dot)hu> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | dblink authentication failed |
Date: | 2016-06-27 07:38:34 |
Message-ID: | 000a01d1d046$e972d480$bc587d80$@dardanis.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I have some problem with using dblink_connect_u() in my function.
When I provide the password in the connection string, there is no problem,
but when I don't, it says:
ERROR: could not establish connection
DETAIL: fe_sendauth: no password supplied
However the .pgpass file in the path /var/lib/postgres/.pgpass does contain
the proper password.
I have tried to connect to the remote server with psql from bash with the
following command:
# psql -h 192.168.1.40 -U myuser -w remote_db_name
it works fine.
My .pgpass file does have the line:
192.168.1.40:5432:*:myuser:mypassword
It seems the psql finds the proper password in the .pgpass file but dblink
doesn't.
The local and the remote server are running on Ubuntu server 14.04, both of
them are PostgreSQL 9.4.
The .pgpass file properties look this:
# ls -la ./.pgpass
-rw------- 1 postgres postgres 193 jún 24 13:54 ./.pgpass
Any ideas are welcome.
Regards,
Attila
---
Ezt az e-mailt az Avast víruskereső szoftver átvizsgálta.
https://www.avast.com/antivirus
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Mead | 2016-06-27 09:18:59 | Re: dblink authentication failed |
Previous Message | Patrick B | 2016-06-27 03:34:40 | Re: wal_files from slave to another slave |