[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