Debian DokuWiki

User Tools

Site Tools

Trace: • phpshell_scanner • solaris • upgrade_using_ius • errors • git
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/12/12 17:17] – [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. 
-bin/psql -c "SELECT pg_start_backup('label', true)" \\ +<code bash> 
-rsync -av data/ <IP>:standby/ --exclude postmaster.pid \\ +bin/psql -c "SELECT pg_start_backup('label', true)" 
-bin/psql -c "SELECT pg_stop_backup()" \\ +rsync -av data/ <IP>:standby/ --exclude postmaster.pid 
 +bin/psql -c "SELECT pg_stop_backup()" 
 +</code>
  
 ==== Recovery.conf ==== ==== Recovery.conf ====
streaming_replication.1323710244.txt.gz · Last modified: 2020/08/10 02:29 (external edit)