Re: BUG #16550: Problem with pg_service.conf

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Michał Lis <fcs1(at)poczta(dot)onet(dot)pl>
Cc: pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #16550: Problem with pg_service.conf
Date: 2020-07-22 22:53:47
Message-ID: CAMkU=1yYertjvCMoWn=NmWS668LvC5V4SJza+hjAEtgwLHPYBg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Jul 22, 2020 at 1:02 PM Michał Lis <fcs1(at)poczta(dot)onet(dot)pl> wrote:

> Hello,
>
> No, the file is only on the server side.
>
> I expected the client will ask the server using the service name.
>

How would it know what server to ask? The hostname and port of the server
are contained in the file, which it doesn't have.

> If the service will be found on the server, the server should accept the
> connection from the client.
>
> In pg_service.conf file can be stored user name and password.
>
> I want to use login of service type, because I won't to store any login
> information (ie password) on the client side.
>

There isn't much point in using a password, if the server doesn't require
the client to prove knowledge of it. You might as well just use 'ident'.

Cheers,

Jeff

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2020-07-22 23:16:39 Re: BUG #16476: pgp_sym_encrypt_bytea with compress-level=6 : Wrong key or corrupt data
Previous Message Tom Lane 2020-07-22 22:38:50 Re: BUG #16476: pgp_sym_encrypt_bytea with compress-level=6 : Wrong key or corrupt data