I am following the instructions on the wiki
https://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#PITR.2C_Warm_Standby.2C_Hot_Standby.2C_and_Streaming_Replication
using the "10 minute" version of the setup.
On the master I have
postgresql.conf
wal_level = hot_standby
max_wal_senders = 3
checkpoint_segments = 32
wal_keep_segments = 64
pg_hba.conf
host replication all 10.X.X.X/32 trust # (I set up a trust
for now.. I created the user on the master) BTW the wiki should tell
you to create the user.
on the slave I have
postgresql.conf
hot_standby = on
recovery.conf
standby_mode = 'on'
primary_conninfo = 'host=10.X.X.X port=5432 user=replication'
I followed the instructions for rsyncing the files over and restarted
the slave the log file says.
2012-06-24 06:51:13 UTC [25274]: [2-1] user=,db= LOG: received fast
shutdown request
2012-06-24 06:51:13 UTC [25274]: [3-1] user=,db= LOG: aborting any
active transactions
2012-06-24 06:51:13 UTC [25278]: [2-1] user=,db= FATAL: terminating
walreceiver process due to administrator command
2012-06-24 06:51:13 UTC [25276]: [1-1] user=,db= LOG: shutting down
2012-06-24 06:51:13 UTC [25276]: [2-1] user=,db= LOG: database system
is shut down
2012-06-24 06:51:15 UTC [25324]: [1-1] user=,db= LOG: database system
was shut down in recovery at 2012-06-24 06:51:13 UTC
2012-06-24 06:51:15 UTC [25325]: [1-1] user=[unknown],db=[unknown]
LOG: incomplete startup packet
2012-06-24 06:51:15 UTC [25324]: [2-1] user=,db= LOG: entering standby mode
2012-06-24 06:51:15 UTC [25324]: [3-1] user=,db= LOG: consistent
recovery state reached at 2F/670248B0
2012-06-24 06:51:15 UTC [25324]: [4-1] user=,db= LOG: redo starts at
2F/67024820
2012-06-24 06:51:15 UTC [25324]: [5-1] user=,db= LOG: record with
incorrect prev-link 2E/F1024868 at 2F/670248B0
2012-06-24 06:51:15 UTC [25323]: [1-1] user=,db= LOG: database system
is ready to accept read only connections
2012-06-24 06:51:15 UTC [25328]: [1-1] user=,db= LOG: streaming
replication successfully connected to primary
I created a table in the master and added some rows and that table
doesn't show up in the slave.
I see that both the sender and the receivers are running so I am at a
loss as to what is going on.
Any clues?