postgres-xc-general

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

[Eric N. <eri...@af...>]

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

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
>

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

[Michael P. <mic...@gm...>]

Hi,

On top of that, what is the version you are using for your tests?
You have to know that ROLE queries are not fully supported in 0.9.4 because
Postgres-XC pooler is restricted to only one user in this version.
This restriction is not anymore in current HEAD code.
With 0.9.4 you can launch role queries, but it will not be possible to
launch queries if you connect with the new user name.

On Thu, May 19, 2011 at 7:48 PM, Abbas Butt <abb...@te...>wrote:

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

Well, each user can design a cluster as he wants depending on his use case.
The point is that XC should work whatever the configuration used, even if we
think it is not the one showing good performance.

Regards,
-- 
Michael Paquier
http://michael.otacoo.com