- publishing free software manuals
The PostgreSQL 9.0 Reference Manual - Volume 3 - Server Administration Guide
by The PostgreSQL Global Development Group
Paperback (6"x9"), 274 pages
ISBN 9781906966072
RRP £9.95 ($14.95)

Sales of this book support the PostgreSQL project! Get a printed copy>>>

12.3 Standby server settings

standby_mode (boolean)
Specifies whether to start the PostgreSQL server as a standby. If this parameter is on, the server will not stop recovery when the end of archived WAL is reached, but will keep trying to continue recovery by fetching new WAL segments using restore_command and/or by connecting to the primary server as specified by the primary_conninfo setting.
primary_conninfo (string)
Specifies a connection string to be used for the standby server to connect with the primary. This string is in the format accepted by the libpq PQconnectdb function, described in Volume 2: Database Connection Control Functions. If any option is unspecified in this string, then the corresponding environment variable (see Volume 2: Environment Variables) 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 primary 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 role that has the SUPERUSER and LOGIN privileges on the primary (see section 11.2.5.1 Authentication). A password needs to be provided too, if the primary 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 primary_conninfo string. This setting has no effect if standby_mode is off.
trigger_file (string)
Specifies a trigger file whose presence ends recovery in the standby. If no trigger file is specified, the standby never exits recovery. This setting has no effect if standby_mode is off.
ISBN 9781906966072The PostgreSQL 9.0 Reference Manual - Volume 3 - Server Administration GuideSee the print edition