The most popular GUI tool for PostgreSQL administration is the pgAdmin utility. It is an independent software product, not affiliated with the PostgreSQL project. It can be downloaded from http://www.pgadmin.org.

After installing pgAdmin use it to connect to the database in order to check the server settings:

  • Launch pgAdmin;
  • click File/Add server menu item and enter your PostgreSQL server connection settings;
  • connect to the server.

You may also use psql, a default console client:

psql [-h server_host] [--username=<user>] -d template1

, where template1 is a system database.

Did this answer your question?