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)
...