Database Reference
In-Depth Information
The port number prompted is 2345, though this is deliberately not the default PostgreSQL
port of
5432
, presumably to force you to think about what setting should be used.
You should uncheck the Store password box.
If you have many database servers, you can group them together. Personally, I would avoid
giving each server a colour, as green, yellow, and red are usually taken to mean status,
which could easily be misinterpreted. Just give each server a sensible name.
You will then get access to the main browser screen, with the object tree view on the left,
and properties on the top-right, as shown in the following screenshot:
pgAdmin easily displays much of the data that is available from PostgreSQL. The information
is context sensitive, allowing you to browse around and see everything quickly and easily. The
information is not dynamically updated; this will only occur when you click to refresh, so keep
function key
F5
in mind when using the application.
You'll also find pgAdmin provides a TIP of the Day, though I would turn those off. Keep the
Guru Hints option on, though luckily no chirpy paperclips offering suggestions.
pgAdmin also provides an Object Report generator and a Grant Wizard. These are useful for
DBAs for review and immediate maintenance.
