.pg_service.conf default location and default name on MS Windows platform

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: marek(dot)lall(at)eesti(dot)ee
Subject: .pg_service.conf default location and default name on MS Windows platform
Date: 2022-01-06 17:38:41
Message-ID: 164149072159.23278.2045144902336602070@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/libpq-pgservice.html
Description:

Can you please add note about file ".pg_service.conf" default location and
default name on MS Windows platform?
Why?
Accoring to my experience the default location and file name is:
"%APPDATA%\postgresql\.pg_service.conf".
This is not equal to: "~/.pg_service.conf"

Also, (re)naming pattern does not match to ".pgpass" and it is confusing.
".pgpass" is documented for MS Windows.
".pg_service.conf" is not documented and therefore many people assume that
similar renaming has to be done.
Linux: .pg_service.conf and .pgpass
Win : .pg_service.conf and pgpass.conf

Reference: There is clear note about "pgpass.conf" file for MS Windows
platform:
https://www.postgresql.org/docs/current/libpq-pgpass.html
...
On Microsoft Windows the file is named %APPDATA%\postgresql\pgpass.conf
(where %APPDATA% refers to the Application Data subdirectory in the user's
profile)
...

Browse pgsql-docs by date

  From Date Subject
Next Message Euler Taveira 2022-01-07 00:29:16 Re: pg_isready docs doesn't specify what exactly it is checking
Previous Message Mathias Kunter 2022-01-05 18:27:55 Re: random_page_cost configuration parameter