Re: Postgres 13 streaming replication standby not sending password, 'fe_sendauth: no password supplied'

On Wed, 2024-01-10 at 22:51 +0000, Keaney, Will wrote:
> However, the standby is unable to authenticate to the primary to begin recovery during startup.
> It logs an error, "FATAL: could not connect to the primary server: fe_sendauth: no password supplied".
>
> pg_hba.conf on the primary:
> host all,replication repl primary-database-server scram-sha-256
> host all,replication repl standby-database-server scram-sha-256
>
> myrecovery.conf on the standby:
> primary_conninfo = 'host=primary-database-server port=5432 user=repl application_name=standby-server-name'
> recovery_target_timeline = 'latest'
> primary_slot_name = 'standby_replication_slot'
>
> .pgpass on the standby:
> # hostname:port:database:username:password
> *:*:replication:repl:repl_user_password

make sure that .pgpass is in the home directory of the PostgreSQL user and has
restrictive permissions (0600). Try using it with a manual connection attempt
via "psql".

Yours,
Laurenz Albe