Home > mailing lists

9.2 Replication in Ubuntu ; need help - Mailing list pgsql-general

From	AI Rumman
Subject	9.2 Replication in Ubuntu ; need help
Date	September 12, 2013 17:53:49
Msg-id	CAGoODpcxrvTtUo7hoa-AYys2KOCr3MXw24Yst+nqgHiPLi8dgg@mail.gmail.com Whole thread Raw
Responses	Re: 9.2 Replication in Ubuntu ; need help (Michael Paquier <michael.paquier@gmail.com>) Re: 9.2 Replication in Ubuntu ; need help (Suzuki Hironobu <hironobu@interdb.jp>)
List	pgsql-general

Hi,

I am trying to setup replication with Postgresql 9.2 in Ubuntu on Amazon Ec2.

But stuck in the process.

Postgresql standby log is showing:

2013-09-12 14:45:47 UTC LOG: entering standby mode

2013-09-12 14:45:47 UTC LOG: redo starts at 1/39000020

2013-09-12 14:45:47 UTC LOG: record with zero length at 1/3905C088

2013-09-12 14:45:47 UTC LOG: streaming replication successfully connected to primary

2013-09-12 14:45:47 UTC LOG: consistent recovery state reached at 1/391C8588

But ,

psql

2013-09-12 14:48:04 UTC FATAL: the database system is starting up

I configured replication for Centos so many times and followed those steps.

Is there something I am missing?

Thanks.

From: Giuseppe Broccolo
Date: 12 September 2013, 17:07:37
Subject: Re: Risk of set system wise statement_timeout

From: rob stone
Date: 12 September 2013, 18:17:03
Subject: Re: Small PosgreSQL locking function request - with bounty