Обсуждение: Hot standby streaming replication doesn't work

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?

I am using 9.1.

Apparently it's working now, it took a couple of restarts but it seems
to be going.

Thanks.

On Mon, Jun 25, 2012 at 12:57 PM, Michael Nolan <htfoot@gmail.com> wrote:
>
>
> On Sun, Jun 24, 2012 at 1:57 AM, Tim Uckun <timuckun@gmail.com> wrote:
>>
>> 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.
>>
>
> What version of postgresql are you running?
> --
> Mike Nolan