Joyent

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.

  1. Sign in to Virtualmin (see Account logins and important URLs).
  2. 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.
  3. Click Edit Databases. You should now see a list of your current databases on the Edit Databases page.
  4. Click Create a new database.
  5. 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 ).
  6. For Database server type, select PostgreSQL.
  7. Leave Character set for MySQL database as the default value.
  8. Click Create Your database has now been created.
  9. 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:

  1. Sign in to Virtualmin (see Account logins and important URLs).
  2. 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.
  3. Click Edit Databases. You should now see a list of your current databases on the Edit Databases page.
  4. 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.
  5. 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.
 
shared/kb/manage-pgsql.txt · Last modified: 2007/11/10 20:31 by lderezinski
 
Recent changes RSS feed Creative Commons License Driven by DokuWiki