Re: 9.2 Replication in Ubuntu ; need help

Hi,

(13/09/12 23:53), AI Rumman wrote:
> 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.
>

This FATAL message is returned when the status of primary server is
PM_STARTUP or PM_RECOVERY.
I guess your primary server is in startup state.
Can you access to the primary server using psql? Please check the
primary server.

Regards,