> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
