On Mon, May 20, 2024 at 9:10 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:Ron Johnson <ronljohnsonjr@xxxxxxxxx> writes:
> It seems that psql (or maybe libpq) doesn't like trailing comments.
Why would you think it would take that? The manual says that lines
beginning with '#' are comments, but not more than that.I searched the man page for "#" and "comment". The only mention is in this sentence:[quote]hostname:port:database:usernam:e password(You can add a reminder comment to the file by copying the line above and preceding it with#.)[/quote]That one sentence can easily be read as only referring to the "hostname:port..." line.
That would seem oddly specific and easily falsifiable. Which is probably why no one else has pointed out the odd wording. They actually try the generalization and it works.
But I agree the docs could use some improvement.
Since postgresql.conf and pg_hba.conf (I don't use pg_ident.conf) allow trailing comments, it seems reasonable that .pgpass should too, for consistency.
Reasonable but probably not worth the hassle to figure out the details. Though I’d be tempted to formalize the existing behavior and just add an optional field after password to hold a description. If we do ever extend off the end to specify yet more fields we’d make all the preceding optional fields mandatory.
Escapes. It escapes ":" and "\", so should be able to escape "#".
Frankly it probably shouldn’t escape anything in the password field, including colons. But since that ship has sailed, see the preceding idea.
David J.
