Re: Unable to start postgres instance.

["Hunley, Douglas" <douglas.hunley@xxxxxxxxxxx>]

On Thu, Apr 27, 2017 at 3:38 PM, Gone, Sajan <SGone@xxxxxx> 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@xxxxxxxxxxx",

  "mobile" : "+1 614 316 5079"

}