Postgres server not starting up

Question

I made a hard restart of my machine. After that, I am unable to start my server.

I killed the process listed in postmaster.pid and also removed the file. Now if I start the server using

pg_ctl start

it shows

Fatal : The database system is starting up

for very long time, which does not normally happen.

Can someone please help me in finding the root cause of it?

Naeem Khan · Accepted Answer · 2019-06-20 07:52:26Z

-1

Open your postgresql.conf and turn off the "hot_standby" option, and then restart the service with service postgresql restart.

answered Jun 20, 2019 at 7:52

Naeem Khan

9684 gold badges15 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

actually, after one and a half half hour it got started. By the way, i tried your way as well.