Debian DokuWiki

User Tools

Site Tools

Trace: • phpshell_scanner
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/09/01 23:50] – [postgresql.conf] k2patelstreaming_replication [2020/08/10 02:35] (current) – external edit 127.0.0.1
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.1314921037.txt.gz · Last modified: 2020/08/10 02:29 (external edit)