Postgres Pro
Downloads
Home   >   mailing lists

Re: Dump size bigger than pgdata size? - Mailing list pgsql-admin

From Jim Nasby
Subject Re: Dump size bigger than pgdata size?
Date
Msg-id 5F1778F3-ACEA-44C3-B895-D651EF62CBBA@pervasive.com
Whole thread Raw
In response to Re: Dump size bigger than pgdata size?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Dump size bigger than pgdata size?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
On Jun 21, 2006, at 12:00 PM, Tom Lane wrote:
> This could be avoided by using COPY BINARY format, but I don't see any
> very nice way to do that in the context of pg_dump --- it needs to
> intermix COPY data with SQL commands ...

Would the tar or custom format allow for this? IIRC, at least tar
puts all the copied data into separate files...
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Question on failure during cluster operation
Next
From: Jim Nasby
Date:
Subject: Re: LOG: statistics buffer is full