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

Mason Sharp msharp at translattice.com
Tue May 27 06:05:49 PDT 2014


On Mon, May 26, 2014 at 5:43 AM, Luciano Burotti <lburotti at yahoo.com.ar>wrote:

> I started the process using these commands:
>
> /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data_coord1 --nodenamecoord1
> /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)
>
>
Note that the datanodes also need to know about the other datanodes.

So, please run CREATE NODE on each, too, preferably via EXECUTE DIRECT.

What may make life easier is to configure the cluster with the pgxc_ctl
utility, there are fewer chances to make mistakes.


-- 
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/20140527/5b40446d/attachment.htm>


More information about the Postgres-xl-developers mailing list