This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
streaming_replication [2011/12/12 17:17] k2patel [postgresql.conf] |
streaming_replication [2011/12/12 17:18] k2patel [postgresql.conf] |
||
---|---|---|---|
Line 35: | Line 35: | ||
hostssl replication all <IP>/32 trust | hostssl replication all <IP>/32 trust | ||
+ | <code bash> | ||
bin/pg_ctl -p bin/postmaster -D data -l pgstartup.log start | bin/pg_ctl -p bin/postmaster -D data -l pgstartup.log start | ||
bin/pg_ctl -p bin/postmaster -D data -l pgstartup.log stop | bin/pg_ctl -p bin/postmaster -D data -l pgstartup.log stop | ||
+ | </code> | ||
- | + | <code bash> | |
- | bin/psql -c "SELECT pg_start_backup('label', true)" \\ | + | bin/psql -c "SELECT pg_start_backup('label', true)" |
- | rsync -av data/ <IP>:standby/ --exclude postmaster.pid \\ | + | rsync -av data/ <IP>:standby/ --exclude postmaster.pid |
- | bin/psql -c "SELECT pg_stop_backup()" \\ | + | bin/psql -c "SELECT pg_stop_backup()" |
+ | </code> | ||
==== Recovery.conf ==== | ==== Recovery.conf ==== |