Re: Comments in .pgpass file...

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Comments in .pgpass file...
Дата
Msg-id CANzqJaAZoD1UJa0qva5hpqSdwrYFvSTqOZthAH-2Aetvh0u3jQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Comments in .pgpass file...  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Comments in .pgpass file...
Список pgsql-admin
On Mon, May 20, 2024 at 9:10 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Ron Johnson <ronljohnsonjr@gmail.com> 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:username: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.

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.

It also seems reasonable that hostnames in .pgpass should be case-insensitive, since they're case-insensitive everywhere else in the network world.

> But this does not:
> 10.143.170.206:5432:*:11026270:Blarge # Host name: fubar

If that acted as a comment, it'd be impossible to use passwords
containing '#'.

Escapes.  It escapes ":" and "\", so should be able to escape "#". 


В списке pgsql-admin по дате отправления:

Предыдущее
От: Erik Wienhold
Дата:
Сообщение: Re: Comments in .pgpass file...
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Comments in .pgpass file...