[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