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
To restore:
bzip2 -c -d tabledata.bz2 | psql -hlocalhost -Upostgres database
Source: http://www.solomonson.com/content/using-bzip-pgdump
1 comment:
Good info
Post a Comment