PostgreSQL is an open source, object-relational database built with a focus on extensibility, data integrity, and speed. Its concurrency support makes it fully ACID compliant, and it supports dynamic loading and catalog-driven operations to let users customize its data types, functions, and more.
PostgreSQL database clusters come configured with a default database (
defaultdb) and a default administrative user (
doadmin). These defaults are necessary for cluster replication and administration, so you can’t delete them, but you can add additional users and databases.
To add or delete users or databases to a database cluster, click the name of the database to go to its Overview page, then select the Users & Databases tab.
Create a new database in the Databases section by entering a name in the Add new database field and clicking Save. You can also delete a database here by opening its More menu, clicking Delete, and then confirming the deletion.
Create new users in the Users section by entering a name in the Add new user field and clicking Save. New users will receive the permissions of the
doadmin user by default. You can’t change these permissions from the control panel, but you can modify user privileges using third-party tools like psql.
You can also delete a user here by opening the user’s More menu, clicking Delete, and then confirming the deletion. Simiarly, to reset a user’s password, open the user’s More menu and select Reset password.