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