On Sep 21, 2006, at 10:54 PM, Charles Ambrose wrote:
> I have a fairly large database tables (say an average of 3Million
> to 4Million records). Using the pg_dump utility takes forever to
> dump the
Sounds like your either woefully mis-configured or woefully
underpowered or have a short definition of "forever" :-)
Every night we take a dump of our several hundred million row DB in
about 49 minutes. We use the "pg_dump -Fc" format and that comes to
a bit over 5GB of data compressed.