From 46651ce6fe013220ed397add242004d764fc0153 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:15:05 +0200 Subject: Adding upstream version 14.5. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/libpq-pgpass.html | 45 +++++++++++++++++++++++++++++++++++++ 1 file changed, 45 insertions(+) create mode 100644 doc/src/sgml/html/libpq-pgpass.html (limited to 'doc/src/sgml/html/libpq-pgpass.html') diff --git a/doc/src/sgml/html/libpq-pgpass.html b/doc/src/sgml/html/libpq-pgpass.html new file mode 100644 index 0000000..3c2576f --- /dev/null +++ b/doc/src/sgml/html/libpq-pgpass.html @@ -0,0 +1,45 @@ + +34.16. The Password File
34.16. The Password File
Prev UpChapter 34. libpq — C LibraryHome Next

34.16. The Password File

+ The file .pgpass in a user's home directory can + contain passwords to + be used if the connection requires a password (and no password has been + specified otherwise). On Microsoft Windows the file is named + %APPDATA%\postgresql\pgpass.conf (where + %APPDATA% refers to the Application Data subdirectory in + the user's profile). + Alternatively, the password file to use can be specified + using the connection parameter passfile + or the environment variable PGPASSFILE. +

+ This file should contain lines of the following format: +

+hostname:port:database:username:password
+

+ (You can add a reminder comment to the file by copying the line above and + preceding it with #.) + Each of the first four fields can be a literal value, or + *, which matches anything. The password field from + the first line that matches the current connection parameters will be + used. (Therefore, put more-specific entries first when you are using + wildcards.) If an entry needs to contain : or + \, escape this character with \. + The host name field is matched to the host connection + parameter if that is specified, otherwise to + the hostaddr parameter if that is specified; if neither + are given then the host name localhost is searched for. + The host name localhost is also searched for when + the connection is a Unix-domain socket connection and + the host parameter + matches libpq's default socket directory path. + In a standby server, a database field of replication + matches streaming replication connections made to the primary server. + The database field is of limited usefulness otherwise, because users have + the same password for all databases in the same cluster. +

+ On Unix systems, the permissions on a password file must + disallow any access to world or group; achieve this by a command such as + chmod 0600 ~/.pgpass. If the permissions are less + strict than this, the file will be ignored. On Microsoft Windows, it + is assumed that the file is stored in a directory that is secure, so + no special permissions check is made. +

Prev Up Next
34.15. Environment Variables Home 34.17. The Connection Service File
\ No newline at end of file -- cgit v1.2.3