Postgres Pro
Downloads
Home   >   mailing lists

Thread: WAL Streaming Failure PostgreSQL 9.4

WAL Streaming Failure PostgreSQL 9.4

From
Ivann Ruiz
Date:

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.

Re: WAL Streaming Failure PostgreSQL 9.4

From
"Joshua D. Drake"
Date:
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.

Re: WAL Streaming Failure PostgreSQL 9.4

From
Jeff Janes
Date:


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 started
>
> And 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