| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | James Sewell <james(dot)sewell(at)lisasoft(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: dblink_connect fails |
| Date: | 2015-12-16 04:26:41 |
| Message-ID: | 5670E801.9020208@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 12/15/2015 06:24 PM, James Sewell wrote:
> I have a Windows PostgreSQL server where dblink_connect fails to pick up
> the current user as follows:
> ffm=# SELECT dblink_connect('master', 'dbname=ffm');
> ERROR: could not establish connection
> DETAIL: FATAL: role "PRDSWIDEGRID01$" does not exist
> Has anyone seen this before? It seems very odd to me, I have another
> identical machine (except for being on 9.4.0) which this works on.
Do you happen to have a PGUSER variable defined in your environment
(that is, in the environment as seen by the OS user the postmaster runs
under)?
See: http://www.postgresql.org/docs/9.4/static/libpq-envars.html
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kaare Rasmussen | 2015-12-16 04:34:25 | Re: json indexing and data types |
| Previous Message | James Sewell | 2015-12-16 02:24:17 | dblink_connect fails |