Re: BUG #15827: Unable to connect on Windows using pg_services.conf using Python psycopg2 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15827: Unable to connect on Windows using pg_services.conf using Python psycopg2
Date
Msg-id 82491.1559409563@sss.pgh.pa.us
Whole thread Raw
In response to BUG #15827: Unable to connect on Windows using pg_services.conf using Python psycopg2  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15827: Unable to connect on Windows using pg_services.confusing Python psycopg2
Re: BUG #15827: Unable to connect on Windows using pg_services.conf using Python psycopg2
List pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> I'm using `pg_services.conf` to provide access to a Postgresql database.
> ...
> From other's feedback, I've tried to use the line separators in
> pg_services.conf with \n and \r\n, but the result is the same (because there
> is strange newline after the host address).

Hm, can you double check that?  It sure looks like something is failing to
remove the "\r" from that line of pg_service.conf.  Which is odd, because
libpq opens the file in text mode so the Windows C library ought to take
care of reducing "\r\n" to "\n".

It seems like in general, maybe we ought to trim trailing spaces from
pg_service.conf entries automatically.  But I'm not entirely sure if
that would fix this problem...

            regards, tom lane



pgsql-bugs by date:

Previous
From: Robert Vollmert
Date:
Subject: Re: inconsistent behaviour of json_to_record and friends withembedded json
Next
From: Jorge Gustavo Rocha
Date:
Subject: Re: BUG #15827: Unable to connect on Windows using pg_services.confusing Python psycopg2