Thread: [Postgres-xc-developers] Query Related to Postgresql-XC

Hi Team,

I was working on postgresql setup and try to run coordinate and datanode services on same machine.As per the postgresql.conf file default port value  is using for first service(coordinator).whenever  i try to start other service(Datanode) it showing error.how to give one more port number value to start datanode service.

Regards
Arshad

On Mon, May 28, 2012 at 9:51 AM, MOHD ARSHAD SALEEM
<mar...@ta...> wrote:
> Hi Team,
>
> I was working on postgresql setup and try to run coordinate and datanode
> services on same machine.As per the postgresql.conf file default port value
> is using for first service(coordinator).whenever  i try to start other
> service(Datanode) it showing error.how to give one more port number value to
> start datanode service.
>

What is the particular error?

Just make sure that you have unique ports configured in the
postgresql.conf file if they are running on the same system.  Note
that it if you are using 5432 and have a regular PostgreSQL instance
running, it could conflict with that.

Regards,

Mason

> The error is related to port no only in postgresql.conf the port no(5432) gives to start one of the service(coordinator or datanode).
> how to start another service.because port no is already in use by the service.
> In postgres-XC document they wrote you have to use different port no for coordinator node and datanode 
________________________________________




From: mas...@gm... [mas...@gm...] on behalf of Mason [ma...@us...]
Sent: Monday, May 28, 2012 10:42 PM
To: MOHD ARSHAD SALEEM
Cc: pos...@li...
Subject: Re: [Postgres-xc-developers] Query Related to Postgresql-XC

On Mon, May 28, 2012 at 9:51 AM, MOHD ARSHAD SALEEM
<mar...@ta...> wrote:
> Hi Team,
>
> I was working on postgresql setup and try to run coordinate and datanode
> services on same machine.As per the postgresql.conf file default port value
> is using for first service(coordinator).whenever  i try to start other
> service(Datanode) it showing error.how to give one more port number value to
> start datanode service.
>

What is the particular error?

Just make sure that you have unique ports configured in the
postgresql.conf file if they are running on the same system.  Note
that it if you are using 5432 and have a regular PostgreSQL instance
running, it could conflict with that.

Please take a look at XC tutorial material available at
https://sourceforge.net/projects/postgres-xc/files/Presentation/20120516_PGConTutorial/

Also, Michael's material will be found at
https://sourceforge.net/projects/postgres-xc/files/Publication/

Please try start_pgxc_in_10_commands.txt

Hope they help.

Regards;
----------
Koichi Suzuki


2012/5/28 MOHD ARSHAD SALEEM <mar...@ta...>:
> Hi Team,
>
> I was working on postgresql setup and try to run coordinate and datanode
> services on same machine.As per the postgresql.conf file default port value
> is using for first service(coordinator).whenever  i try to start other
> service(Datanode) it showing error.how to give one more port number value to
> start datanode service.
>
> Regards
> Arshad
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>

We still need to review XC documentation with better examples than this one
which is wrong.
http://postgres-xc.sourceforge.net/docs/1_0/install-short.html

On Tue, May 29, 2012 at 10:03 AM, Koichi Suzuki <koi...@gm...>wrote:

> Please take a look at XC tutorial material available at
>
> https://sourceforge.net/projects/postgres-xc/files/Presentation/20120516_PGConTutorial/
>
> Also, Michael's material will be found at
> https://sourceforge.net/projects/postgres-xc/files/Publication/
>
> Please try start_pgxc_in_10_commands.txt
>
> Hope they help.
>
> Regards;
> ----------
> Koichi Suzuki
>
>
> 2012/5/28 MOHD ARSHAD SALEEM <mar...@ta...>:
> > Hi Team,
> >
> > I was working on postgresql setup and try to run coordinate and datanode
> > services on same machine.As per the postgresql.conf file default port
> value
> > is using for first service(coordinator).whenever  i try to start other
> > service(Datanode) it showing error.how to give one more port number
> value to
> > start datanode service.
> >
> > Regards
> > Arshad
> >
> >
> ------------------------------------------------------------------------------
> > Live Security Virtual Conference
> > Exclusive live event will cover all the ways today's security and
> > threat landscape has changed and how IT managers can respond. Discussions
> > will include endpoint security, mobile security and the latest in malware
> > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> > _______________________________________________
> > Postgres-xc-developers mailing list
> > Pos...@li...
> > https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
> >
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>



-- 
Michael Paquier
http://michael.otacoo.com

On Mon, May 28, 2012 at 10:51 PM, MOHD ARSHAD SALEEM <
mar...@ta...> wrote:

>  Hi Team,
>
> I was working on postgresql setup and try to run coordinate and datanode
> services on same machine.As per the postgresql.conf file default port
> value  is using for first service(coordinator).whenever  i try to start
> other service(Datanode) it showing error.how to give one more port number
> value to start datanode service.
>
You can specify a port number by changing the value of parameter port in
postgresql.conf in the data folder of each node.
You can also specify a value when starting a node with binary postgres with
its option "-p". For example:
postgres -C -p 5433 -D $DATA
Are you familiar with PostgreSQL?
-- 
Michael Paquier
http://michael.otacoo.com

i tried with similar option but again it showing same error

following command i run ->
> postgres -X  -p 5433 -D /usr/local/pgsql/data -i

Error which i was getting->
> FATAL:  lock file "postmaster.pid" already exists
> HINT:  Is another postmaster (PID 2700) running in data directory "/usr/local/pgsql/data"?

Regards
Arshad
________________________________
From: Michael Paquier [mic...@gm...]
Sent: Tuesday, May 29, 2012 12:50 PM
To: MOHD ARSHAD SALEEM
Cc: pos...@li...
Subject: Re: [Postgres-xc-developers] Query Related to Postgresql-XC

On Mon, May 28, 2012 at 10:51 PM, MOHD ARSHAD SALEEM <mar...@ta...<mailto:mar...@ta...>> wrote:
Hi Team,

I was working on postgresql setup and try to run coordinate and datanode services on same machine.As per the postgresql.conf file default port value  is using for first service(coordinator).whenever  i try to start other service(Datanode) it showing error.how to give one more port number value to start datanode service.
You can specify a port number by changing the value of parameter port in postgresql.conf in the data folder of each node.
You can also specify a value when starting a node with binary postgres with its option "-p". For example:
postgres -C -p 5433 -D $DATA
Are you familiar with PostgreSQL?
--
Michael Paquier
http://michael.otacoo.com

Each Postgres-XC node has to use a different data folder.
Please refer to the document start_pgxc_in_10_commands.txt that you can
find in here:
https://sourceforge.net/projects/postgres-xc/files/Publication/

By looking at this file, you can notice that the data folder of each node
is *different*:
2) initgtm -Z gtm -D gtm
3) initdb -D datanode1 --nodename dn1 #Initialize Datanode 1
4) initdb -D datanode2 --nodename dn2 #Initialize Datanode 2
5) initdb -D coord1 --nodename co1 # Initialize Coordinator 1

Similar to PostgreSQL, you need to specify different data folders for slave
and master nodes if they are on the same servers.

On Tue, May 29, 2012 at 4:33 PM, MOHD ARSHAD SALEEM <
mar...@ta...> wrote:

>  i tried with similar option but again it showing same error
>
> following command i run ->
> > postgres -X  -p 5433 -D /usr/local/pgsql/data -i
>
> Error which i was getting->
> > FATAL:  lock file "postmaster.pid" already exists
> > HINT:  Is another postmaster (PID 2700) running in data directory
> "/usr/local/pgsql/data"?
>
> Regards
> Arshad
>  ------------------------------
> *From:* Michael Paquier [mic...@gm...]
> *Sent:* Tuesday, May 29, 2012 12:50 PM
> *To:* MOHD ARSHAD SALEEM
> *Cc:* pos...@li...
> *Subject:* Re: [Postgres-xc-developers] Query Related to Postgresql-XC
>
>  On Mon, May 28, 2012 at 10:51 PM, MOHD ARSHAD SALEEM <
> mar...@ta...> wrote:
>
>>  Hi Team,
>>
>> I was working on postgresql setup and try to run coordinate and datanode
>> services on same machine.As per the postgresql.conf file default port
>> value  is using for first service(coordinator).whenever  i try to start
>> other service(Datanode) it showing error.how to give one more port number
>> value to start datanode service.
>>
> You can specify a port number by changing the value of parameter port in
> postgresql.conf in the data folder of each node.
> You can also specify a value when starting a node with binary postgres
> with its option "-p". For example:
> postgres -C -p 5433 -D $DATA
> Are you familiar with PostgreSQL?
>  --
> Michael Paquier
> http://michael.otacoo.com
>



-- 
Michael Paquier
http://michael.otacoo.com