WAL Streaming Failure PostgreSQL 9.4
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
(pg_hba.conf)
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
finally
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.
On 05/28/2015 09:56 AM, Ivann Ruiz wrote:
I'm trying to setup streaming replication but I'm stuck, please help!
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.
What suggests to you that it is not replicating?
jD
--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On May 28, 2015 9:58 AM, "Ivann Ruiz" <ivann.jprog@gmail.com> wrote:
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 startedAnd then nothing else happens, please I really need help with this, I
appreciate all comments. Any questions, please feel free to ask.
Are you applying any load to master? If not, nothing needs to be
replicated so there is nothing to happen. If this is just for testing, run
pgbench -T 3600.
Cheers, Jeff