You can also do it directly to Postgres:
dropdb dbname createdb dbname gunzip -c filename.gz | psql dbname