WAL Streaming Failure PostgreSQL 9.4

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.

Responses

Browse pgsql-general by date

  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