Debian DokuWiki

User Tools

Site Tools

Trace: • add_ssh_key_to_multiple_host • building_mariadb_on_freebsd • oracle_coherence • tuneup_guide • snapshot_backup • upgrade_using_ius • bash • apache
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:18] – [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> <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.1323710284.txt.gz · Last modified: 2020/08/10 02:29 (external edit)