I'm trying to setup streaming replication but I'm stuck, please help!
I followed the steps in https://wiki.postgresql.org/wiki/Streaming_Replication
On Master I have (postgresql.conf)
archive_mode = on wal_level = archive max_wal_senders = 5 wal_keep_senders = 150
host replication user-with-rep IP/32 md5
On slave I have (recovery.conf) primary_conninfo = ' host=IP port=5432 user=USER password=PWD ' standby_mode = 'on' restore_command = 'copy "\\path\%f" "%p" '
I start services on primary and then do a backup with
psql -c "SELECT pg_start_backup('label', true)"
Then I copy all files from primary to standby with
xcopy from\path\* to\path /s /i /e
psql -c "SELECT pg_stop_backup()"
When I execute pg_ctl start on my standby I get the following
LOG: database system was interrupted; last known up at 2015-05-27 14:16:41 EDT LOG: entering standby mode LOG: restored log file "000000010000000000000028" from archive LOG: redo starts at 0/28000090 LOG: consistent recovery state reached at 0/280000B8 LOG: unexpected pageaddr 0/24000000 in log segment 000000010000000000000029, offset 0 LOG: started streaming WAL from primary at 0/29000000 on timeline 1
And on my master I have
LOG: database system was shut down at 2015-05-27 16:00:14 EDT LOG: database system is ready to accept connections LOG: autovacuum launcher started
And then nothing else happens, please I really need help with this, I appreciate all comments. Any questions, please feel free to ask.
I would like to have this setup first and then do replication slots.