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/
Questions tagged [postgres-xl]
52 questions
1
vote
1 answer
Can Postgres-XL shard, replicate and auto-balance at the same time?
For example if I have 5 servers (A, B, C, D, E)
Can we set the data distributed with replication factor of 3? (for example one write goes to ABC, other records goes to ABD, other record goes to ABE, and so on), so when node C had some hardware…
Kokizzu
- 24,974
- 37
- 137
- 233
1
vote
1 answer
how I should handle postgres-xl gtm failover
I have a cluster like that node1(gtm), node2(gtm-slave), node3(gtm-proxy1, coord1, datanode1)I setup those nodes using pgxc_ctl.
I am testing the gtm failover. Here is what I did:
copy pgxc_ctl.conf from node1 to node2
shutdown node1
ssh int node2…
Tony Huang
- 163
- 3
- 13
1
vote
1 answer
Can we have multiple Postgres XL cluster on the same system?
Whenever we create a Postgres XL cluster, the coordinators, datanodes and GTMs are identical to the same cluster isn't it? So is it possible to create another cluster on the same host using pgxc_ctl? Do I have to generate a different cluster…
Pragun
- 1,123
- 8
- 20
1
vote
0 answers
FATAL: GTM error, could not obtain snapshot. Current XID = 0, Autovac = 0
After running virtually any command (e.g. createdb test) from GTM host inside pgxc_ctl tool, I am getting the following error:
FATAL: GTM error, could not obtain snapshot. Current XID = 0, Autovac = 0
PostgresXL is configured and installed on 4…
Yauhen Yakimovich
- 13,635
- 8
- 60
- 67
1
vote
1 answer
Node.js driver for Postgres-XL
Should the Node.js driver/connector for PostgreSQL be expected to function for Postgres-XL? What is the best way to connect to a Postgres-XL setup from Node.js?
ahron
- 803
- 6
- 29
1
vote
2 answers
About coordinator and datanode in Postgres-XL
thanks for your help.
I failed to build a Postgres-XL cluster.
My gtm.confg :
listen_addresses = '0.0.0.0'
port = 6668
at 10.80.19.47.
My gtm_proxy.confg:
listen_addresses = '0.0.0.0'
port = 6666
gtm_host = '10.80.19.47'
gtm_port = 6668
after…
sheldon Xu
- 13
- 7
1
vote
0 answers
Why integer column data returns by ascii encoding?
I am moving the database from postgres to postgres-xl.
The client driver the erlang's epgsql:
The table schema is as follows:
CREATE TABLE test_table1 (id integer primary key, value text);
test data:
INSERT INTO test_table1 (id, value) VALUES…
Chen Yu
- 3,955
- 1
- 24
- 51
0
votes
0 answers
Error installing older version of PostGIS
I am trying to install PostGIS in Postgres-xl. Since the newest version of Postgres-XL (9.5r1.4) is based on PostgreSQL 9.5.5, I need to use an older version of PostGIS (2.3.1) due to compatibility issues.
Before PostGIS, I have installed the…
Dennis Savio
- 11
- 2
0
votes
1 answer
Postgres-XL Standby Server
hello everyone I create a cluster in postgres-XL but I use the command pg_ctl promote but I need a standby server how I can create it I need the cluster to be high availability
Martin
- 3
- 1
0
votes
1 answer
How to install PostGIS into Postgres-XL correctly?
I have Postgres-XL 10 installed with geos-3.9.1 and postgis-3.1.1 on my Amazon Linux 2 machine. My cluster is running and working flawlessly but I am having troubles with getting postgis installed into the database. I've built and installed…
fraoudas
- 23
- 5
0
votes
1 answer
Postgres-XL does not support TRIGGER yet
When I use
CREATE EXTENSION postgis_topology;
I get this error:
Postgres-XL does not support TRIGGER yet
The feature is not currently supported
I am using Postgres-XL 10r1.1.
0
votes
1 answer
ERROR: Unique index of distributed table must contain the hash distribution column. when do migration from postgresql to postgresql-xl
I dump sql from postgresql by pg_dump and get below table define:
CREATE TABLE administrator (
mtime bigint,
email text,
group_id bigint,
user_account text NOT NULL
);
ALTER TABLE ONLY administrator ADD CONSTRAINT administrator_pkey…
SaxonTseng
- 1
- 1
0
votes
1 answer
How to connect postgresxl with jmeter
I'm trying to connect my postgresXL database with jmeter, where do i find postgresXl jdbc driver and how to connect it to jmeter?
I've tried postgreSQL jdbc driver but it does not work for me.
Leila
- 1
- 1
0
votes
1 answer
zombodb with postgres-xl: "zombodb.so: undefined symbol: session_auth_is_superuser"
I have a database cluster based on Postgres-xl 10. I have to create a search index by ZomboDB extension. I copied all extension files into /usr/local/pgsql/lib other than standard path of postgresql /usr/lib/pgsql/lib. Because I checked that…
nomad culture
- 52
- 2
- 11
0
votes
1 answer
Initializing Cluster Postgres-XL
I'm having issues initialising a Postgres-XL cluster despite (I think) following steps exactly. A lot of Googling doesn't seem to be bringing up the answer or not, not sure if I'm being stupid or not.
I'm trying to initialise across three VMs, say -…
Mike S
- 3
- 3