Debian DokuWiki

User Tools

Site Tools

Trace:
streaming_replication

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
streaming_replication [2011/07/25 16:34] – k2patelstreaming_replication [2020/08/10 02:35] (current) – external edit 127.0.0.1
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)