Backup Restore Postgresql

** backup **

[enter password utk postgres -- bila perlu]

root#passwd postgres

[enter password]

root#su postgres

postgres# pg_dump -W -F t idempiere > /tmp/idempiere.tar

exit

** restore **

root#su postgres

postgres#psql  --masuk psql

postgres# drop database idempiere

postgres# create database idempiere

postgres# exit ---dari psql

postgres# pg_restore --dbname=idempiere < /tmp/idempiere.tar

exit

** selesai **