Hello, (everything following was tested on Ubuntu 14.04.5 LTS, using PostgreSQL 9.6.5) given '.pgpass' fille with content: dbmaster.service.consul:5432:replication:replication_user:supersecret Postgresql streaming replication slave server, containing "primary_conninfo = 'host=dbmaster.service.consul port=5432 user=replication_user'" inside recovery.conf is able to connect to primary without any errors using said .pgpass file. However when i run following command: psql -d "host=dbmaster.service.consul port=5432 user=replication_user replication=true" -c "IDENTIFY_SYSTEM;" I get password prompt, seems like psql is not considering replication database name in .pgpass as match. However if i replace previous .pgpass file with "dbmaster.service.consul:5432:*:replication_user:supersecret" it seams to please psql, so that ' systemid | timeline | xlogpos | dbname' and other info is returned without password prompt. Using star seems to also be OK for replication (both pg_basebackup and streaming replication initiated by standby server itself). I find this behaviour confusing, even for non documented parameter. Maybe psql should consider 'replication' as database name in .pgpass lookup when asked for replication connection? Alternatively, maybe documentation can be clarified, because even when it says "The database field is of limited usefulness because users have the same password for all databases in the same cluster." for some reason it suggest using special database name in one sentence before that: 'In a standby server, a database name of replication matches streaming replication connections made to the master server.' Maybe better suggestion would be to always use star instead of database name in .pgpass? Thanks. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
