Re: Live steraming replication setup issue!

> Currently we have master -> slave -> DR hot standby streaming replication in
> current prod environment. Between master and slave server replication running
> fine. Between slave and DR server replication is broken and I am trying to fix
> it. For DR server, slave server is master server.
>
> Issue: Few days back, DR was lagging behind slave server and stopped
> replication. I tried to setup the replication from slave to DR (currently
> there is replication running from master to slave) with pg_basebackup command,
> I am able to restart Postgres without any error on DR server but when I try to
> run any psql on DR, it throwing up below error.
>
> psql: FATAL:  the database system is starting up



please show us your recovery.conf. this should include this line:

standby_mode          = 'on'


--
Andreas Kretschmer
http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services