Re: Document spaces in .pgpass need to be escaped

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: James Coleman <jtc331(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Document spaces in .pgpass need to be escaped
Date: 2021-09-29 16:13:31
Message-ID: 2977366.1632932011@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

James Coleman <jtc331(at)gmail(dot)com> writes:
> A coworker has a space in a Postgres password and noticed .pgpass
> didn't work; escaping it fixed the issue. That requirement wasn't
> documented (despite other escaping requirements being documented), so
> I've attached a patch to add that comment.

I looked at passwordFromFile() and I don't see any indication that
it treats spaces specially. Nor does a quick test here confirm
this report. So I'm pretty certain that this proposed doc change
is wrong. Perhaps there's some other issue to investigate, though?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Yen 2021-09-29 16:15:14 Re: Patch to allow pg_filedump to support reading of pg_filenode.map
Previous Message Christoph Berg 2021-09-29 16:01:48 Re: Patch to allow pg_filedump to support reading of pg_filenode.map