Connecting to the PostgreSQL database with pgAdmin¶
There are a number of front-end tools available for connecting to, and working with, the PostgreSQL database. Among the most popular are psql, a command-line tool for querying the database, and the free and open source graphical tool pgAdmin.
Any data querying and manipulation you can do with pgAdmin can also be done at the command line with
This section uses the client tool pgAdmin, a graphical utility provided as part of Boundless Desktop.
Working with pgAdmin¶
Depending on how you installed Boundless Server, you may already have one pre-configured PostGIS server,
localhost:5432, listed in the pgAdmin Object browser.
If you don’t have an entry for PostGIS listed, add a new server connection manually. Click New Server Registation dialog box to register a new server. Ensure the Host is set to localhost and Port is 5432 (unless you have configured PostgreSQL for a different port).and complete the
To connect to the PostGIS server, double-click the PostGIS server item and provide the password when prompted.
To view the databases in this instance, expand the Object browser.item. Double-click one of the listed databases to reveal the contents in the
When executing SQL queries, make sure you have the intended target database selected. The SQL Query dialog box will confirm the current database selection.
If you are just installing Boundless Server for the first time, there will only be a generic “postgres” database installed, with no tables, and you will need to create a new spatial database.