cancel
Showing results for 
Search instead for 
Did you mean: 

Postgres server fails to start

Scot_Clark
Sage

Postgres server fails to start

PostGreSQL service is needed for allowing logins with the WebUI. If the service is not running, logins to the Web UI won't happen.


If you notice the service is stopped, quickest thing to do would be to start the service. If there are deeper problems, the service may not start.service-error.png

 

First step would be to check the windows system events for more information on the problem. It may not always have complete information on the problem.

 

system-error.png

If the Windows System events don't show anything. you can look in the PostGreSQL logs located in the \PrognosisData\PostgresData\log folder. (or C:\PrognosisData\PostgresData\pg_log depending on version)

pg_error.png

 

Check the most recent file for errors. You may see errors regarding primary check point record.

 

"could not locate a valid checkpoint record "
“PANIC: could not locate a valid checkpoint record

 

checkpoint-error.PNG

This error could indicate that there is some corruption in the Postgres Transaction log. To fix this, you will have to reset the the transaction log with the "pg_resettxlog" command from the command line.  At first, You may get a permission denied error

 

txlog-perm-denied.png

To get past that error, you will have to delete or rename the transaction log file. To do this, browse to the \PrognosisData\PostGresData\pg_log folder for older prognosis versions or the C:\PrognosisData\PostgresData\pg_xact folder for newer or current version.

tx-log_folder.png

pg_tx_log_ren.png

 

After that, you can try run the pg_resetxlog command and it should run.

 

reset_tx-success.png

 

And a new TX log is created.

 

txlog_new.png

 

After that you can start the Postgres service and log on to the web UI.

 

pg_serv-restart.png

 

 

 

 

Tags (3)
Webinar: Keep the modern workforce connected

Unified Communications has always been an important part of companies' digital transformation efforts due to its ability to enable rich virtual collaboration and communication. But with COVID-19, we've reached a break-through point.

Join Bill Haskins, Sr. Analyst & Partner, Unified Communications at Wainhouse Research, and John Ruthven, CEO at IR discuss UC challenges companies are experiencing due to the COVOID-19 crisis.

Join webinar