the control center shows that the database is in inconsistent state. What does this mean exactly? I've tried to get rid of it by trying the restart database command but the control center still keeps on showing it. The database can be connected to at this time.
You can ignore that message in most cases. Essentially it indicates one or more of the following conditions -
- an active transaction going on
- changes that took place in the database which have not been committed completely (active transaction!)
- changes that took place in the database which have been committed, but not flushed to the tablespace (i.e. flushed to logs only)