When deciding how to analyze a possible system problem, consider the items in this checklist:
- Can ping reach the PostgreSQL server?
- Is it possible to use ssh to enter the server?
- Do simple commands such as echo immediately return a Command Prompt?
- Does uptime show the following:
- A system load higher than the number of available CPUs?
- Whether the server has?
- Can psql connect to PostgreSQL locally?
- Does the free command show the following:
- Any swap space used?
- Less free memory than used memory after accounting for cache?
- Does the df command indicate that the database storage is:
- Present and accounted for?
- Used below 95 percent?
- A system load higher than the number of available CPUs?
- Whether the server has rebooted ...