From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: marek.lall@eesti.ee
Subject: .pg_service.conf default location and default name on MS Windows platform
Date: Thu, 06 Jan 2022 17:38:41 +0000
Message-ID: <164149072159.23278.2045144902336602070@wrigleys.postgresql.org> (raw)
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)
...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, marek.lall@eesti.ee
Subject: Re: .pg_service.conf default location and default name on MS Windows platform
In-Reply-To: <164149072159.23278.2045144902336602070@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox