d
divija reddy

Posted on 29th March 2024|1335 views

0
votes

Psql Fatal The Database System Is Starting Up

In PostgreSQL, When do we get the error (Fatal: the database system is starting up)?

Answers
P
imran mohammad

Posted on 29th March 2024

When we add data to the database, then it only stores the thread-ahead log, and all the data will not save until the next checkpoint.

If the server stopped suddenly, it loses access to the file systems, when you restart it takes a while to find the last checkpoint. If you try to access the server before it considers the previous checkpoint then automatically it shows an error message as “Fatal: the database system is starting up”.

Write your answer

STILL GOT QUERIES?

Get a Live FREE Demo
  • Explore the trending and niche courses and learning maps
  • Learn about tuition fee, payment plans, and scholarships
  • Get access to webinars and self-paced learning videos