Monday, November 11, 2013

Bzip2 PGDump



To backup:
pg_dump -hlocalhost -Upostgres -a -t table database|bzip2 > tabledata.bz2

To restore:
bzip2 -c -d tabledata.bz2 | psql -hlocalhost -Upostgres database


Source: http://www.solomonson.com/content/using-bzip-pgdump