Below are the steps to restore a PgSQL database :-
1. Login to the H-Sphere control panel.
2. Go to databases –> PGSQL databases.
3. Click the name link of a database and open the phpPgAdmin interface.
4. Login to the phpPgAdmin tool.
5. Once in the phpPgAdmin interface, select the name of the database which you wish to restore from its backup to open its management panel and then 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.
6. 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 by phpPgAdmin.
]]>