Hello folks,
It's pretty simple to restore / Import PostgreSQL database using phpPgAdmin.
1. Login to cPanel and go to phpPgAdmin in the Databases section.
2. Select the database from the top left panel that you wish to restore.
3. Click on the SQL tab.
4. Click on the Browse button, and select your database backup file, and click on Open button.
5. Click on the Execute button to and the import process will start. This will take some time to restore/ import file, depending upon the size of the file.
6. After successfully execution, you will get a message SQL Executed.
That's all, Enjoy !! :)