Table of Contents
Manage PostgreSQL databases
Only the primary user for the account has access to PostgreSQL databases.
Create a PostgreSQL database
To create a new database through Virtualmin, do the following:
Database names can only contain alphanumeric characters and underscores. Other characters, like periods, will cause an error.
- Sign in to Virtualmin (see Account logins and important URLs).
- Select a domain from the drop-down in the left-hand navigation (your main domain should be already selected when you first login to Virtualmin). This is the domain that you’ll add a new database to.
- Click Edit Databases. You should now see a list of your current databases on the Edit Databases page.
- Click Create a new database.
- In the Database name field enter a name for your database
- Database names will automatically be prefixed with your main user name. On secondary domains, the first part of the domain name is inserted as a second prefix after the user name (e.g., username_domainname_dbname ).
- For Database server type, select PostgreSQL.
- Leave Character set for MySQL database as the default value.
- Click Create Your database has now been created.
- Click Return to database list to see your list of databases
You should now see your newly created database listed under Database name.
Delete a PostgreSQL database
To delete a database through Virtualmin, do the following:
- Sign in to Virtualmin (see Account logins and important URLs).
- Select a domain from the drop-down in the left-hand navigation (your main domain should be already selected when you first login to Virtualmin). This is the domain that you’ll add a new database to.
- Click Edit Databases. You should now see a list of your current databases on the Edit Databases page.
- Select the database you want to delete from the left-hand column and click Delete Selected. You will now see a confirmation screen verifying that you want to delete this database.
- Click Delete Now Your PostgreSQL database should now be deleted. Click Return to database list if you wish to return to your list of databases for this domain.