Re: [Postgres-xc-general] pgxc_ctl init command problem

[Nikhil S. <ni...@st...>]

Hi Hector,

Very interesting to see that you are trying different clustering solutions.

Would like to see your impressions and summary after you are done with all
your configurations. Especially your thoughts on ease of use, architecture
and performance of pgxc visavis the other products.

Getting back to pgxc_ctl, the link that you have mentioned is good enough
to get going.

The most important step is to come up with a proper configuration in the
pgxc_ctl.conf file. Once you have that in place, doing an:

init all

should get the cluster going.

You can do a:

monitor all

to see the status of all the components as well

stop all,
start all

etc, do things as expected.

HTH,
Nikhils
StormDB



On Thu, Sep 26, 2013 at 8:59 PM, Hector M. Jacas <hec...@et...>wrote:

> Dear Nikhils,
>
> Thank you very much for your quick response.
>
> Problem solved.
>
> Where could find guides or tutorials on pgxc_ctl?
>
> https://sourceforge.net/apps/**mediawiki/postgres-xc/index.**
> php?title=Pgxc_ctl_tutorial<https://sourceforge.net/apps/mediawiki/postgres-xc/index.php?title=Pgxc_ctl_tutorial>tutorial page is under construction.
>
> http://postgres-xc.**sourceforge.net/docs/1_1/pgxc-**ctl.html<http://postgres-xc.sourceforge.net/docs/1_1/pgxc-ctl.html>is just a manual. Explains the meanings of the parameters but says nothing
> about procedures, the order in which tasks should be performed, etc.
>
> My project is to create clusters with different database backends used by
> our applications in the enterprise.
>
> Could you tell me any site or page that contains guides, tutorials or
> procedures to follow?
>
> So far, I have already a solution for MySQL with Percona cluster (3
> nodes). This solution is already in production.
>
> Oracle RAC (2 nodes) is almost ready. Next (now) is postgresql and mongoDB
> at last.
>
> During the months of July and August install the 1.1beta version (3 nodes
> coordinator/gtm_proxy/datanode and one gtm). I really liked the solution
> (from all revised this is the most complete solution) and its performance.
> For installation and deployment I follow the documents on StormDB site.
> Everything was Ok.
>
> Now, the official 1.1 version is out and is my intention to explore the
> deployment and management of a cluster postgres-xc with similar
> characteristics through pgxc_ctl tool.
>
> Again, thank you very much for your reply
>
> Hector M. Jacas
>
> ---
> This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE
> running at host imx3.etecsa.cu
> Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>
>
>


-- 
StormDB - http://www.stormdb.com
The Database Cloud