PostgreSQL: Restore DB from SQL

#Upload the backup .sql file to the server

#Execute the following command.

root@ubuntu:~# psql -Uadempiere idempiere < /opt/idempiere-server/DBImport/DB3.sql

Ricardo Malla's Blog