* Mark Woodward (pgsql@mohawksoft.com) wrote:
> > 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.
Not too bad. I had 2003 (iirc) loaded into 7.4 at one point.
> pg_dump tiger | gzip > tiger.pgz
What db version are you using, how did you load it (ogr2ogr?), is it in
postgis form? Fun questions, all of them. :)
> I'll let you know. Hopefully, it will fit on DVD.
I guess your upload pipe isn't very big? snail-mail is slow... :)
> You know, ... maybe pg_dump needs a progress bar? (How would it do that, I
> wonder?)
Using the new functions in 8.1 which provide size-on-disk of things,
hopefully there's also a function to give a tuple-size or similar as
well. It'd be a high estimate due to dead tuples but should be
sufficient for a progress bar.
Thanks,
Stephen