If it's pertinent I'm running Ubuntu 16.04.3 as an OS on these VM's and the VM host
Connection string adding PID where it looks like a port should go
Multiple Servers for GTM Proxy
Sorry, it was a problem with the pg_hba.conf entry.
ERROR: Failed to get pooled connections
Can you please attach server logs from coordinator and datanode? The way extensions are created in XL is by sending "CREATE EXTENSION" command to all nodes. The coordinator makes sure that none of the DDLs are sent down to the remote nodes, but if there are DMLs (such as a SELECT query or an anonymous block) that are dependent on the objects created by the extension, that can cause problems since those objects may not exist yet on the datanodes. I wonder if something changed in that area between...
Compatibility issue when trying to install PostGres-XL with PostGis
currval of sequence is not yet defined in this session
Prepared transactions
version 9.5r1.4
SIGSEGV pgxc_ctl
I got an answer from pavanvd in another thread. In the newest version pgxc_ctl.conf...
I got an answer from pavanvd in another thread. In the newest version pgxc_ctl.conf...
BINGO! That fixed it! Looks like I was working from an out of date example page that...
Can you check if the following variables are set correctly in pgxc_ctl.conf file?...
Looks like the this "Invalid operation: Failed to get pooled connections;" is your...
In the config file for pgxc_ctl you need to add the two properties below and list...
I got this error too. It comes down to having conflicting ports set or a firewall...
pgxc_ctl failing even in BASH
Having the same problem. Thread below says the command is not running in BASH either...
Pooled ports through pgxc_ctl nort being set correctly
CREATE TABLE AS throwing error
Postgres-xl cannot add new datanode to existing cluster
problem with pg_hba.conf
I have found the issue. On failover of GTM at datanode postgres.conf file gtm_host...
DDL DML commands are hanging for ever.. even on REBOOT cluster not helped
The objective of XL is for scaling and handling DBMS over a distributed architecture....
Please HELP. I need an understanding of installation of Postgres-XL Hello Durga Mahesh,...
Hi Pavan, As per your suggestion, I have upgraded and tested the scenarios on 9.5...
On Wed, Aug 3, 2016 at 11:08 AM, srinivasa reddy ksreddy543@users.sf.net wrote: Hi...
Hi Pavan, Thanks for your response inspite of your busy schedule. Can you please...
FreeBSD is not a supported platform at this stage. But you're welcome to test and...
select * from pgxc_node; node_name | node_type | node_port | node_host | nodeis_primary...
Failed to get pooled connections on GTM Master Failover
ODBC Connection to postgres XL server hangs occasionally
Home
Home
9.5 Beta does not honour ON CONFLICT for replicated tables
postgres-XL parameters related for stable running
And also, please ensure that there are no port conflicts.
Hi Shahid, I managed to fix this issue. Here is what I did. Got the latest version...
I am having the same issue. Not able to insert values into tables. INSERT INTO test...
Thanks for the reply Pavan. Indeed thats a possible solution, however when the references...
Thanks for the reply Pavan. Indeed thats a possible solution, however when the references...
On Tue, Oct 6, 2015 at 4:05 PM, Raul Palma rapw3k@users.sf.net wrote: After some...
After some digging, this has been solved. However there is a big limitation in the...
After some digging, this has been solved. However there is a big limitation in the...
After some digging, this has been solved. However there is a big limitation in the...
Problems creating schema using distribution mode
The Result plan is put inside a remotesubplan for the insert query.
Hello Pavan, PGXC_NODE output from each node is also present in postgreXLInsertFailure.txt...
Can you please share output of "SELECT * FROM pgxc_node" from each node? Is it possible...
Hi Pavan, Thanks for quick response. Here are answers to some of your questions....
Hi Pradyumna, Can you please post the hardware/configuration of each machine in the...
Hi, Please let me know, if there is any update related to this INSERT failure issue....
I followed the setup guide , described in this short version of the setup. URL: ...
Hello Pavan, Thank you very much for response. Please find the log files on dropbox.com...
Hi, Can you please attach a self-contained test case? How do you set up the cluster?...
Please find the SQL command shell dump.
Please find the related logs and CSV sample file attached.
Hi all, I am facing the exact same problems with insert. CSV import works fine. Updates...
After some days of analysis, we found the autovacuum caused this bottleneck. After...
Inconsistant execution for same query and data
Changed license from the Mozilla Public License
Authentication not passed from coordinator to datanodes (trust required)
Strange behaviour when doing insert (...) values (...(SELECT ... FROM...WHERE));
Sorry, I forgot to mention that the 2nd and 3rd examples above have the good-looking...
Co-distributed joins still getting re-distributed
Would like to help you guys work on this..Could you link in any details relating...
We can keep this issue open until we update the documentation.
setting shared_queue_size to multiplication of the record size helped. Still proper...
Failed Connection from DC to DN
I solved this problem, here's how... The most basic installation is 1 gtm, coordinator...
Hi, I'm having the same problem attempting to insert records. Please post details...
nb. for some tables this errors appear even when the source table has no rows.
Producer errors for insert into x select * ...
Renaming the schema leaves the sequences behind in GTM
We need some amount of work to make BDR available in XC/XL. In XC/XL, updates to...
Postgres-XL with BDR for data nodes?
Good question. So far, there could be some problem if you have a distributed table....
Thanks Koichi. One more thing , so if a node goes down for any reason and there are...
To failover datanodes, you need slave for each of them. XL itself is not for failover...
Failover testing
Hi Viraj, I have same problem with insertion: http://dba.stackexchange.com/questions/97514/postgres-xl-does-not-insert-rows...
Hi Dmitry, First of all guys thanks for all the comments , it made my job a lot easier...
This case succeed for me, postgres=# CREATE TABLE INET_TBL(c cidr, i inet); CREATE...
pg_bulkload not working with Postgres-XL
status: open --> closed
Im getting this error and i dont get what you have said, whats the solution for ...
cubeparse.c:163: error: conflicting types for ‘cube_yyparse’
Hi Pavan, Im really new into this. I already have postgres installed in my Redhat...
Would you mind trying from the sources cloned from the master branch of the git repo?...