This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
streaming_replication [2011/07/25 16:34] k2patel |
streaming_replication [2011/12/12 17:17] k2patel [postgresql.conf] |
||
---|---|---|---|
Line 10: | Line 10: | ||
==== postgresql.conf ==== | ==== postgresql.conf ==== | ||
- | <code ini> | + | <code bash> |
listen_addresses = '*' | listen_addresses = '*' | ||
port = 5435 #### Only Define if you running on non default port. | port = 5435 #### Only Define if you running on non default port. | ||
Line 39: | Line 39: | ||
- | 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()" \\ |