Re: Unable to start postgres instance.

On Thu, Apr 27, 2017 at 3:38 PM, Gone, Sajan <SGone(at)lb(dot)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(dot)hunley(at)openscg(dot)com <doug(dot)hunley(at)gmail(dot)com>",
"mobile" : "+1 614 316 5079"
}