streaming_replication
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
streaming_replication [2011/07/25 16:34] k2patel |
streaming_replication [2020/08/10 02:35] (current) |
||
|---|---|---|---|
| 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 30: | Line 30: | ||
| </code> | </code> | ||
| - | pg_hba.conf | + | Setup access rule. |
| - | ^^^^^^^^^^^ | + | |
| + | <code bash | pg_hba.conf> | ||
| #Replication Trust | #Replication Trust | ||
| hostssl replication all <IP>/32 trust | hostssl replication all <IP>/32 trust | ||
| + | </code> | ||
| + | Postgres restart on Master | ||
| + | <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> | ||
| + | Sync current data over Rsync. | ||
| + | <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 ==== | ||
streaming_replication.1311611668.txt.gz · Last modified: 2020/08/10 02:29 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
