Re: Dump size bigger than pgdata size?

From: Jim Nasby <jnasby(at)pervasive(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Nicola Mauri" <Nicola(dot)Mauri(at)saga(dot)it>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Dump size bigger than pgdata size?
Date: 2006-06-23 01:58:14
Message-ID: 5F1778F3-ACEA-44C3-B895-D651EF62CBBA@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jim Nasby 2006-06-23 02:00:54 Re: LOG: statistics buffer is full
Previous Message Tom Lane 2006-06-22 17:05:01 Re: Question on failure during cluster operation