Specifies a connection string to be used for the standby server to connect with a sending server. This string is in the format described in libpq-connstring. If any option is unspecified in this string, then the corresponding environment variable (see libpq-envars) is checked. If the environment variable is not set either, then defaults are used.
The connection string should specify the host name (or address) of the sending server, as well as the port number if it is not the same as the standby server's default. Also specify a user name corresponding to a suitably-privileged role on the sending server (see streaming-replication-authentication). A password needs to be provided too, if the sender demands password authentication. It can be provided in the
primary_conninfo string, or in a separate ~/.pgpass file on the standby server (use
replication as the database name). Do not specify a database name in the
This parameter can only be set in the postgresql.conf file or on the server command line. If this parameter is changed while the WAL receiver process is running, that process is signaled to shut down and expected to restart with the new setting (except if
primary_conninfo is an empty string). This setting has no effect if the server is not in standby mode.
- PostgreSQL 12 streaming replication active, password change not working
- Is it mandatory to set "restore_command" and "archive_cleanup_command" in recovery.conf?
- .pgpass for PostgreSQL replication in Dockerized environment
- How to promote standby server upon failure of the master/primary server in postgresql streaming replication
- Postgre 12.2 - pg_ctl: could not start server but no other info is shown