Hot standby streaming replication doesn't work

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Hot standby streaming replication doesn't work
Date: 2012-06-24 06:57:27
Message-ID: CAGuHJrM3fyai=QZ1fVWPWUm9Wz7NqAGeVsUyxWZwvAMq1TWJyg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am following the instructions on the wiki
https://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#PITR.2C_Warm_Standby.2C_Hot_Standby.2C_and_Streaming_Replication
using the "10 minute" version of the setup.

On the master I have

postgresql.conf

wal_level = hot_standby
max_wal_senders = 3
checkpoint_segments = 32
wal_keep_segments = 64

pg_hba.conf

host replication all 10.X.X.X/32 trust # (I set up a trust
for now.. I created the user on the master) BTW the wiki should tell
you to create the user.

on the slave I have

postgresql.conf
hot_standby = on

recovery.conf
standby_mode = 'on'
primary_conninfo = 'host=10.X.X.X port=5432 user=replication'

I followed the instructions for rsyncing the files over and restarted
the slave the log file says.

2012-06-24 06:51:13 UTC [25274]: [2-1] user=,db= LOG: received fast
shutdown request
2012-06-24 06:51:13 UTC [25274]: [3-1] user=,db= LOG: aborting any
active transactions
2012-06-24 06:51:13 UTC [25278]: [2-1] user=,db= FATAL: terminating
walreceiver process due to administrator command
2012-06-24 06:51:13 UTC [25276]: [1-1] user=,db= LOG: shutting down
2012-06-24 06:51:13 UTC [25276]: [2-1] user=,db= LOG: database system
is shut down
2012-06-24 06:51:15 UTC [25324]: [1-1] user=,db= LOG: database system
was shut down in recovery at 2012-06-24 06:51:13 UTC
2012-06-24 06:51:15 UTC [25325]: [1-1] user=[unknown],db=[unknown]
LOG: incomplete startup packet
2012-06-24 06:51:15 UTC [25324]: [2-1] user=,db= LOG: entering standby mode
2012-06-24 06:51:15 UTC [25324]: [3-1] user=,db= LOG: consistent
recovery state reached at 2F/670248B0
2012-06-24 06:51:15 UTC [25324]: [4-1] user=,db= LOG: redo starts at
2F/67024820
2012-06-24 06:51:15 UTC [25324]: [5-1] user=,db= LOG: record with
incorrect prev-link 2E/F1024868 at 2F/670248B0
2012-06-24 06:51:15 UTC [25323]: [1-1] user=,db= LOG: database system
is ready to accept read only connections
2012-06-24 06:51:15 UTC [25328]: [1-1] user=,db= LOG: streaming
replication successfully connected to primary

I created a table in the master and added some rows and that table
doesn't show up in the slave.

I see that both the sender and the receivers are running so I am at a
loss as to what is going on.

Any clues?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2012-06-24 07:06:44 Re: configuring queries for concurrent updates
Previous Message Craig Ringer 2012-06-24 06:49:40 Re: Error message "psql: could not connect to server: No such file or directory"