Importing your database

Importing via the Control Panel

PhpPgAdmin can be used via the control panel to import PostgreSQL databases.

You will need the dump file created by PostgreSQL to use this process.

To import your database, from the control panel:

  1. Click the 'PostgreSQL web interface' link
  2. Enter the PostgreSQL username \& password

  3. Choose the database from the left hand navigation menu
  4. Under 'Run SQL Query...' click the 'Choose File' button and locate the dump file on your local machine, choose ok import.

Note: You will need to delete (drop) and tables which are in your existing database that share the same name as those being imported from your dump file.

Importing via the command line

Run the command:

psql -f dump_file.txt

Enter the database password when prompted.

Tuning the database server for imports

If you're running your own database server, you can tune the database to make your import go faster, as detailed in our PostgreSQL server tuning guide.