postgresql通过设置password file，实现命令行免输口令登陆

最新推荐文章于 2024-05-30 18:05:59 发布

京密815314

最新推荐文章于 2024-05-30 18:05:59 发布

阅读量578

点赞数

分类专栏：命令行操作文章标签： postgresql

原文链接：https://www.postgresql.org/docs/8.3/libpq-pgpass.html

版权

命令行操作专栏收录该内容

3 篇文章

订阅专栏

注意，需要设置好此文件的访问权限，避免安全隐患。

30.13. The Password File

The file .pgpass in a user's home directory or the file referenced by PGPASSFILE 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).

This file should contain lines of the following format:

    hostname:port:database:username:password

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 \. A host name of localhost matches both TCP (host name localhost) and Unix domain socket (pghost empty or the default socket directory) connections coming from the local machine.

On Unix systems, the permissions on .pgpass must disallow any access to world or group; achieve this by the command 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.