Create a ltcluster.conf file on the standby server. It must contain at
least the same parameters as the primary's ltcluster.conf, but with
the mandatory values node, node_name, conninfo
(and possibly data_directory) adjusted accordingly, e.g.:
node_id=2
node_name='node2'
conninfo='host=node2 user=ltcluster dbname=ltcluster connect_timeout=2'
data_directory='/var/lib/lightdb/data'
Use the --dry-run option to check the standby can be cloned:
$ ltcluster -h node1 -U ltcluster -d ltcluster -f /etc/ltcluster.conf standby clone --dry-run
NOTICE: using provided configuration file "/etc/ltcluster.conf"
NOTICE: destination directory "/var/lib/lightdb/data" provided
INFO: connecting to source node
NOTICE: checking for available walsenders on source node (2 required)
INFO: sufficient walsenders available on source node (2 required)
NOTICE: standby will attach to upstream node 1
HINT: consider using the -c/--fast-checkpoint option
INFO: all prerequisites for "standby clone" are metIf no problems are reported, the standby can then be cloned with:
$ ltcluster -h node1 -U ltcluster -d ltcluster -f /etc/ltcluster.conf standby clone
NOTICE: using configuration file "/etc/ltcluster.conf"
NOTICE: destination directory "/var/lib/lightdb/data" provided
INFO: connecting to source node
NOTICE: checking for available walsenders on source node (2 required)
INFO: sufficient walsenders available on source node (2 required)
INFO: creating directory "/var/lib/lightdb/data"...
NOTICE: starting backup (using lt_basebackup)...
HINT: this may take some time; consider using the -c/--fast-checkpoint option
INFO: executing:
lt_basebackup -l "ltcluster base backup" -D /var/lib/lightdb/data -h node1 -U ltcluster -X stream
NOTICE: standby clone (using lt_basebackup) complete
NOTICE: you can now start your LightDB server
HINT: for example: lt_ctl -D /var/lib/lightdb/data start
This has cloned the LightDB data directory files from the primary node1
using LightDB's lt_basebackup utility. A recovery.conf
file containing the correct parameters to start streaming from this primary server will be created
automatically.
By default, any configuration files in the primary's data directory will be
copied to the standby. Typically these will be lightdb.conf,
lightdb.auto.conf, lt_hba.conf and
lt_ident.conf. These may require modification before the standby
is started.
Make any adjustments to the standby's LightDB configuration files now, then start the server.
For more details on ltcluster standby clone, see the
command reference.
A more detailed overview of cloning options is available in the
administration manual.