Posts

Showing posts from October, 2017

Import Postgres Backup in linux command line

sudo su postgres psql -U postgres dhis2 < /home/downloads/dbexport.pgsql

Export dhis2 postgres backup in linux ubuntu command line

root@softworksdhis2:/# pg_dump -U dhis -h localhost dhis2 -f /home/backup_dhis2/dhis2_04_10_17.sql

Connect remote postgres with local pgAdmin (III)

Image