Re: US Census database (Tiger 2004FE)

Mark Woodward <pgsql@mohawksoft.com>

From: "Mark Woodward" <pgsql@mohawksoft.com>
To: "Stephen Frost" <sfrost@snowman.net>
Cc: pgsql-hackers@postgresql.org
Date: 2005-08-04T12:40:18Z
Lists: pgsql-hackers
> * Mark Woodward (pgsql@mohawksoft.com) wrote:
>> I just finished converting and loading the US census data into
>> PostgreSQL
>> would anyone be interested in it for testing purposes?
>>
>> It's a *LOT* of data (about 40+ Gig in PostgreSQL)
>
> How big dumped & compressed?  I may be able to host it depending on how
> big it ends up being...

It's been running for about an hour now, and it is up to 3.3G.

pg_dump tiger | gzip > tiger.pgz

I'll let you know. Hopefully, it will fit on  DVD.

You know, ... maybe pg_dump needs a progress bar? (How would it do that, I
wonder?)