Re: dblink authentication failed

From: Francisco Olarte <folarte(at)peoplecall(dot)com>
To: Kiss Attila <kiss(dot)attila(at)dardanis(dot)hu>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: dblink authentication failed
Date: 2016-06-27 09:19:08
Message-ID: CA+bJJbxgfuCe5XBBR-guhiddkYJmCZu02au1=HcCTmFzKaFibQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello:

On Mon, Jun 27, 2016 at 9:38 AM, Kiss Attila <kiss(dot)attila(at)dardanis(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Attila Kiss 2016-06-27 10:15:03 Re: dblink authentication failed
Previous Message Scott Mead 2016-06-27 09:18:59 Re: dblink authentication failed