[Postgres-xl-developers] PostgreSQL Cluster solution. PostgreSQL - XL Technology

Sarkhan Allahverdiyev sarkhan.allahverdiyev at outlook.com
Wed Dec 14 05:38:09 PST 2016


Hello Ricard,


Very thank for the links very useful for me. I have troubleshooting please pay attention.

When i run "remove gtm master gtm" i'm getting following error"Segmentation fault (core dumped)"

What does this mean? also when i adding gtm master too getting such error.


[postgres at gtm ~]$ pgxc_ctl
/bin/bash
Installing pgxc_ctl_bash script as /home/postgres/pgxc_ctl/pgxc_ctl_bash.
Installing pgxc_ctl_bash script as /home/postgres/pgxc_ctl/pgxc_ctl_bash.
Reading configuration using /home/postgres/pgxc_ctl/pgxc_ctl_bash --home /home/postgres/pgxc_ctl --configuration /home/postgres/pgxc_ctl/pgxc_ctl.conf
Finished reading configuration.
   ******** PGXC_CTL START ***************

Current directory: /home/postgres/pgxc_ctl
PGXC add gtm master gtm localhost 20001 "$HOME/pgxc/nodes/gtm"
Segmentation fault (core dumped)
[postgres at gtm ~]$ pgxc_ctl
/bin/bash
Installing pgxc_ctl_bash script as /home/postgres/pgxc_ctl/pgxc_ctl_bash.
Installing pgxc_ctl_bash script as /home/postgres/pgxc_ctl/pgxc_ctl_bash.
Reading configuration using /home/postgres/pgxc_ctl/pgxc_ctl_bash --home /home/postgres/pgxc_ctl --configuration /home/postgres/pgxc_ctl/pgxc_ctl.conf
Finished reading configuration.
   ******** PGXC_CTL START ***************

Current directory: /home/postgres/pgxc_ctl
PGXC add gtm master gtm localhost 20001 $HOME/pgxc/nodes/gtm
ERROR: New specified name:gtm, host:localhost, port:20001 and dir:"$HOME/pgxc/nodes/gtm" conflicts with existing node.
PGXC
PGXC
PGXC
PGXC
PGXC show gtm master gtm
ERROR: Cannot show gtm now, sorry.
PGXC


Best Regards

Sarkhan Allahverdiyev
Database Administrator
Phone: +994 55 7717727




________________________________
From: Silva, Richard <rsilva at javelin.mg>
Sent: Wednesday, November 30, 2016 6:50 PM
To: Sarkhan Allahverdiyev; postgres-xl-developers at lists.sourceforge.net
Subject: Re: [Postgres-xl-developers] PostgreSQL Cluster solution. PostgreSQL - XL Technology

Sarkhan,

You might find this helpful...

https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling
Replication, Clustering, and Connection Pooling ...<https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling>
wiki.postgresql.org
Program License Maturity Replication Method Sync Connection Pooling Load Balancing Query Partitioning PgCluster: BSD Not production ready Master-Master


good luck...
R!chard Silva  ETL Architect
www.javelin.mg

From: Sarkhan Allahverdiyev <sarkhan.allahverdiyev at outlook.com<mailto:sarkhan.allahverdiyev at outlook.com>>
Date: Wednesday, November 30, 2016 at 8:28 AM
To: Silva Richard <rsilva at javelin.mg<mailto:rsilva at javelin.mg>>, "postgres-xl-developers at lists.sourceforge.net<mailto:postgres-xl-developers at lists.sourceforge.net>" <postgres-xl-developers at lists.sourceforge.net<mailto:postgres-xl-developers at lists.sourceforge.net>>
Subject: Re: [Postgres-xl-developers] PostgreSQL Cluster solution. PostgreSQL - XL Technology


Hi,


Thanks for the links. So what do you offer Postgress Cluster? Is there any solution in PostgreSQL with Cluster technology(HA and Load Balancing)?

Best Regards

Sarkhan Allahverdiyev
Database Administrator
Phone: +994 55 7717727




________________________________
From: Silva, Richard <rsilva at javelin.mg<mailto:rsilva at javelin.mg>>
Sent: Wednesday, November 30, 2016 5:26 PM
To: Sarkhan Allahverdiyev; postgres-xl-developers at lists.sourceforge.net<mailto:postgres-xl-developers at lists.sourceforge.net>
Subject: Re: [Postgres-xl-developers] PostgreSQL Cluster solution. PostgreSQL - XL Technology

Sarkhan,

While Postgres-XL isn’t the traditional clustered environment, it might provide what you are looking for. The Architectural Fundamentals page within the documentation will give you both an overview of what Postgres-XL is and is not.
http://files.postgres-xl.org/documentation/tutorial-arch.html
Architectural Fundamentals - Postgres-XL<http://files.postgres-xl.org/documentation/tutorial-arch.html>
files.postgres-xl.org
1.2. Architectural Fundamentals. Before we proceed, you should understand the basic PostgreSQL system architecture. Understanding how the parts of PostgreSQL ...


The 2nd Quadrant site has a good overview of Postgres-XL too.
https://2ndquadrant.com/en/resources/postgres-xl/
Postgres-XL | 2ndQuadrant<https://2ndquadrant.com/en/resources/postgres-xl/>
2ndquadrant.com
Postgres-XL. Postgres-XL is a massively parallel database built on top of, and very closely compatible with PostgreSQL 9.5. It is different because it supports both ...


If you are interested in setting up Postgres-XL, the documentation is quite good.
http://files.postgres-xl.org/documentation/index.html
Postgres- XL 9.5r1.3 Documentation<http://files.postgres-xl.org/documentation/index.html>
files.postgres-xl.org
Postgres-XL 9.5r1.3 Documentation The Postgres-XL Global Development Group. Copyright © 1996-2016 The PostgreSQL Global Development Group. Copyright © 2014-2016 ...



The Getting Started section is a good place to… get started. <grin>
http://files.postgres-xl.org/documentation/tutorial.html
Tutorial - Postgres-XL<http://files.postgres-xl.org/documentation/tutorial.html>
files.postgres-xl.org
Welcome to the Postgres-XL Tutorial. The following few chapters are intended to give a simple introduction to Postgres-XL, relational database concepts, and ...


As for configuration, it all depends on the size of your platform. With Postgres-XL you tune each of the nodes much like a normal Postgres database.

...
R!chard Silva  ETL Architect
www.javelin.mg

From: Sarkhan Allahverdiyev <sarkhan.allahverdiyev at outlook.com<mailto:sarkhan.allahverdiyev at outlook.com>>
Date: Friday, November 25, 2016 at 12:29 AM
To: "postgres-xl-developers at lists.sourceforge.net<mailto:postgres-xl-developers at lists.sourceforge.net>" <postgres-xl-developers at lists.sourceforge.net<mailto:postgres-xl-developers at lists.sourceforge.net>>
Subject: [Postgres-xl-developers] PostgreSQL Cluster solution. PostgreSQL - XL Technology


Hello,


I need help about setup PostgreSQL Cluster (Active\Passive with Load Balancing). After some researching on internet i have found that there are no more solution for Cluster in PostgreSQL database. Is it true?

But I have found PostgreSQL XL database which gives Cluster solution is it true? If yes could you give me some guides like as configuration and etc?

Best Regards

Sarkhan Allahverdiyev
Database Administrator
Phone: +994 55 7717727





Access Manager: This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. Dissemination, distribution or copying of this e-mail or the information herein by anyone other than the intended recipient, or an employee or agent responsible for delivering the message to the intended recipient, is prohibited. If you have received this e-mail in error, please immediately notify us by calling the Help Desk at (855) 237-8324.



Access Manager: This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. Dissemination, distribution or copying of this e-mail or the information herein by anyone other than the intended recipient, or an employee or agent responsible for delivering the message to the intended recipient, is prohibited. If you have received this e-mail in error, please immediately notify us by calling the Help Desk at (855) 237-8324.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-developers-postgres-xl.org/attachments/20161214/7678f679/attachment.htm>


More information about the Postgres-xl-developers mailing list