[Postgres-xl-developers] Starting with PostgreSQL-XL

Luciano Burotti lburotti at yahoo.com.ar
Mon May 26 05:43:34 PDT 2014


I started the process using these commands:

/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data_coord1 --nodename coord1
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data_datanode1 --nodename datanode1
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data_datanode2 --nodename datanode2

/usr/local/pgsql/bin/postgres --datanode -p 15432 -D /usr/local/pgsql/data_datanode1 >logfile 2>&1 &
/usr/local/pgsql/bin/postgres --datanode -p 15433 -D /usr/local/pgsql/data_datanode2 >logfile 2>&1 &
/usr/local/pgsql/bin/postgres --coordinator -D /usr/local/pgsql/data_coord1 >logfile 2>&1 &

Here you are what the "ps fax" shows:

13888 ?        S      0:06 /usr/local/pgsql/bin/postgres --datanode -p 15432 -D /usr/local/pgsql/data_datanode1
13914 ?        S      0:06 /usr/local/pgsql/bin/postgres --datanode -p 15433 -D /usr/local/pgsql/data_datanode2
13929 ?        S      0:06 /usr/local/pgsql/bin/postgres --coordinator -D /usr/local/pgsql/data_coord1

The "select * from pgxc_node" on the coordinator shows:

  oid  | node_name | node_type | node_port | node_host | nodeis_primary | nodeis_preferred |  node_id   
-------+-----------+-----------+-----------+-----------+----------------+------------------+------------
 11197 | coord1    | C         |      5432 | localhost | f              | f                | 1885696643
 16384 | datanode1 | D         |     15432 | localhost | f              | f                |  888802358
 16385 | datanode2 | D         |     15433 | localhost | f              | f                | -905831925
(3 rows)

Regards
Luciano





El día jueves, 22 de mayo de 2014 23:54, Mason Sharp <msharp at translattice.com> escribió:
 

 



On Thu, May 22, 2014 at 3:44 PM, Luciano Burotti <lburotti at yahoo.com.ar> wrote:
 
Hi all, I don't know if this is the right list, but I have some issues with PostgreSQL-XL v9.2.
>I installed following the short installation steps on 1 vm. I have 1 corrd, 2 datanodes and 1 gtm server.
>
>I created a new database and tables. All the datanodes created that objects perfectly, but the problem start executing DML statements.
> 
>The inserts seem not working well (maybe I have a misconfiguration). When execute an insert in the coordinator, the datanodes show on its log files an error like this:
>
>ERROR:  node "coord_26782" does not exist
> 
>

I wonder if the coordinator is trying to mistakenly access another coordinator?

Can you please let me know the output of "select * from pgxc_node" on the coordinator?

Also, did you start the coordinator as a coordinator, and each datanode as a datanode via the -Z option?


-- 

Mason Sharp
 
TransLattice - http://www.translattice.com
 Distributed and Clustered Database Solutions
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-developers-postgres-xl.org/attachments/20140526/c9f2be09/attachment.htm>


More information about the Postgres-xl-developers mailing list