Re: [Postgres-xc-developers] Patch to fix pg_dump to generate TO NODE clause in the dump

[Abbas B. <abb...@en...>]

On Sun, Feb 24, 2013 at 5:33 PM, Michael Paquier
<mic...@gm...>wrote:

>
>
> On Sun, Feb 24, 2013 at 7:04 PM, Abbas Butt <abb...@en...>wrote:
>
>>
>>
>> On Sun, Feb 24, 2013 at 1:44 PM, Michael Paquier <
>> mic...@gm...> wrote:
>>
>>>
>>>
>>> On Sun, Feb 24, 2013 at 3:51 PM, Abbas Butt <abb...@en...
>>> > wrote:
>>>
>>>> Hi,
>>>> PFA a patch to  fix pg_dump to generate TO NODE clause in the dump.
>>>> This is required because otherwise all tables get created on all nodes
>>>> after a dump-restore cycle.
>>>>
>>> Not sure this is good if you take a dump of an XC cluster to restore
>>> that to a vanilla Postgres cluster.
>>> Why not adding a new option that would control the generation of this
>>> clause instead of forcing it?
>>>
>>
>> I think you can use the pg_dump that comes with vanilla PG to do that,
>> can't you? But I am open to adding a control option if every body thinks so.
>>
> Sure you can, this is just to simplify the life of users a maximum by not
> having multiple pg_dump binaries in their serves.
> Saying that, I think that there is no option to choose if DISTRIBUTE BY is
> printed in the dump or not...
>

Yah if we choose to have an option we will put both DISTRIBUTE BY and TO
NODE under it.


> --
> Michael
>



-- 
--
Abbas
Architect
EnterpriseDB Corporation
The Enterprise PostgreSQL Company

Phone: 92-334-5100153

Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com/
Follow us on Twitter: http://www.twitter.com/enterprisedb

This e-mail message (and any attachment) is intended for the use of
the individual or entity to whom it is addressed. This message
contains information from EnterpriseDB Corporation that may be
privileged, confidential, or exempt from disclosure under applicable
law. If you are not the intended recipient or authorized to receive
this for the intended recipient, any use, dissemination, distribution,
retention, archiving, or copying of this communication is strictly
prohibited. If you have received this e-mail in error, please notify
the sender immediately by reply e-mail and delete this message.