Re: [ADMIN] Unable to start postgres instance. - Mailing list pgsql-admin

From Hunley, Douglas
Subject Re: [ADMIN] Unable to start postgres instance.
Date
Msg-id CAAD=pwEBjg2MUacnfMYhbOBHjcqBiX+OP7iW+-faiqSQeC6s-w@mail.gmail.com
Whole thread Raw
In response to [ADMIN] Unable to start postgres instance.  ("Gone, Sajan" <SGone@lb.com>)
Responses Re: [ADMIN] Unable to start postgres instance.  ("Gone, Sajan" <SGone@lb.com>)
List pgsql-admin

On Thu, Apr 27, 2017 at 3:38 PM, Gone, Sajan <SGone@lb.com> wrote:
-bash-4.3$ psql -U postgres
psql: FATAL:  the database system is starting up

However its been on that from quite a long time. It would really appreciate if anyone could explain me on what is really going on.

It is doing exactly what it should. A standby is, by default, in permanent recovery mode. If you wish to be able to connect to it in this mode, you need to add 'hot_standby = on' to its postgresql.conf and restart the standby. 


--
{
  "name" : "douglas j hunley",
  "title" : "database engineer",
  "email" : "douglas.hunley@openscg.com",
  "mobile" : "+1 614 316 5079"
}

pgsql-admin by date:

Previous
From: "Gone, Sajan"
Date:
Subject: [ADMIN] Unable to start postgres instance.
Next
From: "Gone, Sajan"
Date:
Subject: Re: [ADMIN] Unable to start postgres instance.