To dump mir database : pg_dumplo -a -d -s /dumpdir/dir pg_dump -c -D -f /dumpdir/.sql this generates a dir with all blobs and a sql-file with all data. To restore the database: psql < .sql pgdump_lo -i -d -s /dumpdir/dir