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

Sarkhan Allahverdiyev sarkhan.allahverdiyev at outlook.com
Wed Dec 14 05:44:47 PST 2016


Hello again,


Richard when i run pgxc_ctl init all i am getting following error: ( Refer to this links https://ruihaijiang.wordpress.com/2015/09/17/postgres-xl-installation-example-on-linux/)

Postgres-XL Installation Example on Linux | ruihaijiang<https://ruihaijiang.wordpress.com/2015/09/17/postgres-xl-installation-example-on-linux/>
ruihaijiang.wordpress.com
1. Overview. In this example, we use pgxc_ctl to configure a Postgres-XL cluster for test only. The cluster includes 4 nodes, 1 GTM, 1 Coordinator and 2 ...




[postgres at gtm ~]$ pgxc_ctl init all
/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
Initialize GTM master
ERROR: could not open file (null)/STDIN_12124_0 for write, No such file or directory
Done.
Start GTM master
sh: -c: line 0: syntax error near unexpected token `null'
sh: -c: line 0: `ssh (null)@localhost "( [ -f /home/postgres/pgxc/nodes/gtm/gtm.pid ] && gtm_ctl stop -Z gtm -D /home/postgres/pgxc/nodes/gtm;rm -f /home/postgres/pgxc/nodes/gtm/register.node;gtm_ctl start -Z gtm -D /home/postgres/pgxc/nodes/gtm ) > (null)/gtm_STDOUT_12124_2 2>&1" < /dev/null > /dev/null 2>&1'
sh: -c: line 0: syntax error near unexpected token `null'
sh: -c: line 0: `(ssh (null)@localhost touch (null)/gtm_STDOUT_12124_2) < /dev/null > /dev/null 2>&1'
sh: -c: line 0: syntax error near unexpected token `null'
sh: -c: line 0: `(touch (null)/STDOUT_12124_1) < /dev/null > /dev/null'
sh: -c: line 0: syntax error near unexpected token `null'
sh: -c: line 0: `(scp (null)@localhost:(null)/gtm_STDOUT_12124_2 (null)/STDOUT_12124_1; ssh (null)@localhost rm -rf (null)/gtm_STDOUT_12124_2) < /dev/null > /dev/null'
ERROR: Cannot open "(null)/STDOUT_12124_1" for read, No such file or directory
sh: -c: line 0: syntax error near unexpected token `('
sh: -c: line 0: `(rm -f (null)/STDOUT_12124_1) < /dev/null > /dev/null'
sh: -c: line 0: syntax error near unexpected token `null'
sh: -c: line 0: `ssh (null)@localhost "rm -f (null)/gtm_STDOUT_12124_2 > /dev/null 2>&1"'
Initialize all the coordinator masters.
Initialize coordinator master coord1.
ERROR: could not open file (null)/STDIN_12124_3 for write, No such file or directory
Done.
Starting coordinator master.
Starting coordinator master coord1
sh: -c: line 0: syntax error near unexpected token `null'
sh: -c: line 0: `ssh (null)@localhost "( pg_ctl start -w -Z coordinator -D /coord_master.1 -o -i ) > (null)/gtm_STDOUT_12124_5 2>&1" < /dev/null > /dev/null 2>&1'
sh: -c: line 0: syntax error near unexpected token `null'
sh: -c: line 0: `(ssh (null)@localhost touch (null)/gtm_STDOUT_12124_5) < /dev/null > /dev/null 2>&1'
sh: -c: line 0: syntax error near unexpected token `null'
sh: -c: line 0: `(touch (null)/STDOUT_12124_4) < /dev/null > /dev/null'
sh: -c: line 0: syntax error near unexpected token `null'
sh: -c: line 0: `(scp (null)@localhost:(null)/gtm_STDOUT_12124_5 (null)/STDOUT_12124_4; ssh (null)@localhost rm -rf (null)/gtm_STDOUT_12124_5) < /dev/null > /dev/null'
ERROR: Cannot open "(null)/STDOUT_12124_4" for read, No such file or directory
sh: -c: line 0: syntax error near unexpected token `('
sh: -c: line 0: `(rm -f (null)/STDOUT_12124_4) < /dev/null > /dev/null'
sh: -c: line 0: syntax error near unexpected token `null'
sh: -c: line 0: `ssh (null)@localhost "rm -f (null)/gtm_STDOUT_12124_5 > /dev/null 2>&1"'
Done.
Initialize all the datanode masters.
Done.
Starting all the datanode masters.
Done.
ERROR: could not open file (null)/STDIN_12124_6 for write, No such file or directory
Done.
Done.




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/113c52cc/attachment.htm>


More information about the Postgres-xl-developers mailing list