Re: dblink authentication failed - Mailing list pgsql-general

From Francisco Olarte
Subject Re: dblink authentication failed
Date
Msg-id CA+bJJbxgfuCe5XBBR-guhiddkYJmCZu02au1=HcCTmFzKaFibQ@mail.gmail.com
Whole thread Raw
In response to dblink authentication failed  ("Kiss Attila" <kiss.attila@dardanis.hu>)
Responses Re: dblink authentication failed
List pgsql-general
Hello:

On Mon, Jun 27, 2016 at 9:38 AM, Kiss Attila <kiss.attila@dardanis.hu> 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 indicate you run those commands as root, while the
server typically runs as postgres. Have you checked the commands work
when issued as the server user?

Francisco Olarte.


pgsql-general by date:

Previous
From: Scott Mead
Date:
Subject: Re: dblink authentication failed
Next
From: Attila Kiss
Date:
Subject: Re: dblink authentication failed