User Tools

Site Tools


streaming_replication

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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 ====
streaming_replication.txt · Last modified: 2020/08/10 02:35 (external edit)