Stack Overflow
Stack Overflow

Questions tagged [postgres-xl]

postgres-xl is a maintained, updated fork of the multi-master PostgreSQL fork postgres-XC.

postgres-xl is a maintained, updated fork of the multi-master PostgreSQL fork postgres-XC. See http://www.postgres-xl.org/

52 questions
6
votes
1 answer

psql: FATAL: Could not obtain a transaction ID from GTM. The GTM might have failed or lost connectivity

I want to create a postgres-xl cluster. The cluster includes 5 nodes, 1 GTM, 2 Coordinator and 2 Datanodes. The following are the details of nodes GTM: hostname=localhost nodename=gtm IP=127.0.0.1 port=20001 Coordinator1： …
Pratheesh M
  • 1,028
  • 6
  • 13
5
votes
1 answer

Migrating from Postgresql to Postgres-XL: distributed tables design

I need to scale out our application DB due to the amount of data. It's on PostgreSQL 9.3. So, I've found PostgreSQL-XL and it looks awesome, but I'm having a hard time trying to wrap my head around the limitations for distributed tables. To…
Joe
  • 101
  • 1
  • 7
3
votes
1 answer

Sharding existing postgresql database with PostgresXL

We want to shard our PostgreSQL DB, due to high disk load. Firstly, we looked at django-sharding library, but: Very much rewriting in our backend Migrating all tables to 64-bit primary keys is hard work on 300-400gb tables Generating ids with…
M1ha Shvn
  • 103
  • 5
3
votes
1 answer

installing postgres-xl in linux in distributed environment

I am very new to postgres-xl. I am planning to use it to my application. There is no properdocumentation to download and install in distributed mode. Please guide me, from where to download, install, configuration, what are the dependent packages…
Madhu Mohan Kommu
  • 335
  • 2
  • 13
3
votes
2 answers

Setting Up Postgres-XL on Single Machine Configuration

I was wondering if anyone here has any experience installing Postgres-XL, the new open-source multi-thread version of PostgreSQL. I'm planning to migrate a 1-2 TB set of databases from regular Postgres 9.3 to XL and was wondering if anyone here has…
Serban Tanasa
  • 3,592
  • 2
  • 23
  • 45
2
votes
0 answers

pacemaker master/slave configuration for postgres-xl datanodes

I have created a cluster with 1 gtm (on t1), 1 coordinator (on t1) and 2 datanode (master/slave) (on t1 and t2 respectively) using postgres-xl. I am trying to configure pacemaker heartbeat application using the below github…
Deepesh Gupta
  • 21
  • 2
2
votes
2 answers

Drop database which has a "minus" in its name in Postgres

I've this database named a-b in postgres and I'm unable to delete it using this query drop database "a-b";. The double quotes were supposed to work but sadly, they didn't. I'm using Postgres-XL r1.3. The error message I receive is: ERROR: syntax…
Pragun
  • 1,123
  • 8
  • 20
2
votes
4 answers

Performance of Postgres-XL 9.5 cluster vs single PostgreSQL 9.5

I use a VMWare environment to compare the performance of Postgres-XL 9.5 and PostgreSQL 9.5. I build Postgres-XL cluster following the instruction of Creating a Postgres-XL cluster Physical HW: M/B: Gigabyte H97M-D3H CPU: Intel i7-4790…
wureka
  • 731
  • 1
  • 11
  • 26
2
votes
1 answer

Postgres-XL happens ERROR:maximum number of prepared transactions reached

I am testing Postgres-XL 9.5r1.2. I build a cluster with gtm, coord1, datanode1, datanode2. I use pgbench to test its performance with below commands: pgbench -h db -U postgres -i -s 100 testdb; pgbench -h db -U postgres -c 70 -t 40 -r testdb In…
wureka
  • 731
  • 1
  • 11
  • 26
2
votes
1 answer

Which data node the table is stored, how to query in postgres-xl?

when creation of table, the distribute sub statement is not used. If there is 2 node, how could I query where the table is actual stored? If there are two tables and they are belong to the same schema, will they be stored different data node?
Chen Yu
  • 3,955
  • 1
  • 24
  • 51
2
votes
1 answer

DRP for postgres-xl

After installing and setting up a 2 node cluster of postgres-xl 9.2, where coordinator and GTM are running on node1 and the Datanode is set up on node2. Now before I use it in production I have to deliver a DRP solution. Does anyone have a DR plan…
user3796774
  • 101
  • 5
1
vote
0 answers

PostgresXL pgxc_ctl connection refused when adding coordinator

Following tutorial on https://github.com/bitnine-oss/postgres-xl-ha/blob/master/README.md, I get the following error when trying to add coordinator (using pgxc_ctl): Actual Command: PGXC add coordinator master coord komp2 30001 30011 none none…
aaron
  • 257
  • 6
  • 15
1
vote
0 answers

postgresxl failed to acquire conncetion from datanode

all. we are using postgres-xl as our mpp database. where we excecute a sql throug jdbc,the server will have low probability to success excecution. most time,server will response a error,like below: Caused by: org.postgresql.util.PSQLException:…
zhouxiang
  • 153
  • 3
  • 12
1
vote
0 answers

unable to drop or alter table on postgresql

We recently encountered a problem using the postgres-xl software, there is a table we can not drop can not alter, will always be in the execution state. We checked the Internet, and some answered that the table is locked, but the lifting of the lock…
weishibo
  • 11
  • 3
1
vote
2 answers

postgres-xl self join cost 10 seconds when combine data

My postgres-xl version was 9.5r1.5 stable. When query like below SELECT * FROM tests t1 LEFT JOIN tests t2 ON t1.id1 = t2.id2 WHERE t1.id1=10000; This query is simple, and just return one row. When I ran it in the data node, only cost 10ms. But…
simo yang
  • 23
  • 4
1
2 3 4