PostgreSQL 9 Administration Cookbook - Second Edition

Troubleshooting a failed connection

This recipe is all about what you should do when things go wrong.

Bear in mind that 90 percent of the problems are just misunderstandings, and you'll quickly be on track again.

How to do it…

Here we've made a checklist to be followed in case a connection attempt fails:

• Check whether the database name and username are accurate. You may be requesting a service on one system while the database you require is on another system. Recheck your credentials. Especially ensure that you haven't mixed things up, so that you are using the database name as the username or vice versa. If you receive "too many connections," then you may need to disconnect another session before you can connect, or wait for the administrator to ...