In order to register a PostgreSQL server, you need to fill out the dialog below, reached via the Server Manager and the Register Server button.
Register a PostgreSQL Server
Database Workbench needs the following information:
Alias |
An user-defined alias name for the server - this is only used inside Database Workbench. |
Folder |
A Server Manager folder for grouping your server registrations. |
Hostname |
Hostname or IP address of the machine where the PostgreSQL server process is running. |
Port |
IP port that the PostgreSQL server process is listening on for incoming connections. |
Username |
The default username for databases. |
Password |
The password for the username given. |
If you click OK, Database Workbench will test the connection - if this succeeds, the server will be registered and added to the Servers node in the Enterprise Manager.
Under Visible Databases you can filter the list of database you see in the Enterprise Manager, this list will fill itself after the connection succeeds.