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
0
votes
4 answers

Scale OLTP solutions

I'm looking for a way to scale the infrastructure at my work place. Currently there is only one database with the size of ~1.5TB. Most of the queries are OLTP type like insert, update, delete. I was thinking about sharding the database using…
Bogdan Boamfa
  • 395
  • 2
  • 18
0
votes
2 answers

Issue with datanodes on postgres-XL cluster

Postgres-XL not working as expected. I have configured a Postgres-XL cluster as below: GTM running on node3 GMT_Proxy running on node2 and node1 Co-ordinators and datanodes running on node2 and node1. When I try to do any operation connecting to…
karthick
  • 11
  • 1
0
votes
2 answers

Horizontal partition in postgres-xl?

I am using postgres-xl in ubuntu. I have a table with 9 row. I want to divide that table into 3 parts. Any idea how i do this? postgres=# SELECT * FROM cities; name | location ------+---------- a | 1 a | 2 a | 4 a…
Muhammad Raza
  • 847
  • 1
  • 8
  • 22
0
votes
2 answers

createuser temp, psql postgres and createdb newdb not working in postgres-xl?

I am using postgres-xl in ubuntu 12.04. when i try to use createuser temp, psql postgres, createdb newdb error is createdb: could not connect to database template1: could not connect to server: No such file or directory Is the server running…
Muhammad Raza
  • 847
  • 1
  • 8
  • 22
0
votes
1 answer

About read-only transaction in PostgresXL

my PostgresXL version 9.2.0 (1) After I started the GTM, DataNode, Coordinator, as well as the coordinator of each datanode postgresql.conf archive #default_read_only_transaction = "off" modified default_read_only_transaction = "off" (2) Use the…
0
votes
1 answer

Postgres-XL for windows

Currently I am of the assumption that Postgres-XL can be installed on Linux/Unix machines. But is there a way to install Postgres-XL on a Windows Server Machine? If Yes, any help or resource would be really helpful. Thanks
0
votes
1 answer

Postgres-XL backwards compatible with PostgreSQL?

Is Postgres-XL fully backwards compatible with PostgreSQL? If so, what extra setup is required to take advantage of the automatic sharding? Is Postgres-XL production-ready or will it be merged with core?
paulkon
  • 1,755
  • 2
  • 20
  • 34
1 2 3
4