postgres-xc-general

[Postgres-xc-general] info

[Cristian <pub...@gm...>]

Hi i installed and configured postgres-xc in a cluster with 3 servers as
follows:

1) server s1: coordinator , 1 gmt-proxy , 1 datanode
2) server s2: coordinator , 1 gmt-proxy , 1 datanode
3) gmt

All is working until i simulate a crash for a server.
When i add again the coordinator .... gmt gives many errors and all seams
very slow.

I made many attempts, it seams that if a server crashs , i need to remove
node from cluster manually else give problems, but now give a bit of
confusion.. too many strange behaviours.

Maybe i m wrong in some procedure, so i want ask the correct procedure in
the case a datanode or coordinator or gmtproxy crash (or all of them).

Re: [Postgres-xc-general] info

[Koichi S. <koi...@gm...>]

What steps did you take to crash and add servers?   I need to know
what you've done.   If you've done server addition manually, it is not
simple and you have to follow many steps.

pgxc_ctl provides simpler way for this.  It is a contrib module and
the documentation will be found at
http://postgres-xc.sourceforge.net/docs/1_1/pgxc-ctl.html

Source code of pgxc_ctl may also be helpful to know what steps you
should follow if you do it manually.

Regards;
---
Koichi Suzuki


2014-02-01 Cristian <pub...@gm...>:
> Hi i installed and configured postgres-xc in a cluster with 3 servers as
> follows:
>
> 1) server s1: coordinator , 1 gmt-proxy , 1 datanode
> 2) server s2: coordinator , 1 gmt-proxy , 1 datanode
> 3) gmt
>
> All is working until i simulate a crash for a server.
> When i add again the coordinator .... gmt gives many errors and all seams
> very slow.
>
> I made many attempts, it seams that if a server crashs , i need to remove
> node from cluster manually else give problems, but now give a bit of
> confusion.. too many strange behaviours.
>
> Maybe i m wrong in some procedure, so i want ask the correct procedure in
> the case a datanode or coordinator or gmtproxy crash (or all of them).
>
>
>
> ------------------------------------------------------------------------------
> WatchGuard Dimension instantly turns raw network data into actionable
> security intelligence. It gives you real-time visual feedback on key
> security issues and trends.  Skip the complicated setup - simply import
> a virtual appliance and go from zero to informed in seconds.
> http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>