[Postgres-xl-general] When I tried to start the datanode2 in thesame server but failed. Why?
Eason Yi
11719668 at qq.com
Tue Dec 9 03:59:03 PST 2014
Thank you both very much!
I'll try it again.
------------------
Regards,
Eason
------------------ Original ------------------
From: "Nikhil Sontakke";<nikhils at translattice.com>;
Date: Tue, Dec 9, 2014 06:07 PM
To: "Eason Yi"<11719668 at qq.com>;
Cc: "postgres-xl-general"<postgres-xl-general at lists.sourceforge.net>;
Subject: Re: [Postgres-xl-general] When I tried to start the datanode2 in thesame server but failed. Why?
Hi Eason,
The datanodes need to use *separate* pooler ports if running on the same node. Please ensure that "pooler_port" value is different for each datanode and coordinator nodes.
Also, please consider using the pgxc_ctl utility to setup the cluster to avoid such kinds of hassles.
http://files.postgres-xl.org/documentation/pgxc-ctl.html
Regards,
Nikhils
On Tue, Dec 9, 2014 at 5:33 PM, Eason Yi <11719668 at qq.com> wrote:
Hi, everybody!
I have tried the instruction of "Chapter 15. Installation from Source Code" from XL 9.2 doc.
When I tried to start the datanode2 in the same server but failed.
Would you please give me some advice? Thanks.
Following is something printed on my screen.
Some of my history info:
78 /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data_coord1 --nodename coord1
79 /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data_datanode1 --nodename datanode1
80 /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data_datanode2 --nodename datanode2
81 /usr/local/pgsql/bin/initgtm -D /usr/local/pgsql/data_gtm -Z gtm
82 /usr/local/pgsql/bin/gtm -D /usr/local/pgsql/data_gtm >logfile 2>&1 &
83 /usr/local/pgsql/bin/postgres --datanode -p 15432 -D /usr/local/pgsql/data_datanode1 >logfile 2>&1 &
84 /usr/local/pgsql/bin/postgres --datanode -p 15433 -D /usr/local/pgsql/data_datanode2 >logfile 2>&1 &
85 /usr/local/pgsql/bin/postgres --coordinator -D /usr/local/pgsql/data_coord1 >logfile 2>&1 &
When I got failed, I tried again, but still failed:
postgres at debian-zine:~$ !84
/usr/local/pgsql/bin/postgres --datanode -p 15433 -D /usr/local/pgsql/data_datanode2 >logfile 2>&1 &
[3] 4174
[3]+ 退出 1 /usr/local/pgsql/bin/postgres --datanode -p 15433 -D /usr/local/pgsql/data_datanode2 > logfile 2>&1
postgres at debian-zine:~$ ps -ef|grep pgsql
postgres 4095 3855 0 16:13 pts/0 00:00:00 /usr/local/pgsql/bin/gtm -D /usr/local/pgsql/data_gtm
postgres 4112 3855 0 16:13 pts/0 00:00:00 /usr/local/pgsql/bin/postgres --datanode -p 15432 -D /usr/local/pgsql/data_datanode1
postgres 4201 3855 0 16:17 pts/0 00:00:00 grep pgsql
postgres at debian-zine:~$ cat logfile
FATAL: lock file "/tmp/.s.PGPOOL.6667.lock" already exists
HINT: Is another postmaster (PID 4114) using socket file "/tmp/.s.PGPOOL.6667"?
LOG: pool manager process (PID 4176) exited with exit code 1
LOG: terminating any other active server processes
LOG: startup process (PID 4175) exited with exit code 2
LOG: aborting startup due to startup process failure
postgres at debian-zine:~$
Following if copy from the XL doc:
./configure gmake su gmake install adduser postgres mkdir /usr/local/pgsql/data_coord1 mkdir /usr/local/pgsql/data_datanode1 mkdir /usr/local/pgsql/data_datanode2 mkdir /usr/local/pgsql/data_gtm chown postgres /usr/local/pgsql/data_coord1 chown postgres /usr/local/pgsql/data_datanode1 chown postgres /usr/local/pgsql/data_datanode2 chown postgres /usr/local/pgsql/data_gtm su - postgres /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/initgtm -D /usr/local/pgsql/data_gtm -Z gtm /usr/local/pgsql/bin/gtm -D /usr/local/pgsql/data_gtm >logfile 2>&1 & /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 & /usr/local/pgsql/bin/psql -c "CREATE NODE datanode1 WITH (TYPE = 'datanode', PORT = 15432)" postgres /usr/local/pgsql/bin/psql -c "CREATE NODE datanode2 WITH (TYPE = 'datanode', PORT = 15433)" postgres /usr/local/pgsql/bin/psql -c "SELECT pgxc_pool_reload()" postgres /usr/local/pgsql/bin/createdb test /usr/local/pgsql/bin/psql test
------------------
Regards,
Eason
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Postgres-xl-general mailing list
Postgres-xl-general at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/postgres-xl-general
--
TransLattice - http://www.translattice.com
Distributed and Clustered Database Solutions
Postgres-XL Support
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20141209/35960977/attachment.htm>
More information about the postgres-xl-general
mailing list