Postgres Pro
Downloads
Home   >   mailing lists

Re: Question: Multiple pg clusters on one server can be reached with the standard port. - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Question: Multiple pg clusters on one server can be reached with the standard port.
Date
Msg-id 29c383001ddcaf5713703385a34ed58d9be82363.camel@cybertec.at
Whole thread Raw
In response to Re: Question: Multiple pg clusters on one server can be reached with the standard port.  (Dominique Devienne <ddevienne@gmail.com>)
List pgsql-general
Tree view 
On Fri, 2023-06-16 at 15:25 +0200, Dominique Devienne wrote:
> On Fri, Jun 16, 2023 at 2:50 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> > There is an existing solution for that: the libpq connection service file:
> > https://www.postgresql.org/docs/current/libpq-pgservice.html
>
> The problem with the service and password files is that passwords are in plain text though.
> Yes there are restrictions on permissions of the password file (on Linux), still having some
> kind of encrypted token with an expiration date would be better IMHO. 

You don't store a password in the connection service file.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Question: Multiple pg clusters on one server can be reached with the standard port.
Next
From: Ron
Date:
Subject: Re: Question: Multiple pg clusters on one server can be reached with the standard port.