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
streaming_replication [2011/12/12 12:18]
k2patel [postgresql.conf]
streaming_replication [2011/12/12 12:20] (current)
k2patel [postgresql.conf]
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> <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
Line 40: Line 43:
 </​code>​ </​code>​
  
 +Sync current data over Rsync.
 <code bash> <code bash>
 bin/psql -c "​SELECT pg_start_backup('​label',​ true)" bin/psql -c "​SELECT pg_start_backup('​label',​ true)"
streaming_replication.txt · Last modified: 2011/12/12 12:20 by k2patel