Skip to content
0333 090 4540
Snappyhost

Use PostgreSQL databases and phpPgAdmin

Set up PostgreSQL only for applications that specifically require it.

Where Tools → Databases → PostgreSQL Databases / PostgreSQL Database Wizard / phpPgAdmin

Before you start

  • Check the application requires PostgreSQL rather than MySQL/MariaDB. They are not interchangeable.
  • Prepare a strong database password and a backup plan.

Steps

  1. 1

    Open PostgreSQL Database Wizard for guided setup, or PostgreSQL Databases for separate database and user controls.

  2. 2

    Record the full database name, username and host privately in the application configuration. Use Synchronize Grants only when needed to reconcile grants, not as a substitute for creating the correct association.

  3. 3

    Enter the database name, check its account prefix and create it. Create an appropriate PostgreSQL user with a unique password.

    The PostgreSQL wizard begins with a database name.
  4. 4

    Associate that user with the database and grant the access the application requires. A user is separate from an email or FTP login.

    Database and user creation are separate operations.
  5. 5

    Open phpPgAdmin after a database exists. Choose the intended database before browsing or running SQL; export a backup before modifications or restores.

    phpPgAdmin cannot manage application data until a database exists.

Check it worked

  • Confirm the database and user relationship in cPanel.
  • Test the application connection. If phpPgAdmin says No database defined, create a PostgreSQL database first.