psql: FATAL: the database system is starting up

In this article, we will the solution for below error.

psql: FATAL:  the database system is starting up

Solution:

I have noticed this error on my Windows machine. I have checked whether PostgreSQL is running or not. PostgreSQL server is running fine on Windows.

Remedy: With permission of my application team, i restarted my PostgreSQL service. Then, error gone and successfully connected to PostgreSQL server on Windows.

C:\Users\karunakar>psql -h localhost -p5432 -U postgres
psql (11.2)
WARNING: Console code page (437) differs from Windows code page (1252)
         8-bit characters might not work correctly. See psql reference
         page "Notes for Windows users" for details.
Type "help" for help.

postgres=#