Adempiere ERP Data import and export shell command

If you want to dump/Export your adempiere database from PostgreSQL then use bellow Linux shell command

pg_dump -U adempiere postgres | gzip > Desktop/adempiere1.gz
pg_dump -U postgres adempiere | gzip > u01/adempiere1.gz   // final
pg_dump -U adempiere | gzip > /adempiere1.gz
pg_dump -U postgres adempiere | gzip > Desktop/adempiere1.gz
pg_dump -U postgres adempiere1 | gzip > u01/adempiere1.gz
pg_dump -U postgres adempiere3 | gzip > u01/adempiere-20-7-11.gz

NB: adempiere is user,  Desktop/adempiere1.gz is location where .gz file will be generated.

If you want to Import your adempiere database from PostgreSQL then use bellow Linux shell command

gunzip -c Desktop/adempiere-8-6-11.gz | psql -U postgres -d adempiere2
gunzip -c u01/adempiere_25_06_11.gz | psql -U postgres -d adempiere3
gunzip -c u01/adempiere-06-09-11-dayend.gz | psql -U postgres -d adempiere3

NB:  Desktop/adempiere-8-6-11.gz is a location where .gz file is located and adempiere2 is a database name. postgres is a super user.