Order Now
Home>Encyclopedia>Video Tutorials>PgSQL>How to restore PgSQL database
Fast and reliable control panel

How to restore a PgSQL database from backup

Domains and Subdomains Video Tutorials



Our Most Popular Hosting Plans



Budget Hosting

Value Hosting

Plus Hosting

Exclusive Hosting
Budget Hosting - $4.95 per month Value Hosting - $7.95 per month Plus Hosting - $9.95 per month Exclusive Hosting - $14.95 per month
Unlimited Space Unlimited Space Unlimited Space Unlimited Space
Unlimited Traffic Unlimited Traffic Unlimited Traffic Unlimited Traffic
1 Domains Unlimited Domains Unlimited Domains Unlimited Domains
FREE Domain
Registration/Transfer *		 FREE Domain
Registration/Transfer *		 FREE Domain
Registration/Transfer *		 FREE Domain
Registration/Transfer *
Order Joomla Web Hosting
Order eLearning Web Hosting
Order WordPress Web Hosting
Order 4images Web Hosting

How to restore a PostgreSQL database from a backup file - overview


1. First of all, you need to log into your web hosting Control Panel. To do this - go to the Control Panel login link in the upper right corner of our hosting site and fill in your web hosting account details in the Members Area Login form. Then hit the 'Login' button to go to your Control Panel.

2. The second step is logging into the PostgreSQL Databases section. To do that, click on the PostgreSQL Databases icon located in the Site Management section of the Web Hosting Control Panel.

3. The final and most important step is restoring a PostgreSQL database from a dump file.

3.1. First, you need to open the phpPgAdmin tool, by clicking the name link of a database or its corresponding phpPgAdmin icon.

3.2. Once in the phpPgAdmin interface, select the name of the database, which you wish to restore from backup to open its management panel, press the SQL tab from the main menu and browse to the backup/dump file using the 'Browse' button option. As soon as you locate your dump file, click the 'Open' button.

3.3. After the dump file has been selected, you should click on 'Execute' to start importing the dump file to your database. Then click on the 'Tables' option to check whether the database is now displayed in your phpPgAdmin.

You have just learnt how to restore a PostgreSQL database from a dump file through the phpPgAdmin tool.