Re: Question: Multiple pg clusters on one server can be reached with the standard port.

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Dominique Devienne <ddevienne(at)gmail(dot)com>
Cc: Brainmue <brainmue(at)weiller(dot)eu>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Question: Multiple pg clusters on one server can be reached with the standard port.
Date: 2023-06-16 15:20:42
Message-ID: 29c383001ddcaf5713703385a34ed58d9be82363.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 2023-06-16 at 15:25 +0200, Dominique Devienne wrote:
> On Fri, Jun 16, 2023 at 2:50 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-06-16 15:34:24 Re: Question: Multiple pg clusters on one server can be reached with the standard port.
Previous Message Laurenz Albe 2023-06-16 15:19:51 Re: Question: Multiple pg clusters on one server can be reached with the standard port.