Re: [Postgres-xc-general] How to run a DUMP in Postgres XC ?

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

Thanks for giving it a try. Why do you need three coordinators? Each data
node does not need a coordinator. One can suffice 3 data nodes, unless you
need another for backup. I would suggest running the data node on the three
servers and GTM and coordinator on the 4rth server.
Now Each coordinator and data node needs to know IP address and port of the
GTM. It is specified in the postgresql.conf file in the data folder of each
node in the section GTM CONNECTION.
Next each data node needs to know IP address and port of the coordinator.
This is specified again in postgresql.conf file in the data folder of each
data node in the section COORDINATORS.
Next each coordinator need to know IPs and ports of all data nodes. Again
this is specified in DATA NODES section of the postgresql.conf file in the
data folder of the coordinator.
Once you get all the warnings out of the way then give dump a try it should
work.

Best Regards
Abbas


On Thu, May 19, 2011 at 3:16 PM, Eric Ndengang <
eri...@af...> wrote:

> Hi folks,
> I 've  installed a Postgres XC instance (4 servers) with one GTM and
> three coordinators/datanodes . Three servers get 1 coodinator +
> datanode  each and the gtm has it own server.
> I started the GTM, nodes and coordinatoors as well , but some Warning
> notifications in Datanode Logs  occurs --> WARNING:  Do not have a GTM
> snapshot available
> Regarding the Installationsdocs the global schema dump hast to be run on
> the coordinator. I've tried it and got the following ERRORS :
> LOG:  failed to connect to data node
> WARNING:  can not connect to data node 2
> LOG:  failed to acquire connections
> STATEMENT:  CREATE ROLE drodriguez;
> ERROR:  Failed to get pooled connections
> STATEMENT:  CREATE ROLE drodriguez;
> ERROR:  role "drodriguez" does not exist
> STATEMENT:  ALTER ROLE drodriguez WITH NOSUPERUSER INHERIT NOCREATEROLE
> NOCREATEDB LOGIN PASSWORD 'md59d4b27232eeec39777ee0b08ed8387a7';
> LOG:  failed to connect to data node
> WARNING:  can not connect to data node 2
>
> but I could run a schema dump on all the data nodes. is it sufficient ?
>
> That why I want to know how to run a schema dump in Postgres XC.
> any help would be really appreciated
>
>
>
> --
> Eric Ndengang
> Datenbankadministrator
>
> Affinitas GmbH  |  Kohlfurter Straße 41/43  |  10999 Berlin  |  Germany
> email: eri...@af...  | tel: +49.(0)30. 991 949 5 0  |
>  www.edarling.de
>
> Geschäftsführer: Lukas Brosseder, David Khalil, Kai Rieke, Christian
> Vollmann
> Eingetragen beim Amtsgericht Berlin, HRB 115958
>
> Real People:          www.edarling.de/echte-paare
> Real Love:            www.youtube.de/edarling
> Real Science:         www.edarling.org
>
>
>
> ------------------------------------------------------------------------------
> What Every C/C++ and Fortran developer Should Know!
> Read this article and learn how Intel has extended the reach of its
> next-generation tools to help Windows* and Linux* C/C++ and Fortran
> developers boost performance applications - including clusters.
> http://p.sf.net/sfu/intel-dev2devmay
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>