May 2018
Intermediate to advanced
576 pages
30h 25m
English
To archive a physical WAL from a server called alpha, follow these steps:
pg_receivewal -D /pgarchive/alpha -d $MYCONNECTIONSTRING &
If the connection from the client tool to the server is lost, the default behavior is to loop indefinitely while trying to re-establish a connection. If you want the client tool to exit if the connection is lost, then specify the -n or --no-loop options.
The pg_recvlogical utility requires some form of logical decoding plugin, so look at the instructions for the plugin ...