psql: FATAL: the database system is starting up

From: "ascot(dot)moss(at)gmail(dot)com" <ascot(dot)moss(at)gmail(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: psql: FATAL: the database system is starting up
Date: 2013-08-06 10:42:35
Message-ID: 3F584181-EF85-4040-886E-0B1EB3257794@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I just setup the replication in the slave again, when trying to use psql, I could not get the psql command prompt but got "psql: FATAL: the database system is starting up" from it.

PG: 9.2.4

Below is the log from the the slave:
LOG: database system was shut down in recovery at 2013-08-06 18:34:44
LOG: entering standby mode
LOG: consistent recovery state reached at 1C/9A0F9CF0
LOG: record with zero length at 1C/9A0F9CF0
LOG: streaming replication successfully connected to primary
FATAL: the database system is starting up

I am new to PG replication, please help.

regards

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Haribabu kommi 2013-08-06 10:52:52 Re: psql: FATAL: the database system is starting up
Previous Message Andres Freund 2013-08-06 10:33:20 Re: [GENERAL] Bottlenecks with large number of relation segment files