PGSERVICEFILE as part of a normal connection string

From: Torsten Förtsch <tfoertsch123(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: PGSERVICEFILE as part of a normal connection string
Date: 2024-11-18 20:21:56
Message-ID: CAKkG4_nCjx3a_F3gyXHSPWxD8Sd8URaM89wey7fG_9g7KBkOCQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I like to bundle all my database connections in a .pg_service.conf. Over
time I collected a bunch of such service files. A while back I discovered
that the service file can only be specified as an environment variable. It
cannot be given as part of the connection string like

psql "service=$MY_SERVICE servicefile=MY_SERVICE_FILE"

The attached patch allows that.

Regards.
--
Torsten

Attachment Content-Type Size
v1-0001-PGSERVICEFILE-as-part-of-the-connection-string.patch text/x-patch 6.8 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2024-11-18 20:22:28 Re: Reduce TupleHashEntryData struct size by half
Previous Message Wetmore, Matthew (CTR) 2024-11-18 20:06:24 Re: Statistics Import and Export