Re: dblink_connect fails

On 12/16/2015 04:53 PM, James Sewell wrote:
> No it is not.
>
> Just in case I tried setting it to 'postgres', logged in without -U
> (doesn't work without PGUSER set) and tried the operation again.

Do you mean this:

DETAIL:  FATAL:  role "PRDSWIDEGRID01$" does not exist

or that you could not connect for another reason?

If for the original reason, does the role PRDSWIDEGRID01$ actually exist
somewhere?


>
> Same result.
>
> Cheers,
>
>
> James Sewell,
> PostgreSQL Team Lead / Solutions Architect
> ______________________________________
>
> Level 2, 50 Queen St, Melbourne VIC 3000
>
> *P *(+61) 3 8370 8000***W* www.lisasoft.com *F *(+61) 3 8370 8099
>
> On Wed, Dec 16, 2015 at 3:26 PM, Joe Conway <mail@joeconway.com
> <mailto:mail@joeconway.com>> wrote:
>
>     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
>
>
>
> ------------------------------------------------------------------------
> The contents of this email are confidential and may be subject to legal
> or professional privilege and copyright. No representation is made that
> this email is free of viruses or other defects. If you have received
> this communication in error, you may not copy or distribute any part of
> it or otherwise disclose its contents to anyone. Please advise the
> sender of your incorrect receipt of this correspondence.
>


--
Adrian Klaver
adrian.klaver@aklaver.com