From: | Ivann Ruiz <ivann(dot)jprog(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | WAL Streaming Failure PostgreSQL 9.4 |
Date: | 2015-05-28 16:56:29 |
Message-ID: | CA+FHAKfGBDHFF16spQi_Y_L-Bvni1HJ8xYyHm1=cfwWbZnTXiA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2015-05-28 17:04:40 | Re: WAL Streaming Failure PostgreSQL 9.4 |
Previous Message | Ravi Krishna | 2015-05-28 16:51:02 | Re: Partitioning and performance |