Skip site navigation (1) Skip section navigation (2)

Re: pg_dump --split patch

From: Aidan Van Dyk <aidan(at)highrise(dot)ca>
To: Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
Cc: Joel Jacobson <joel(at)gluefinance(dot)com>, pgsql-hackers(at)postgresql(dot)org, Andrew Dunstan <andrew(at)dunslane(dot)net>, David Wilson <david(dot)t(dot)wilson(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: pg_dump --split patch
Date: 2010-12-29 14:23:38
Message-ID: AANLkTikMSdVM-enfs33mniJ_=NqwPCoULh5VzQKDPMDF@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wed, Dec 29, 2010 at 9:11 AM, Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com> wrote:
> On Wed, Dec 29, 2010 at 8:31 AM, Joel Jacobson <joel(at)gluefinance(dot)com> wrote:
>>
>>
>> 2010/12/29 Aidan Van Dyk <aidan(at)highrise(dot)ca>
>>>
>>> On Wed, Dec 29, 2010 at 2:27 AM, Joel Jacobson <joel(at)gluefinance(dot)com>
>>> wrote:
>>>
>>> <description of split stuff>
>>>
>>> So, how different (or not) is this to the "directory" format that was
>>> coming out of the desire of a parallel pg_dump?
>>
>> Not sure what format you are referring to? Custom, tar or plain text?
>> I noticed there are two undocumented formats as well, "append" and "file".
>> I tried both of these undocumented formats, but it did not procude any
>> directory structure of the dumped objects.
>> Could you please explain how to use the "directory format" is such a
>> format already exists?
>> I can't find it in the documentation nor the source code of HEAD.
>
> It is still being discussed as a patch to pg_dump. Google for "directory
> archive format for pg_dump", specifically in archives.postgresql.org.

Specifically:
Message-ID: <AANLkTimUELTXwRSQDQNwxik_k1y3YcH1u-9NgHZqpi9e(at)mail(dot)gmail(dot)com>

> AFAIK, that applies to parallel dumps of data (may help in --schema-only
> dumps too), and what you are trying is for schema.

Right, but one of the things it does is break the dump in to parts,
and put them in a directory/file organization.

Both are doing it for different reasons, but doing pretty much the
same thing.  But can the layout/organization of Joachim's patch can be
made "human friendly" in the vein of Joel's vision?

a.

-- 
Aidan Van Dyk                                             Create like a god,
aidan(at)highrise(dot)ca                                       command like a king,
http://www.highrise.ca/                                   work like a slave.

In response to

Responses

pgsql-hackers by date

Next:From: Magnus HaganderDate: 2010-12-29 14:40:34
Subject: Re: Streaming replication as a separate permissions
Previous:From: Gurjeet SinghDate: 2010-12-29 14:11:22
Subject: Re: pg_dump --split patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group