PostgreSQL + pgAdmin

Getting Started

Select PostgreSQL + pgAdmin as the plugin. There are no Application Parameters for this plugin.

Postgres (browser-based terminal) and pgAdmin will launch in a browser. This plugin starts Postgres services, launched TTYD and uses TTYD or pgAdmin as management support. If this is the initial launch of Postgres, we will want to login to the Postgres database and generate a strong password.

In TTYD, enter the following:

Connect to Postgres

After logging in, we can proceed with the Postgres ‘alter’ command to set a password for your personal account. It is strongly recommended that you enter a password that follows the typical strength requirements - a combinations of upper case, lower case, special characters and numbers.

Enter the following:

Postgres Alter Account Generate Password

In pgAdmin, we can now click the ‘Add New Server’ in the Quick Links section.

pgAdmin Add New Server

When selecting the ‘Add New Server’, under the General tab, the only input here is providing a Name for the server. Enter ‘localhost’ in the Name field.

pgAdmin General Tab Add Server Name

In the Connection tab, provide the following:

Hostname/address: localhost
Port: 5432
Maintenance database: postgres
Username: account
Password: strong password (generated in psql)

The options to ‘Save password’ and specify roles created within psql are available. Further options such as SSL, SSH Tunnel and Advanced we don’t have to input any further at this time.

pgAdmin Connection Tab Configuration

Once authenticated, a similar pgAdmin dashboard interface will open:

pgAdmin Dashboard

If you prefer to manage Postgres only with a browser based TTYD terminal, please launch the PostgreSQL plugin.

External References

For more information on how to use Postgres, please visit

For more information on how to use pgAdmin, please visit