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:
- Click the 'PostgreSQL web interface' link
Enter the PostgreSQL username \& password
- Choose the database from the left hand navigation menu
- 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.