Stack Overflow
Stack Overflow

Questions tagged [postgres-xc]

Postgres-XC is a multi-master write-scalable PostgreSQL cluster based on shared-nothing architecture.

Postgres-XC (eXtensible Cluster) is a multi-master write-scalable PostgreSQL cluster based on shared-nothing architecture, developed by Postgres-XC Development Group.

10 questions
3
votes
0 answers

pg_ctl: no operation specified

I tried to start postgresql server using pg_ctl with following command: pg_ctl -D /opt/PostgreSQL/9.3/data start causes following error message: Postgres-XC: must start as either a Coordinator (--coordinator) or Datanode (--datanode) So I…
Hello lad
  • 17,344
  • 46
  • 127
  • 200
2
votes
1 answer

On Postgres-XC start getting sudo: unknown user: postgres sudo: unable to initialize policy plugin?

Installed Postgres-XC $>sudo apt-get install postgres-xc then $ postgres -V postgres (PostgreSQL) 9.2.4 after this I tried to start the Postgres server using following methods. method 1 $>sudo postgres --coordinator -D DN2 "root" execution of…
Chandrashekar Bemagoni
  • 119
  • 3
  • 15
1
vote
1 answer

Getting the following error while creating table using two nodes "Failed to get Pooled connection"

I have configured two gtm (gtm1,gtm2) in two different machine using postgres-xc. And configured coordinator1,datanode1 in gtm1 machine and coordinator2, datanode2 in gtm2 machine. I have logged in both coordinator servers and created the datanode1…
Rajasekaran M
  • 163
  • 2
  • 16
1
vote
1 answer

Postgres XC Error while distributing data by replication in psql

I have installed, configured my Postgres XC 1.0.2 on Ubuntu. I was able to setup the GTM, Coordinator, nodes 1 & 2 with no challenges. But when attempting to distribute the data amongst the two nodes, I'm getting the below errors which are actually…
Caroffrey
  • 235
  • 3
  • 10
0
votes
1 answer

Why I can't do anything with postgres?

I am using Linux Mint 17. I installed postgres with apt-get. I got postgres user account, I didn't have to create it. Then I login as postgres and followed these steps: $ initdb -D /usr/local/pgsql/data ... Success. You can now start the database…
piga
  • 13
  • 1
  • 6
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
0 answers

Strange behavior of IN query

I am experiencing a strange behavior with nested query inside the IN query. It is taking unexpectedly longer time to execute. I have simplified my query to minimal for debugging. Here is the SQL: select * from test_table where id in ( select…
Sabuj Hassan
  • 38,281
  • 14
  • 75
  • 85
0
votes
1 answer

Getting error while creating node in postgres-xc cluster database

I have tried to create postgres-xc cluster database.So i followed their documentation do that (http://postgres-xc.sourceforge.net/docs/1_1/install-short.html) After following that documentation procedure I'm not able to create node. I'm getting the…
sachin
  • 13,605
  • 14
  • 42
  • 55
0
votes
1 answer

Distributing SQL queries over a PostgreSQL cluster

In order to improve the scalability of my database, I would like to have multiple instances of PostgreSQL distributed over multiple machines. (Horizontal sharding) Most of the operations executed on my database are INSERTs - there are a few…
mlabour
  • 101
  • 1
  • 1
  • 5
-2
votes
1 answer

Benchmark postgresql cluster (postgres-xc) using Daabase Test tool-2 (DBT2)

I'm trying to understand benchmark tool DBT2. I want to benchmark on postgres-xc, i could not get much information about how to set up the environment of postgres-xc for DBT2. I have got the DBT2 from the link I have fixed some compilation issues.…
jarjarbinks
  • 171
  • 1
  • 3
  • 8