Skip to main content
Version: 2.0.5

PostgreSQL

📄️Databases

PostgreSQL databases are used to store and manage your application's data, making it accessible and organized for your applications and services.

📄️PostgreSQL Users

This section lists all your PostgreSQL users and offers options to reset a user's password or delete a user.

📄️pgAdmin

pgAdmin is an advanced PostgreSQL database management tool and is recommended only for experienced users.

📄️Database Wizard

The Database Wizard can be accessed on the PostgreSQL page by clicking the "Database Wizard" button. This tool is designed to streamline the creation of a new database, a new user, and their assignment to the database. When you initiate the database wizard, it will provide a secure, randomly generated password for the user, as well as a random username and database name. You have the flexibility to modify these options, and there is also an option to generate random values for each field.

📄️Create Database

Easily create a new PostgreSQL database in just a few clicks. Databases are essential for storing, organizing, and retrieving data for your applications.

📄️Create User

Easily create a new PostgreSQL user in just a few clicks. Users are used for interacting with databases or the PostgreSQL server.

📄️Assign User to DB

Assign a PostgreSQL user to an existing database to grant permissions for executing queries, modifying tables, and managing data.

📄️Remove User from DB

Remove a PostgreSQL user from an existing database to revoke their permissions and prevent access to execute queries, modify tables, or manage data.

📄️Import

Import tables into a PostgreSQL database using a .sql export file. This feature is useful for restoring backups, migrating data, or setting up initial database structures.

📄️Remote PostgreSQL

Remote PostgreSQL access gives you the ability to connect to a PostgreSQL database on this server from another (remote) device or location over the internet.

📄️Show Processes

This interface displays all currently active PostgreSQL queries (connections) from pgstatactivity.