title: postgresql database not replicating. No errors
body: <p><strong>Background:</strong> </p>
  
  <p>I am trying to set up streaming replication between two servers.  Although postgresql is running on both boxes without any errors, when I add or change a record from the primary, these changes are not reflected on the secondary server. </p>
  
  <p>I have the following set up on my primary database server: </p>
  
  <p>(Note:  I'm using fake ip addresses but 10.222.22.12 represents the primary server and .21 the secondary)</p>
  
  <p><strong>primary server - posgresql.conf</strong></p>
  
  <pre><code>listen_addresses = '10.222.22.12'
  unix_socket_directory = '/tmp/postgresql'
  wal_level = hot_standby
  max_wal_senders = 5             # max number of walsender processes
                                  # (change requires restart)
  wal_keep_segments = 32          # in logfile segments, 16MB each; 0 disables
  </code></pre>
  
  <p><strong>primary server - pg_hba.conf</strong></p>
  
  <pre><code>host    all             all             10.222.22.21/32         trust
  host    replication     postgres        10.222.22.0/32          trust
  </code></pre>
  
  <p><strong>primary server - firewall</strong></p>
  
  <p>I've checked to make sure all incoming to the fw is open and that all traffic out is allowed. </p>
  
  <p><strong>secondary server - posgresql.conf</strong></p>
  
  <pre><code>listen_addresses = '10.222.22.21'
  wal_level = hot_standby
  max_wal_senders = 5             # max number of walsender processes
                                  # (change requires restart)
  wal_keep_segments = 32          # in logfile segments, 16MB each; 0 disables
  hot_standby = on              
  </code></pre>
  
  <p><strong>secondary server - pg_hba.conf</strong></p>
  
  <pre><code>host    all             all             10.222.22.12/32         trust
  host    all             all             10.222.22.21/32         trust
  host    replication     postgres        10.222.22.0/24          trust
  </code></pre>
  
  <p><strong>secondary server - recovery.conf</strong></p>
  
  <pre><code>standby_mode='on'
  primary_conninfo = 'host=10.222.22.12 port=5432 user=postgres'
  </code></pre>
  
  <p><strong>secondary server firewall</strong></p>
  
  <p>everything is open here too. </p>
  
  <p><strong>What I've tried so far</strong></p>
  
  <ol>
  <li>Made a change in data on the primary.  Nothing replicated over. </li>
  <li>Checked the firewall settings on both servers. </li>
  <li>Checked the arp table on the secondary box to make sure it can communicate with the primary. </li>
  <li>checked the postmaster.log file on both servers.  They are empty.</li>
  <li>Checked the syslog file on both servers.  no errors noticed. </li>
  <li>restarted postgresql on both servers to make sure it starts without errors. </li>
  </ol>
  
  <p>I'm not sure what else to check.  If you have any suggestions, I'd appreciate it. </p>
  
  <p><strong>EDIT 1</strong></p>
  
  <p>I've checked the pg_stat_replication table <strong>on the master</strong> and I get the following results:</p>
  
  <pre><code>psql -U postgres testdb -h 10.222.22.12 -c "select * from pg_stat_replication;"
  
   pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | state | sent_location | write_location | flush_location | repl
  ay_location | sync_priority | sync_state 
  -----+----------+---------+------------------+-------------+-----------------+-------------+---------------+-------+---------------+----------------+----------------+-----
  ------------+---------------+------------
  (0 rows)
  </code></pre>
  
  <p>And <strong>on the slave</strong>, notice the results from the following query: </p>
  
  <pre><code>testdb=# select now()-pg_last_xact_replay_timestamp();
   ?column? 
  ----------
  
  (1 row)
  </code></pre>
  
  <p>openser=# </p>