Thread: Re: [Postgres-xc-developers] Patch to add an option in pg_dump to dump nodes and node groups [Featu

Feature ID 3608376

On Sun, Mar 10, 2013 at 7:59 PM, Abbas Butt <abb...@en...>wrote:

> Hi,
> Attached please find a patch that adds support in pg_dump to dump nodes
> and node groups. This is required while adding a new node to the cluster.
>
> --
> 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.




-- 
--
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.

Hi,
Attached please find a revised patch that provides support in pg_dumpall to
dump nodes and node groups if the command line option --dump-nodes is
provided.

I tested and found that pg_dumpall works as expected.


On Wed, Mar 27, 2013 at 5:04 PM, Abbas Butt <abb...@en...>wrote:

> Feature ID 3608376
>
> On Sun, Mar 10, 2013 at 7:59 PM, Abbas Butt <abb...@en...>wrote:
>
>> Hi,
>> Attached please find a patch that adds support in pg_dump to dump nodes
>> and node groups. This is required while adding a new node to the cluster.
>>
>> --
>> 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.
>
>
>
>
> --
> --
> 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.




-- 
--
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.

Hi Abbas
I reviewed your changes, they look good. I have made some minor changes.
Please find them in attached patch.

I want to test this in a scenario on adding new node. Can you please point
me as to what steps I should follow? I don't want to lock the cluster, but
do this
1. Take the dump of existing coordinator using this patch
2. initdb a new coordinator
3. boot and use this dump to update the coordinator

Now with some magic this coordinator should be useful. Can you please
provide me with the steps to do this? I will run those thus testing your
patch.


On Sun, Mar 31, 2013 at 12:14 AM, Abbas Butt <abb...@en...>wrote:

> I just realized I had attached the wrong patch file with the previous
> mail, please ignore the previous attachment and use the one attached with
> this email for review.
>
>
> On Fri, Mar 29, 2013 at 5:33 PM, Abbas Butt <abb...@en...>wrote:
>
>> Hi,
>> Attached please find a revised patch that provides support in pg_dumpall
>> to dump nodes and node groups if the command line option --dump-nodes is
>> provided.
>>
>> I tested and found that pg_dumpall works as expected.
>>
>>
>> On Wed, Mar 27, 2013 at 5:04 PM, Abbas Butt <abb...@en...>wrote:
>>
>>> Feature ID 3608376
>>>
>>> On Sun, Mar 10, 2013 at 7:59 PM, Abbas Butt <abb...@en...
>>> > wrote:
>>>
>>>> Hi,
>>>> Attached please find a patch that adds support in pg_dump to dump nodes
>>>> and node groups. This is required while adding a new node to the cluster.
>>>>
>>>> --
>>>> 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.
>>>
>>>
>>>
>>>
>>> --
>>> --
>>> 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.
>>
>>
>>
>>
>> --
>> --
>> 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.
>>
>
>
>
> --
> --
> 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.
>
>
> ------------------------------------------------------------------------------
> Own the Future-Intel(R) Level Up Game Demo Contest 2013
> Rise to greatness in Intel's independent game demo contest. Compete
> for recognition, cash, and the chance to get your game on Steam.
> $5K grand prize plus 10 genre and skill prizes. Submit your demo
> by 6/6/13. http://altfarm.mediaplex.com/ad/ck/12124-176961-30367-2
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>


-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Enterprise Postgres Company

And BTW, we need corresponding document changes for this one.


On Fri, Apr 5, 2013 at 5:48 PM, Ashutosh Bapat <
ash...@en...> wrote:

> Sorry, here's the updated patch.
>
>
> On Fri, Apr 5, 2013 at 5:46 PM, Ashutosh Bapat <
> ash...@en...> wrote:
>
>> Hi Abbas
>> I reviewed your changes, they look good. I have made some minor changes.
>> Please find them in attached patch.
>>
>> I want to test this in a scenario on adding new node. Can you please
>> point me as to what steps I should follow? I don't want to lock the
>> cluster, but do this
>> 1. Take the dump of existing coordinator using this patch
>> 2. initdb a new coordinator
>> 3. boot and use this dump to update the coordinator
>>
>> Now with some magic this coordinator should be useful. Can you please
>> provide me with the steps to do this? I will run those thus testing your
>> patch.
>>
>>
>> On Sun, Mar 31, 2013 at 12:14 AM, Abbas Butt <abb...@en...
>> > wrote:
>>
>>> I just realized I had attached the wrong patch file with the previous
>>> mail, please ignore the previous attachment and use the one attached with
>>> this email for review.
>>>
>>>
>>> On Fri, Mar 29, 2013 at 5:33 PM, Abbas Butt <abb...@en...
>>> > wrote:
>>>
>>>> Hi,
>>>> Attached please find a revised patch that provides support in
>>>> pg_dumpall to dump nodes and node groups if the command line option
>>>> --dump-nodes is provided.
>>>>
>>>> I tested and found that pg_dumpall works as expected.
>>>>
>>>>
>>>> On Wed, Mar 27, 2013 at 5:04 PM, Abbas Butt <
>>>> abb...@en...> wrote:
>>>>
>>>>> Feature ID 3608376
>>>>>
>>>>> On Sun, Mar 10, 2013 at 7:59 PM, Abbas Butt <
>>>>> abb...@en...> wrote:
>>>>>
>>>>>> Hi,
>>>>>> Attached please find a patch that adds support in pg_dump to dump
>>>>>> nodes and node groups. This is required while adding a new node to the
>>>>>> cluster.
>>>>>>
>>>>>> --
>>>>>> 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.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> --
>>>>> 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.
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> --
>>>> 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.
>>>>
>>>
>>>
>>>
>>> --
>>> --
>>> 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.
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Own the Future-Intel(R) Level Up Game Demo Contest 2013
>>> Rise to greatness in Intel's independent game demo contest. Compete
>>> for recognition, cash, and the chance to get your game on Steam.
>>> $5K grand prize plus 10 genre and skill prizes. Submit your demo
>>> by 6/6/13. http://altfarm.mediaplex.com/ad/ck/12124-176961-30367-2
>>> _______________________________________________
>>> Postgres-xc-developers mailing list
>>> Pos...@li...
>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>>>
>>>
>>
>>
>> --
>> Best Wishes,
>> Ashutosh Bapat
>> EntepriseDB Corporation
>> The Enterprise Postgres Company
>>
>
>
>
> --
> Best Wishes,
> Ashutosh Bapat
> EntepriseDB Corporation
> The Enterprise Postgres Company
>



-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Enterprise Postgres Company

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN""http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>Adding a New Coordinator</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REV="MADE"
HREF="mailto:pgs...@po..."><LINK
REL="HOME"
TITLE="Postgres-XC 1.1devel Documentation"
HREF="index.html"><LINK
REL="UP"
TITLE="Adding a New Node"
HREF="add-node.html"><LINK
REL="PREVIOUS"
TITLE="Adding a New Node"
HREF="add-node.html"><LINK
REL="NEXT"
TITLE="Adding a New Datanode"
HREF="add-node-datanode.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
HTTP-EQUIV="Content-Type"
CONTENT="text/html; charset=ISO-8859-1"><META
NAME="creation"
CONTENT="2013-04-05T18:44:20"></HEAD
><BODY
CLASS="SECT1"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="5"
ALIGN="center"
VALIGN="bottom"
><A
HREF="index.html"
>Postgres-XC 1.1devel Documentation</A
></TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
TITLE="Adding a New Node"
HREF="add-node.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
TITLE="Adding a New Node"
HREF="add-node.html"
>Fast Backward</A
></TD
><TD
WIDTH="60%"
ALIGN="center"
VALIGN="bottom"
>Chapter 30. Adding a New Node</TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="top"
><A
TITLE="Adding a New Node"
HREF="add-node.html"
>Fast Forward</A
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="top"
><A
TITLE="Adding a New Datanode"
HREF="add-node-datanode.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="ADD-NODE-COORDINATOR"
>30.1. Adding a New Coordinator</A
></H1
><P
>    Following steps should be performed to add a new coordinator to a running cluster:
  </P
><P
>    <P
></P
></P><OL
TYPE="1"
><LI
><P
>Initialize the new coordinator. The following example initilizes a coordinator named coord_3.</P
><PRE
CLASS="PROGRAMLISTING"
>          /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data_cord3 --nodename coord_3
        </PRE
></LI
><LI
><P
>          Make necessary changes in postgresql.conf of the new coordinator,
          in particular specify new coordinator name and pooler port.
        </P
></LI
><LI
><P
>          Connect to any of the existing coordinators and lock the cluster for backup, do not close this session.
          The following example assumes a coordinator is running on port 5432. Make sure the function call returns true.
          The detailed description of the function <CODE
CLASS="FUNCTION"
>pgxc_lock_for_backup</CODE
> can be found 
          in <A
HREF="functions-admin.html#FUNCTIONS-PGXC-ADD-NEW-NODE"
>Table 9-64</A
>
        </P
><PRE
CLASS="PROGRAMLISTING"
>          ./psql postgres -p 5432
          select pgxc_lock_for_backup();
        </PRE
></LI
><LI
><P
>          Connect to any of the existing coordinators and take backup of the database.
          Please note that only schema (i.e. no data) is to be dumped.
          Also note the use of <TT
CLASS="OPTION"
>--include-nodes</TT
>, so that the <TT
CLASS="COMMAND"
>CREATE TABLE</TT
> contains <TT
CLASS="COMMAND"
>TO NODE</TT
> clause.
          Similarly <TT
CLASS="OPTION"
>--dump-nodes</TT
> ensures that the dump does contain existing nodes and node groups.
        </P
><PRE
CLASS="PROGRAMLISTING"
>          ./pg_dumpall -p 5432 -s --include-nodes --dump-nodes --file=/some/valid/path/some_file_name.sql
        </PRE
></LI
><LI
><P
>          Start the new coordinator specifying <TT
CLASS="OPTION"
>--restoremode</TT
> while starting.
          The following example starts the new coordinator on port 5455
        </P
><PRE
CLASS="PROGRAMLISTING"
>          ./postgres --restoremode -D ../data_cord3 -p 5455
        </PRE
></LI
><LI
><P
>          Restore the backup (taken in step 4) by connecting to the new coordinator directly.
        </P
><PRE
CLASS="PROGRAMLISTING"
>          ./psql -d postgres -f /some/valid/path/some_file_name.sql -p 5455
        </PRE
></LI
><LI
><P
>          Quit the new coordinator.
        </P
></LI
><LI
><P
>          Start the new coordinator specifying <TT
CLASS="OPTION"
>--coordinator</TT
> while starting.
          The following example starts the new coordinator on port 5455
        </P
><PRE
CLASS="PROGRAMLISTING"
>          ./postgres --coordinator -D ../data_cord3 -p 5455
        </PRE
></LI
><LI
><P
>          Create the new coordinator on rest of the coordinators and reload configuration.
          The following example creates coord_3, with host localhost and port 5455.
        </P
><PRE
CLASS="PROGRAMLISTING"
>          CREATE NODE COORD_3 WITH (HOST = 'localhost', type = 'coordinator', PORT = 5455);
          SELECT pgxc_pool_reload();
        </PRE
></LI
><LI
><P
>          Quit the session of step 3, this will unlock the cluster. The new coordinator is now ready.
        </P
></LI
></OL
><P>
  </P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="add-node.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="add-node-datanode.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Adding a New Node</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="add-node.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Adding a New Datanode</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>

Hi Abbas,
I tried to follow the steps you have written for adding new node by
applying the relevant patches. I restored the dump in new coordinator. But
when I tried to reboot it with --coordinator, it tried to start a pooler
process and exited because it couldn't start the pooler process. I have
tried all the variations possible, but no success.

Do you know what's happening here?
[ashutosh@ubuntu coderoot]$BuildDir/bin/postgres --coordinator -D
/tmp/data/coord2/ -p 10010
FATAL:  lock file "/tmp/.s.PGPOOL.6667.lock" already exists
HINT:  Is another postmaster (PID 13354) using socket file
"/tmp/.s.PGPOOL.6667"?
LOG:  pool manager process (PID 20170) exited with exit code 1
LOG:  terminating any other active server processes
LOG:  startup process (PID 20169) exited with exit code 2
LOG:  aborting startup due to startup process failure



On Sat, Apr 6, 2013 at 12:22 AM, Abbas Butt <abb...@en...>wrote:

> Attached please find an updated patch that includes the documentation
> changes as you suggested.
> I have also attached an html file that would eventually become a new
> chapter in Server Administration section of the documentation. This html
> lists the steps to be performed to add a new coordinator.
>
>
> On Fri, Apr 5, 2013 at 5:23 PM, Ashutosh Bapat <
> ash...@en...> wrote:
>
>> And BTW, we need corresponding document changes for this one.
>>
>>
>> On Fri, Apr 5, 2013 at 5:48 PM, Ashutosh Bapat <
>> ash...@en...> wrote:
>>
>>> Sorry, here's the updated patch.
>>>
>>>
>>> On Fri, Apr 5, 2013 at 5:46 PM, Ashutosh Bapat <
>>> ash...@en...> wrote:
>>>
>>>> Hi Abbas
>>>> I reviewed your changes, they look good. I have made some minor
>>>> changes. Please find them in attached patch.
>>>>
>>>> I want to test this in a scenario on adding new node. Can you please
>>>> point me as to what steps I should follow? I don't want to lock the
>>>> cluster, but do this
>>>> 1. Take the dump of existing coordinator using this patch
>>>> 2. initdb a new coordinator
>>>> 3. boot and use this dump to update the coordinator
>>>>
>>>> Now with some magic this coordinator should be useful. Can you please
>>>> provide me with the steps to do this? I will run those thus testing your
>>>> patch.
>>>>
>>>>
>>>> On Sun, Mar 31, 2013 at 12:14 AM, Abbas Butt <
>>>> abb...@en...> wrote:
>>>>
>>>>> I just realized I had attached the wrong patch file with the previous
>>>>> mail, please ignore the previous attachment and use the one attached with
>>>>> this email for review.
>>>>>
>>>>>
>>>>> On Fri, Mar 29, 2013 at 5:33 PM, Abbas Butt <
>>>>> abb...@en...> wrote:
>>>>>
>>>>>> Hi,
>>>>>> Attached please find a revised patch that provides support in
>>>>>> pg_dumpall to dump nodes and node groups if the command line option
>>>>>> --dump-nodes is provided.
>>>>>>
>>>>>> I tested and found that pg_dumpall works as expected.
>>>>>>
>>>>>>
>>>>>> On Wed, Mar 27, 2013 at 5:04 PM, Abbas Butt <
>>>>>> abb...@en...> wrote:
>>>>>>
>>>>>>> Feature ID 3608376
>>>>>>>
>>>>>>> On Sun, Mar 10, 2013 at 7:59 PM, Abbas Butt <
>>>>>>> abb...@en...> wrote:
>>>>>>>
>>>>>>>> Hi,
>>>>>>>> Attached please find a patch that adds support in pg_dump to dump
>>>>>>>> nodes and node groups. This is required while adding a new node to the
>>>>>>>> cluster.
>>>>>>>>
>>>>>>>> --
>>>>>>>> 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.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> --
>>>>>>> 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.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> --
>>>>>> 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.
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> --
>>>>> 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.
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------------
>>>>> Own the Future-Intel(R) Level Up Game Demo Contest 2013
>>>>> Rise to greatness in Intel's independent game demo contest. Compete
>>>>> for recognition, cash, and the chance to get your game on Steam.
>>>>> $5K grand prize plus 10 genre and skill prizes. Submit your demo
>>>>> by 6/6/13. http://altfarm.mediaplex.com/ad/ck/12124-176961-30367-2
>>>>> _______________________________________________
>>>>> Postgres-xc-developers mailing list
>>>>> Pos...@li...
>>>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Best Wishes,
>>>> Ashutosh Bapat
>>>> EntepriseDB Corporation
>>>> The Enterprise Postgres Company
>>>>
>>>
>>>
>>>
>>> --
>>> Best Wishes,
>>> Ashutosh Bapat
>>> EntepriseDB Corporation
>>> The Enterprise Postgres Company
>>>
>>
>>
>>
>> --
>> Best Wishes,
>> Ashutosh Bapat
>> EntepriseDB Corporation
>> The Enterprise Postgres Company
>>
>
>
>
> --
> --
> 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.
>



-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Enterprise Postgres Company

On Tue, Apr 9, 2013 at 5:46 PM, Ashutosh Bapat <
ash...@en...> wrote:

> Hi Abbas,
> I reviewed both the patches --include-node and --dump-node and tested in
> the context of coordinator addition. While adding the coordinator, I found
> that the newly added coordinator tries to bool its own pooler and needs a
> separate pooler port to be specified. In the current code, I always specify
> the same pooler port for all the coordinator (even if run on the same
> machine). This looks to be a problem.
>

Coordinator and pooler use unix domain sockets to communicate with each
other and since unix domain sockets work only locally, sharing pooler
between coordinators running on different machines is out of question.
Let us restrict our discussion to coordinators running on the same machine
and trying to share pooler. Pooler is started by PostmasterMain using  this
code

    if (IS_PGXC_COORDINATOR)
    {
        oldcontext = MemoryContextSwitchTo(TopMemoryContext);

        /*
         * Initialize the Data Node connection pool
         */
        PgPoolerPID = StartPoolManager();

        MemoryContextSwitchTo(oldcontext);
    }

StartPoolManager forks the pooler process and the pooler process issues
bind in pool_listen.
I don't see any code to facilitate coordinators running on same machine
sharing a pooler.

Can you please elaborate on how do you start the coordinators when they
share the same pooler?


In the documentation, you have use &xconly for one option and a line "This
> option is available in <productname>Postgres-XC</> only", for the second.
> Which one is correct.
>

&xconly is correct. I have used it in both the cases.


> Please use same thing in both the cases. Rest of the changes look fine. In
> the attached patch, I have improved the wording in documentation slightly.
> Please use that wording in the documentation.
>

I have noted the change, I will include it in the revised patch to commit.


>
>
> On Sat, Apr 6, 2013 at 12:22 AM, Abbas Butt <abb...@en...>wrote:
>
>> Attached please find an updated patch that includes the documentation
>> changes as you suggested.
>> I have also attached an html file that would eventually become a new
>> chapter in Server Administration section of the documentation. This html
>> lists the steps to be performed to add a new coordinator.
>>
>>
>> On Fri, Apr 5, 2013 at 5:23 PM, Ashutosh Bapat <
>> ash...@en...> wrote:
>>
>>> And BTW, we need corresponding document changes for this one.
>>>
>>>
>>> On Fri, Apr 5, 2013 at 5:48 PM, Ashutosh Bapat <
>>> ash...@en...> wrote:
>>>
>>>> Sorry, here's the updated patch.
>>>>
>>>>
>>>> On Fri, Apr 5, 2013 at 5:46 PM, Ashutosh Bapat <
>>>> ash...@en...> wrote:
>>>>
>>>>> Hi Abbas
>>>>> I reviewed your changes, they look good. I have made some minor
>>>>> changes. Please find them in attached patch.
>>>>>
>>>>> I want to test this in a scenario on adding new node. Can you please
>>>>> point me as to what steps I should follow? I don't want to lock the
>>>>> cluster, but do this
>>>>> 1. Take the dump of existing coordinator using this patch
>>>>> 2. initdb a new coordinator
>>>>> 3. boot and use this dump to update the coordinator
>>>>>
>>>>> Now with some magic this coordinator should be useful. Can you please
>>>>> provide me with the steps to do this? I will run those thus testing your
>>>>> patch.
>>>>>
>>>>>
>>>>> On Sun, Mar 31, 2013 at 12:14 AM, Abbas Butt <
>>>>> abb...@en...> wrote:
>>>>>
>>>>>> I just realized I had attached the wrong patch file with the previous
>>>>>> mail, please ignore the previous attachment and use the one attached with
>>>>>> this email for review.
>>>>>>
>>>>>>
>>>>>> On Fri, Mar 29, 2013 at 5:33 PM, Abbas Butt <
>>>>>> abb...@en...> wrote:
>>>>>>
>>>>>>> Hi,
>>>>>>> Attached please find a revised patch that provides support in
>>>>>>> pg_dumpall to dump nodes and node groups if the command line option
>>>>>>> --dump-nodes is provided.
>>>>>>>
>>>>>>> I tested and found that pg_dumpall works as expected.
>>>>>>>
>>>>>>>
>>>>>>> On Wed, Mar 27, 2013 at 5:04 PM, Abbas Butt <
>>>>>>> abb...@en...> wrote:
>>>>>>>
>>>>>>>> Feature ID 3608376
>>>>>>>>
>>>>>>>> On Sun, Mar 10, 2013 at 7:59 PM, Abbas Butt <
>>>>>>>> abb...@en...> wrote:
>>>>>>>>
>>>>>>>>> Hi,
>>>>>>>>> Attached please find a patch that adds support in pg_dump to dump
>>>>>>>>> nodes and node groups. This is required while adding a new node to the
>>>>>>>>> cluster.
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> 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.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> --
>>>>>>>> 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.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> --
>>>>>>> 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.
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> --
>>>>>> 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.
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------------------
>>>>>> Own the Future-Intel(R) Level Up Game Demo Contest 2013
>>>>>> Rise to greatness in Intel's independent game demo contest. Compete
>>>>>> for recognition, cash, and the chance to get your game on Steam.
>>>>>> $5K grand prize plus 10 genre and skill prizes. Submit your demo
>>>>>> by 6/6/13. http://altfarm.mediaplex.com/ad/ck/12124-176961-30367-2
>>>>>> _______________________________________________
>>>>>> Postgres-xc-developers mailing list
>>>>>> Pos...@li...
>>>>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Best Wishes,
>>>>> Ashutosh Bapat
>>>>> EntepriseDB Corporation
>>>>> The Enterprise Postgres Company
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Best Wishes,
>>>> Ashutosh Bapat
>>>> EntepriseDB Corporation
>>>> The Enterprise Postgres Company
>>>>
>>>
>>>
>>>
>>> --
>>> Best Wishes,
>>> Ashutosh Bapat
>>> EntepriseDB Corporation
>>> The Enterprise Postgres Company
>>>
>>
>>
>>
>> --
>> --
>> 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.
>>
>
>
>
> --
> Best Wishes,
> Ashutosh Bapat
> EntepriseDB Corporation
> The Enterprise Postgres Company
>



-- 
--
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.

Hi Abbas,
It seems I am wrong. We need separate pooler for each coordinator.


On Tue, Apr 9, 2013 at 7:26 PM, Abbas Butt <abb...@en...>wrote:

>
>
> On Tue, Apr 9, 2013 at 5:46 PM, Ashutosh Bapat <
> ash...@en...> wrote:
>
>> Hi Abbas,
>> I reviewed both the patches --include-node and --dump-node and tested in
>> the context of coordinator addition. While adding the coordinator, I found
>> that the newly added coordinator tries to bool its own pooler and needs a
>> separate pooler port to be specified. In the current code, I always specify
>> the same pooler port for all the coordinator (even if run on the same
>> machine). This looks to be a problem.
>>
>
> Coordinator and pooler use unix domain sockets to communicate with each
> other and since unix domain sockets work only locally, sharing pooler
> between coordinators running on different machines is out of question.
> Let us restrict our discussion to coordinators running on the same machine
> and trying to share pooler. Pooler is started by PostmasterMain using  this
> code
>
>     if (IS_PGXC_COORDINATOR)
>     {
>         oldcontext = MemoryContextSwitchTo(TopMemoryContext);
>
>         /*
>          * Initialize the Data Node connection pool
>          */
>         PgPoolerPID = StartPoolManager();
>
>         MemoryContextSwitchTo(oldcontext);
>     }
>
> StartPoolManager forks the pooler process and the pooler process issues
> bind in pool_listen.
> I don't see any code to facilitate coordinators running on same machine
> sharing a pooler.
>
> Can you please elaborate on how do you start the coordinators when they
> share the same pooler?
>
>
> In the documentation, you have use &xconly for one option and a line "This
>> option is available in <productname>Postgres-XC</> only", for the second.
>> Which one is correct.
>>
>
> &xconly is correct. I have used it in both the cases.
>
>
>> Please use same thing in both the cases. Rest of the changes look fine.
>> In the attached patch, I have improved the wording in documentation
>> slightly. Please use that wording in the documentation.
>>
>
> I have noted the change, I will include it in the revised patch to commit.
>
>
>>
>>
>> On Sat, Apr 6, 2013 at 12:22 AM, Abbas Butt <abb...@en...>wrote:
>>
>>> Attached please find an updated patch that includes the documentation
>>> changes as you suggested.
>>> I have also attached an html file that would eventually become a new
>>> chapter in Server Administration section of the documentation. This html
>>> lists the steps to be performed to add a new coordinator.
>>>
>>>
>>> On Fri, Apr 5, 2013 at 5:23 PM, Ashutosh Bapat <
>>> ash...@en...> wrote:
>>>
>>>> And BTW, we need corresponding document changes for this one.
>>>>
>>>>
>>>> On Fri, Apr 5, 2013 at 5:48 PM, Ashutosh Bapat <
>>>> ash...@en...> wrote:
>>>>
>>>>> Sorry, here's the updated patch.
>>>>>
>>>>>
>>>>> On Fri, Apr 5, 2013 at 5:46 PM, Ashutosh Bapat <
>>>>> ash...@en...> wrote:
>>>>>
>>>>>> Hi Abbas
>>>>>> I reviewed your changes, they look good. I have made some minor
>>>>>> changes. Please find them in attached patch.
>>>>>>
>>>>>> I want to test this in a scenario on adding new node. Can you please
>>>>>> point me as to what steps I should follow? I don't want to lock the
>>>>>> cluster, but do this
>>>>>> 1. Take the dump of existing coordinator using this patch
>>>>>> 2. initdb a new coordinator
>>>>>> 3. boot and use this dump to update the coordinator
>>>>>>
>>>>>> Now with some magic this coordinator should be useful. Can you please
>>>>>> provide me with the steps to do this? I will run those thus testing your
>>>>>> patch.
>>>>>>
>>>>>>
>>>>>> On Sun, Mar 31, 2013 at 12:14 AM, Abbas Butt <
>>>>>> abb...@en...> wrote:
>>>>>>
>>>>>>> I just realized I had attached the wrong patch file with the
>>>>>>> previous mail, please ignore the previous attachment and use the one
>>>>>>> attached with this email for review.
>>>>>>>
>>>>>>>
>>>>>>> On Fri, Mar 29, 2013 at 5:33 PM, Abbas Butt <
>>>>>>> abb...@en...> wrote:
>>>>>>>
>>>>>>>> Hi,
>>>>>>>> Attached please find a revised patch that provides support in
>>>>>>>> pg_dumpall to dump nodes and node groups if the command line option
>>>>>>>> --dump-nodes is provided.
>>>>>>>>
>>>>>>>> I tested and found that pg_dumpall works as expected.
>>>>>>>>
>>>>>>>>
>>>>>>>> On Wed, Mar 27, 2013 at 5:04 PM, Abbas Butt <
>>>>>>>> abb...@en...> wrote:
>>>>>>>>
>>>>>>>>> Feature ID 3608376
>>>>>>>>>
>>>>>>>>> On Sun, Mar 10, 2013 at 7:59 PM, Abbas Butt <
>>>>>>>>> abb...@en...> wrote:
>>>>>>>>>
>>>>>>>>>> Hi,
>>>>>>>>>> Attached please find a patch that adds support in pg_dump to dump
>>>>>>>>>> nodes and node groups. This is required while adding a new node to the
>>>>>>>>>> cluster.
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> 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.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> --
>>>>>>>>> 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.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> --
>>>>>>>> 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.
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> --
>>>>>>> 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.
>>>>>>>
>>>>>>>
>>>>>>> ------------------------------------------------------------------------------
>>>>>>> Own the Future-Intel(R) Level Up Game Demo Contest 2013
>>>>>>> Rise to greatness in Intel's independent game demo contest. Compete
>>>>>>> for recognition, cash, and the chance to get your game on Steam.
>>>>>>> $5K grand prize plus 10 genre and skill prizes. Submit your demo
>>>>>>> by 6/6/13. http://altfarm.mediaplex.com/ad/ck/12124-176961-30367-2
>>>>>>> _______________________________________________
>>>>>>> Postgres-xc-developers mailing list
>>>>>>> Pos...@li...
>>>>>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Best Wishes,
>>>>>> Ashutosh Bapat
>>>>>> EntepriseDB Corporation
>>>>>> The Enterprise Postgres Company
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Best Wishes,
>>>>> Ashutosh Bapat
>>>>> EntepriseDB Corporation
>>>>> The Enterprise Postgres Company
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Best Wishes,
>>>> Ashutosh Bapat
>>>> EntepriseDB Corporation
>>>> The Enterprise Postgres Company
>>>>
>>>
>>>
>>>
>>> --
>>> --
>>> 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.
>>>
>>
>>
>>
>> --
>> Best Wishes,
>> Ashutosh Bapat
>> EntepriseDB Corporation
>> The Enterprise Postgres Company
>>
>
>
>
> --
> --
> 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.
>



-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Enterprise Postgres Company