@postgresql.org
Tárgy: Re: [GENERAL] dblink authentication failed
On 06/27/2016 03:58 AM, Attila Kiss wrote:
> I've got some additional info about the problem.
>
> After several times trying to connect to the remote database, I tried to
> connect to the local database with dblink. I edit
*Feladó:* Kiss Attila
*Elküldött:* Hétfő 2016.06.27 09:42
*Tárgy:*[GENERAL] dblink authentication failed
*Címzett:* pgsql-general@postgresql.org;
Hello,
I have some problem with using dblink_connect_u() in my function.
When I provide the password in the conn
t with the exactly same
connection string in dblink(hostaddr=127.0.0.1). I don't know what is going on
in the background, maybe some IP address<->hostname problem?
-eredeti Üzenet-
Feladó:Kiss Attila
Elküldött:Hétfő 2016.06.27 09:42
Tárgy:[GENERAL] dblink authenticati
I just wrote '#' to show it is command line, but actually I ran the psql as
user postgres, just like the SQL server process is running. So if it was
deceptive, I am sorry.
-eredeti Üzenet-
Feladó:Francisco Olarte
Elküldött:Hétfő 2016.06.27 11:23
Tárgy:Re: [GENER
Hello:
On Mon, Jun 27, 2016 at 9:38 AM, Kiss Attila wrote:
I'm not expert on dblink but, even supposing it uses libpq and its files:
> # psql –h 192.168.1.40 –U myuser –w remote_db_name
...
> # ls –la ./.pgpass
> -rw--- 1 postgres postgres 193 jún 24 13:54 ./.pgpass
This '#' seems to indi
> On Jun 27, 2016, at 03:38, Kiss Attila wrote:
>
> 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_senda
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 /v
