|
From: Juned K. <jkh...@gm...> - 2014-03-05 14:11:16
|
Hi All, Since last few days i am trying to setup postgre-xc with 3 local systems. I have done with basic setup, but having issue with database creation. Below is the output of monitor all PGXC monitor all > Running: gtm master > Running: coordinator master coord1 > Running: coordinator master coord2 > Running: datanode master datanode1 > Running: datanode master datanode2 > But when i am trying to create database its giving me below error. PGXC createdb astpp; > createdb: could not connect to database template1: could not connect to > server: No such file or directory > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PGSQL.5432"? > PGXC > I am just one step away to done with my postgre-xc setup. Please suggest me, how to get it fixed . -- Thanks, Juned Khan iNextrix Technologies Pvt Ltd. www.inextrix.com |
|
From: Lin W. <lin...@gm...> - 2014-03-05 15:31:35
|
I think you need point out one port of the coordinators when you create a
database, for example as below:
[wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1
createdb: could not connect to database template1: could not connect to
server: no that file or folder
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
[wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 -p 5300
[wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/psql -d postgres -p
5300 -c "\l"
List of databases
Name | Owner | Encoding | Collate | Ctype | Access
privileges
-----------+-------+----------+-------------+-------------+-------------------
db1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 |
postgres | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 |
template0 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln
+
| | | | | wln=CTc/wln
template1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln
+
| | | | | wln=CTc/wln
(4 rows)
Good Luck
---------
waln
2014-03-05 22:11 GMT+08:00 Juned Khan <jkh...@gm...>:
> Hi All,
>
> Since last few days i am trying to setup postgre-xc with 3 local systems.
> I have done with basic setup, but having issue with database creation.
>
> Below is the output of monitor all
>
> PGXC monitor all
>> Running: gtm master
>> Running: coordinator master coord1
>> Running: coordinator master coord2
>> Running: datanode master datanode1
>> Running: datanode master datanode2
>>
>
> But when i am trying to create database its giving me below error.
>
> PGXC createdb astpp;
>> createdb: could not connect to database template1: could not connect to
>> server: No such file or directory
>> Is the server running locally and accepting
>> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>> PGXC
>>
>
> I am just one step away to done with my postgre-xc setup.
> Please suggest me, how to get it fixed .
>
>
>
> --
> Thanks,
> Juned Khan
> iNextrix Technologies Pvt Ltd.
> www.inextrix.com
>
>
> ------------------------------------------------------------------------------
> Subversion Kills Productivity. Get off Subversion & Make the Move to
> Perforce.
> With Perforce, you get hassle-free workflows. Merge that actually works.
> Faster operations. Version large binaries. Built-in WAN optimization and
> the
> freedom to use Git, Perforce or both. Make the move to Perforce.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
>
|
|
From: Juned K. <jkh...@gm...> - 2014-03-06 05:16:48
|
Hi Lin , Still its not working, same issue PGXC createdb astpp -p 20004 > createdb: could not connect to database template1: could not connect to > server: No such file or directory > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PGSQL.20004"? > PGXC > On Wed, Mar 5, 2014 at 9:01 PM, Lin Wang <lin...@gm...> wrote: > I think you need point out one port of the coordinators when you create a > database, for example as below: > > [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 > createdb: could not connect to database template1: could not connect to > server: no that file or folder > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PGSQL.5432"? > > [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 -p 5300 > [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/psql -d postgres -p > 5300 -c "\l" > List of databases > Name | Owner | Encoding | Collate | Ctype | Access > privileges > > -----------+-------+----------+-------------+-------------+------------------- > db1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | > postgres | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | > template0 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln > + > | | | | | wln=CTc/wln > template1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln > + > | | | | | wln=CTc/wln > (4 rows) > > > Good Luck > --------- > waln > > > 2014-03-05 22:11 GMT+08:00 Juned Khan <jkh...@gm...>: > >> Hi All, >> >> Since last few days i am trying to setup postgre-xc with 3 local systems. >> I have done with basic setup, but having issue with database creation. >> >> Below is the output of monitor all >> >> PGXC monitor all >>> Running: gtm master >>> Running: coordinator master coord1 >>> Running: coordinator master coord2 >>> Running: datanode master datanode1 >>> Running: datanode master datanode2 >>> >> >> But when i am trying to create database its giving me below error. >> >> PGXC createdb astpp; >>> createdb: could not connect to database template1: could not connect to >>> server: No such file or directory >>> Is the server running locally and accepting >>> connections on Unix domain socket "/tmp/.s.PGSQL.5432"? >>> PGXC >>> >> >> I am just one step away to done with my postgre-xc setup. >> Please suggest me, how to get it fixed . >> >> >> >> -- >> Thanks, >> Juned Khan >> iNextrix Technologies Pvt Ltd. >> www.inextrix.com >> >> >> ------------------------------------------------------------------------------ >> Subversion Kills Productivity. Get off Subversion & Make the Move to >> Perforce. >> With Perforce, you get hassle-free workflows. Merge that actually works. >> Faster operations. Version large binaries. Built-in WAN optimization and >> the >> freedom to use Git, Perforce or both. Make the move to Perforce. >> >> http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk >> _______________________________________________ >> Postgres-xc-general mailing list >> Pos...@li... >> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >> >> > -- Thanks, Juned Khan iNextrix Technologies Pvt Ltd. www.inextrix.com |
|
From: 鈴木 幸市 <ko...@in...> - 2014-03-06 05:21:07
|
Is your coordinator running locally? You may have to specify -h option to tell where to go.
Or, you can issue Createdb command, which is embedded pgxc_ctl command. Createdb will chose one of the available coordinators and go there.
Regards;
---
Koichi Suzuki
2014/03/06 14:16、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール:
Hi Lin ,
Still its not working, same issue
PGXC createdb astpp -p 20004
createdb: could not connect to database template1: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.20004"?
PGXC
On Wed, Mar 5, 2014 at 9:01 PM, Lin Wang <lin...@gm...<mailto:lin...@gm...>> wrote:
I think you need point out one port of the coordinators when you create a database, for example as below:
[wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1
createdb: could not connect to database template1: could not connect to server: no that file or folder
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
[wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 -p 5300
[wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/psql -d postgres -p 5300 -c "\l"
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+-------+----------+-------------+-------------+-------------------
db1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 |
postgres | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 |
template0 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln +
| | | | | wln=CTc/wln
template1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln +
| | | | | wln=CTc/wln
(4 rows)
Good Luck
---------
waln
2014-03-05 22:11 GMT+08:00 Juned Khan <jkh...@gm...<mailto:jkh...@gm...>>:
Hi All,
Since last few days i am trying to setup postgre-xc with 3 local systems.
I have done with basic setup, but having issue with database creation.
Below is the output of monitor all
PGXC monitor all
Running: gtm master
Running: coordinator master coord1
Running: coordinator master coord2
Running: datanode master datanode1
Running: datanode master datanode2
But when i am trying to create database its giving me below error.
PGXC createdb astpp;
createdb: could not connect to database template1: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
PGXC
I am just one step away to done with my postgre-xc setup.
Please suggest me, how to get it fixed .
--
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com<http://www.inextrix.com/>
------------------------------------------------------------------------------
Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works.
Faster operations. Version large binaries. Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
_______________________________________________
Postgres-xc-general mailing list
Pos...@li...<mailto:Pos...@li...>
https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
--
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com<http://www.inextrix.com/>
------------------------------------------------------------------------------
Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works.
Faster operations. Version large binaries. Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk_______________________________________________
Postgres-xc-general mailing list
Pos...@li...
https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
|
|
From: Juned K. <jkh...@gm...> - 2014-03-06 05:30:12
|
Hi Koichi, Specified port and host but now getting below error: PGXC createdb koichi -h node2 -p 20004 > createdb: database creation failed: ERROR: Failed to get pooled > connections > PGXC > And which createdb command i should use which will select coordinator automatically. [root@localhost ~]# find / -name createdb > /usr/src/postgres-xc/src/bin/scripts/createdb > /usr/local/pgsql/bin/createdb > /usr/local/bin/createdb > Please suggest. On Thu, Mar 6, 2014 at 10:50 AM, 鈴木 幸市 <ko...@in...> wrote: > Is your coordinator running locally? You may have to specify -h option > to tell where to go. > > Or, you can issue Createdb command, which is embedded pgxc_ctl command. > Createdb will chose one of the available coordinators and go there. > > Regards; > --- > Koichi Suzuki > > 2014/03/06 14:16、Juned Khan <jkh...@gm...> のメール: > > Hi Lin , > > Still its not working, same issue > > PGXC createdb astpp -p 20004 >> createdb: could not connect to database template1: could not connect to >> server: No such file or directory >> Is the server running locally and accepting >> connections on Unix domain socket "/tmp/.s.PGSQL.20004"? >> PGXC >> > > > > > On Wed, Mar 5, 2014 at 9:01 PM, Lin Wang <lin...@gm...> wrote: > >> I think you need point out one port of the coordinators when you create >> a database, for example as below: >> >> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 >> createdb: could not connect to database template1: could not connect to >> server: no that file or folder >> Is the server running locally and accepting >> connections on Unix domain socket "/tmp/.s.PGSQL.5432"? >> >> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 -p >> 5300 >> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/psql -d postgres -p >> 5300 -c "\l" >> List of databases >> Name | Owner | Encoding | Collate | Ctype | Access >> privileges >> >> -----------+-------+----------+-------------+-------------+------------------- >> db1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | >> postgres | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | >> template0 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln >> + >> | | | | | wln=CTc/wln >> template1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln >> + >> | | | | | wln=CTc/wln >> (4 rows) >> >> >> Good Luck >> --------- >> waln >> >> >> 2014-03-05 22:11 GMT+08:00 Juned Khan <jkh...@gm...>: >> >>> Hi All, >>> >>> Since last few days i am trying to setup postgre-xc with 3 local >>> systems. >>> I have done with basic setup, but having issue with database creation. >>> >>> Below is the output of monitor all >>> >>> PGXC monitor all >>>> Running: gtm master >>>> Running: coordinator master coord1 >>>> Running: coordinator master coord2 >>>> Running: datanode master datanode1 >>>> Running: datanode master datanode2 >>>> >>> >>> But when i am trying to create database its giving me below error. >>> >>> PGXC createdb astpp; >>>> createdb: could not connect to database template1: could not connect to >>>> server: No such file or directory >>>> Is the server running locally and accepting >>>> connections on Unix domain socket "/tmp/.s.PGSQL.5432"? >>>> PGXC >>>> >>> >>> I am just one step away to done with my postgre-xc setup. >>> Please suggest me, how to get it fixed . >>> >>> >>> >>> -- >>> Thanks, >>> Juned Khan >>> iNextrix Technologies Pvt Ltd. >>> www.inextrix.com >>> >>> >>> ------------------------------------------------------------------------------ >>> Subversion Kills Productivity. Get off Subversion & Make the Move to >>> Perforce. >>> With Perforce, you get hassle-free workflows. Merge that actually works. >>> Faster operations. Version large binaries. Built-in WAN optimization >>> and the >>> freedom to use Git, Perforce or both. Make the move to Perforce. >>> >>> http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk >>> _______________________________________________ >>> Postgres-xc-general mailing list >>> Pos...@li... >>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >>> >>> >> > > > -- > Thanks, > Juned Khan > iNextrix Technologies Pvt Ltd. > www.inextrix.com > ------------------------------------------------------------------------------ > Subversion Kills Productivity. Get off Subversion & Make the Move to > Perforce. > With Perforce, you get hassle-free workflows. Merge that actually works. > Faster operations. Version large binaries. Built-in WAN optimization and > the > freedom to use Git, Perforce or both. Make the move to Perforce. > > http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk_______________________________________________ > Postgres-xc-general mailing list > Pos...@li... > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general > > > -- Thanks, Juned Khan iNextrix Technologies Pvt Ltd. www.inextrix.com |
|
From: 鈴木 幸市 <ko...@in...> - 2014-03-06 05:44:37
|
You should not use createdb from postgrereSQL. What is your installation target of PGXC?
You can also login to the database using psql and issue create database command.
Regards;
---
Koichi Suzuki
2014/03/06 14:30、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール:
Hi Koichi,
Specified port and host but now getting below error:
PGXC createdb koichi -h node2 -p 20004
createdb: database creation failed: ERROR: Failed to get pooled connections
PGXC
And which createdb command i should use which will select coordinator automatically.
[root@localhost ~]# find / -name createdb
/usr/src/postgres-xc/src/bin/scripts/createdb
/usr/local/pgsql/bin/createdb
/usr/local/bin/createdb
Please suggest.
On Thu, Mar 6, 2014 at 10:50 AM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote:
Is your coordinator running locally? You may have to specify -h option to tell where to go.
Or, you can issue Createdb command, which is embedded pgxc_ctl command. Createdb will chose one of the available coordinators and go there.
Regards;
---
Koichi Suzuki
2014/03/06 14:16、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール:
Hi Lin ,
Still its not working, same issue
PGXC createdb astpp -p 20004
createdb: could not connect to database template1: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.20004"?
PGXC
On Wed, Mar 5, 2014 at 9:01 PM, Lin Wang <lin...@gm...<mailto:lin...@gm...>> wrote:
I think you need point out one port of the coordinators when you create a database, for example as below:
[wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1
createdb: could not connect to database template1: could not connect to server: no that file or folder
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
[wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 -p 5300
[wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/psql -d postgres -p 5300 -c "\l"
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+-------+----------+-------------+-------------+-------------------
db1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 |
postgres | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 |
template0 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln +
| | | | | wln=CTc/wln
template1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln +
| | | | | wln=CTc/wln
(4 rows)
Good Luck
---------
waln
2014-03-05 22:11 GMT+08:00 Juned Khan <jkh...@gm...<mailto:jkh...@gm...>>:
Hi All,
Since last few days i am trying to setup postgre-xc with 3 local systems.
I have done with basic setup, but having issue with database creation.
Below is the output of monitor all
PGXC monitor all
Running: gtm master
Running: coordinator master coord1
Running: coordinator master coord2
Running: datanode master datanode1
Running: datanode master datanode2
But when i am trying to create database its giving me below error.
PGXC createdb astpp;
createdb: could not connect to database template1: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
PGXC
I am just one step away to done with my postgre-xc setup.
Please suggest me, how to get it fixed .
--
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com<http://www.inextrix.com/>
------------------------------------------------------------------------------
Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works.
Faster operations. Version large binaries. Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
_______________________________________________
Postgres-xc-general mailing list
Pos...@li...<mailto:Pos...@li...>
https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
--
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com<http://www.inextrix.com/>
------------------------------------------------------------------------------
Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works.
Faster operations. Version large binaries. Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk_______________________________________________
Postgres-xc-general mailing list
Pos...@li...<mailto:Pos...@li...>
https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
--
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com<http://www.inextrix.com/>
|
|
From: Juned K. <jkh...@gm...> - 2014-03-06 05:55:42
|
Hi Koichi, My install directory is */home/postgres/* > > [postgres@localhost ~]$ pgxc_ctl --configuration > /home/postgres/pgxc_ctl/pgxc_ctl.ctl > Installing pgxc_ctl_bash script as /home/postgres/pgxc_ctl/pgxc_ctl_bash. > Installing pgxc_ctl_bash script as /home/postgres/pgxc_ctl/pgxc_ctl_bash. > Reading configuration using /home/postgres/pgxc_ctl/pgxc_ctl_bash --home > /home/postgres/pgxc_ctl --configuration /home/postgres/pgxc_ctl/pgxc_ctl.ctl > However i am able to connect using psql PGXC psql -p 20004 -h node2 > psql (PGXC 1.1, based on PG 9.2.4) > Type "help" for help. > > postgres=# createdb koichi > but database is not being created. > PGXC psql -p 20004 -h node2 -d koichi > psql: FATAL: database "koichi" does not exist > what could be the problem ? On Thu, Mar 6, 2014 at 11:14 AM, 鈴木 幸市 <ko...@in...> wrote: > You should not use createdb from postgrereSQL. What is your > installation target of PGXC? > > You can also login to the database using psql and issue create database > command. > > Regards; > --- > Koichi Suzuki > > 2014/03/06 14:30、Juned Khan <jkh...@gm...> のメール: > > Hi Koichi, > > Specified port and host but now getting below error: > > PGXC createdb koichi -h node2 -p 20004 >> createdb: database creation failed: ERROR: Failed to get pooled >> connections >> PGXC >> > > And which createdb command i should use which will select coordinator > automatically. > > [root@localhost ~]# find / -name createdb >> /usr/src/postgres-xc/src/bin/scripts/createdb >> /usr/local/pgsql/bin/createdb >> /usr/local/bin/createdb >> > > Please suggest. > > > > > On Thu, Mar 6, 2014 at 10:50 AM, 鈴木 幸市 <ko...@in...> wrote: > >> Is your coordinator running locally? You may have to specify -h option >> to tell where to go. >> >> Or, you can issue Createdb command, which is embedded pgxc_ctl command. >> Createdb will chose one of the available coordinators and go there. >> >> Regards; >> --- >> Koichi Suzuki >> >> 2014/03/06 14:16、Juned Khan <jkh...@gm...> のメール: >> >> Hi Lin , >> >> Still its not working, same issue >> >> PGXC createdb astpp -p 20004 >>> createdb: could not connect to database template1: could not connect to >>> server: No such file or directory >>> Is the server running locally and accepting >>> connections on Unix domain socket "/tmp/.s.PGSQL.20004"? >>> PGXC >>> >> >> >> >> >> On Wed, Mar 5, 2014 at 9:01 PM, Lin Wang <lin...@gm...> wrote: >> >>> I think you need point out one port of the coordinators when you >>> create a database, for example as below: >>> >>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 >>> createdb: could not connect to database template1: could not connect to >>> server: no that file or folder >>> Is the server running locally and accepting >>> connections on Unix domain socket "/tmp/.s.PGSQL.5432"? >>> >>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 -p >>> 5300 >>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/psql -d postgres >>> -p 5300 -c "\l" >>> List of databases >>> Name | Owner | Encoding | Collate | Ctype | Access >>> privileges >>> >>> -----------+-------+----------+-------------+-------------+------------------- >>> db1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | >>> postgres | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | >>> template0 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln >>> + >>> | | | | | wln=CTc/wln >>> template1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln >>> + >>> | | | | | wln=CTc/wln >>> (4 rows) >>> >>> >>> Good Luck >>> --------- >>> waln >>> >>> >>> 2014-03-05 22:11 GMT+08:00 Juned Khan <jkh...@gm...>: >>> >>>> Hi All, >>>> >>>> Since last few days i am trying to setup postgre-xc with 3 local >>>> systems. >>>> I have done with basic setup, but having issue with database creation. >>>> >>>> Below is the output of monitor all >>>> >>>> PGXC monitor all >>>>> Running: gtm master >>>>> Running: coordinator master coord1 >>>>> Running: coordinator master coord2 >>>>> Running: datanode master datanode1 >>>>> Running: datanode master datanode2 >>>>> >>>> >>>> But when i am trying to create database its giving me below error. >>>> >>>> PGXC createdb astpp; >>>>> createdb: could not connect to database template1: could not connect >>>>> to server: No such file or directory >>>>> Is the server running locally and accepting >>>>> connections on Unix domain socket "/tmp/.s.PGSQL.5432"? >>>>> PGXC >>>>> >>>> >>>> I am just one step away to done with my postgre-xc setup. >>>> Please suggest me, how to get it fixed . >>>> >>>> >>>> >>>> -- >>>> Thanks, >>>> Juned Khan >>>> iNextrix Technologies Pvt Ltd. >>>> www.inextrix.com >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> Subversion Kills Productivity. Get off Subversion & Make the Move to >>>> Perforce. >>>> With Perforce, you get hassle-free workflows. Merge that actually works. >>>> Faster operations. Version large binaries. Built-in WAN optimization >>>> and the >>>> freedom to use Git, Perforce or both. Make the move to Perforce. >>>> >>>> http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk >>>> _______________________________________________ >>>> Postgres-xc-general mailing list >>>> Pos...@li... >>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >>>> >>>> >>> >> >> >> -- >> Thanks, >> Juned Khan >> iNextrix Technologies Pvt Ltd. >> www.inextrix.com >> ------------------------------------------------------------------------------ >> Subversion Kills Productivity. Get off Subversion & Make the Move to >> Perforce. >> With Perforce, you get hassle-free workflows. Merge that actually works. >> Faster operations. Version large binaries. Built-in WAN optimization and >> the >> freedom to use Git, Perforce or both. Make the move to Perforce. >> >> http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk_______________________________________________ >> Postgres-xc-general mailing list >> Pos...@li... >> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >> >> >> > > > -- > Thanks, > Juned Khan > iNextrix Technologies Pvt Ltd. > www.inextrix.com > > > -- Thanks, Juned Khan iNextrix Technologies Pvt Ltd. www.inextrix.com |
|
From: Koichi S. <koi...@gm...> - 2014-03-06 06:52:07
|
Please specify "create database", not "createdb". createdb is a shortcut command so you will get an error message. Regards; --- Koichi Suzuki 2014-03-06 14:55 GMT+09:00 Juned Khan <jkh...@gm...>: > Hi Koichi, > > My install directory is /home/postgres/ > >> [postgres@localhost ~]$ pgxc_ctl --configuration >> /home/postgres/pgxc_ctl/pgxc_ctl.ctl >> Installing pgxc_ctl_bash script as /home/postgres/pgxc_ctl/pgxc_ctl_bash. >> Installing pgxc_ctl_bash script as /home/postgres/pgxc_ctl/pgxc_ctl_bash. >> Reading configuration using /home/postgres/pgxc_ctl/pgxc_ctl_bash --home >> /home/postgres/pgxc_ctl --configuration /home/postgres/pgxc_ctl/pgxc_ctl.ctl > > > However i am able to connect using psql > >> PGXC psql -p 20004 -h node2 >> psql (PGXC 1.1, based on PG 9.2.4) >> Type "help" for help. >> >> postgres=# createdb koichi > > > but database is not being created. >> >> PGXC psql -p 20004 -h node2 -d koichi >> psql: FATAL: database "koichi" does not exist > > > what could be the problem ? > > > > On Thu, Mar 6, 2014 at 11:14 AM, 鈴木 幸市 <ko...@in...> wrote: >> >> You should not use createdb from postgrereSQL. What is your installation >> target of PGXC? >> >> You can also login to the database using psql and issue create database >> command. >> >> Regards; >> --- >> Koichi Suzuki >> >> 2014/03/06 14:30、Juned Khan <jkh...@gm...> のメール: >> >> Hi Koichi, >> >> Specified port and host but now getting below error: >> >>> PGXC createdb koichi -h node2 -p 20004 >>> createdb: database creation failed: ERROR: Failed to get pooled >>> connections >>> PGXC >> >> >> And which createdb command i should use which will select coordinator >> automatically. >> >>> [root@localhost ~]# find / -name createdb >>> /usr/src/postgres-xc/src/bin/scripts/createdb >>> /usr/local/pgsql/bin/createdb >>> /usr/local/bin/createdb >> >> >> Please suggest. >> >> >> >> >> On Thu, Mar 6, 2014 at 10:50 AM, 鈴木 幸市 <ko...@in...> wrote: >>> >>> Is your coordinator running locally? You may have to specify -h option >>> to tell where to go. >>> >>> Or, you can issue Createdb command, which is embedded pgxc_ctl command. >>> Createdb will chose one of the available coordinators and go there. >>> >>> Regards; >>> --- >>> Koichi Suzuki >>> >>> 2014/03/06 14:16、Juned Khan <jkh...@gm...> のメール: >>> >>> Hi Lin , >>> >>> Still its not working, same issue >>> >>>> PGXC createdb astpp -p 20004 >>>> createdb: could not connect to database template1: could not connect to >>>> server: No such file or directory >>>> Is the server running locally and accepting >>>> connections on Unix domain socket "/tmp/.s.PGSQL.20004"? >>>> PGXC >>> >>> >>> >>> >>> >>> On Wed, Mar 5, 2014 at 9:01 PM, Lin Wang <lin...@gm...> wrote: >>>> >>>> I think you need point out one port of the coordinators when you create >>>> a database, for example as below: >>>> >>>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 >>>> createdb: could not connect to database template1: could not connect to >>>> server: no that file or folder >>>> Is the server running locally and accepting >>>> connections on Unix domain socket "/tmp/.s.PGSQL.5432"? >>>> >>>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 -p >>>> 5300 >>>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/psql -d postgres -p >>>> 5300 -c "\l" >>>> List of databases >>>> Name | Owner | Encoding | Collate | Ctype | Access >>>> privileges >>>> >>>> -----------+-------+----------+-------------+-------------+------------------- >>>> db1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | >>>> postgres | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | >>>> template0 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln >>>> + >>>> | | | | | wln=CTc/wln >>>> template1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln >>>> + >>>> | | | | | wln=CTc/wln >>>> (4 rows) >>>> >>>> >>>> Good Luck >>>> --------- >>>> waln >>>> >>>> >>>> 2014-03-05 22:11 GMT+08:00 Juned Khan <jkh...@gm...>: >>>>> >>>>> Hi All, >>>>> >>>>> Since last few days i am trying to setup postgre-xc with 3 local >>>>> systems. >>>>> I have done with basic setup, but having issue with database creation. >>>>> >>>>> Below is the output of monitor all >>>>> >>>>>> PGXC monitor all >>>>>> Running: gtm master >>>>>> Running: coordinator master coord1 >>>>>> Running: coordinator master coord2 >>>>>> Running: datanode master datanode1 >>>>>> Running: datanode master datanode2 >>>>> >>>>> >>>>> But when i am trying to create database its giving me below error. >>>>> >>>>>> PGXC createdb astpp; >>>>>> createdb: could not connect to database template1: could not connect >>>>>> to server: No such file or directory >>>>>> Is the server running locally and accepting >>>>>> connections on Unix domain socket "/tmp/.s.PGSQL.5432"? >>>>>> PGXC >>>>> >>>>> >>>>> I am just one step away to done with my postgre-xc setup. >>>>> Please suggest me, how to get it fixed . >>>>> >>>>> >>>>> >>>>> -- >>>>> Thanks, >>>>> Juned Khan >>>>> iNextrix Technologies Pvt Ltd. >>>>> www.inextrix.com >>>>> >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> Subversion Kills Productivity. Get off Subversion & Make the Move to >>>>> Perforce. >>>>> With Perforce, you get hassle-free workflows. Merge that actually >>>>> works. >>>>> Faster operations. Version large binaries. Built-in WAN optimization >>>>> and the >>>>> freedom to use Git, Perforce or both. Make the move to Perforce. >>>>> >>>>> http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk >>>>> _______________________________________________ >>>>> Postgres-xc-general mailing list >>>>> Pos...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >>>>> >>>> >>> >>> >>> >>> -- >>> Thanks, >>> Juned Khan >>> iNextrix Technologies Pvt Ltd. >>> www.inextrix.com >>> >>> ------------------------------------------------------------------------------ >>> Subversion Kills Productivity. Get off Subversion & Make the Move to >>> Perforce. >>> With Perforce, you get hassle-free workflows. Merge that actually works. >>> Faster operations. Version large binaries. Built-in WAN optimization and >>> the >>> freedom to use Git, Perforce or both. Make the move to Perforce. >>> >>> http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk_______________________________________________ >>> Postgres-xc-general mailing list >>> Pos...@li... >>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >>> >>> >> >> >> >> -- >> Thanks, >> Juned Khan >> iNextrix Technologies Pvt Ltd. >> www.inextrix.com >> >> > > > > -- > Thanks, > Juned Khan > iNextrix Technologies Pvt Ltd. > www.inextrix.com > > ------------------------------------------------------------------------------ > Subversion Kills Productivity. Get off Subversion & Make the Move to > Perforce. > With Perforce, you get hassle-free workflows. Merge that actually works. > Faster operations. Version large binaries. Built-in WAN optimization and > the > freedom to use Git, Perforce or both. Make the move to Perforce. > http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk > _______________________________________________ > Postgres-xc-general mailing list > Pos...@li... > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general > |
|
From: Koichi S. <koi...@gm...> - 2014-03-06 06:59:54
|
Please check the following steps: 1) cd to your postgres-xc source directory (at the top) 2) ./configure --prefix=/usr/local/pgsql/include/server/pgxc --enable-debug # this is a good practice to enable this. 3) make 4) make install 5) make sure your pgxc binary went to the directory specified in --prefix option 6) pgxc_ctl --configure (your configuration file) 7) deploy all # invoke within pgxc_ctl You should give write privilege 8) Meke sure that all the binaries are installed in all the target servers. which commandname will show you what binary really runs as commandname command 9) init all # invoke within pgxc_ctl 10) Createdb dbname #invoke within pgxc_ctl, be sure to capitalize the first letter. Please make sure that you've given appropriate privilege to xc installation directory and each database installation directory, specified by gtmMasterDir, cordMasterDirs and DatanodeMasterDirs in each target server respectively. Regards; --- Koichi Suzuki 2014-03-06 14:44 GMT+09:00 鈴木 幸市 <ko...@in...>: > You should not use createdb from postgrereSQL. What is your installation > target of PGXC? > > You can also login to the database using psql and issue create database > command. > > Regards; > --- > Koichi Suzuki > > 2014/03/06 14:30、Juned Khan <jkh...@gm...> のメール: > > Hi Koichi, > > Specified port and host but now getting below error: > >> PGXC createdb koichi -h node2 -p 20004 >> createdb: database creation failed: ERROR: Failed to get pooled >> connections >> PGXC > > > And which createdb command i should use which will select coordinator > automatically. > >> [root@localhost ~]# find / -name createdb >> /usr/src/postgres-xc/src/bin/scripts/createdb >> /usr/local/pgsql/bin/createdb >> /usr/local/bin/createdb > > > Please suggest. > > > > > On Thu, Mar 6, 2014 at 10:50 AM, 鈴木 幸市 <ko...@in...> wrote: >> >> Is your coordinator running locally? You may have to specify -h option >> to tell where to go. >> >> Or, you can issue Createdb command, which is embedded pgxc_ctl command. >> Createdb will chose one of the available coordinators and go there. >> >> Regards; >> --- >> Koichi Suzuki >> >> 2014/03/06 14:16、Juned Khan <jkh...@gm...> のメール: >> >> Hi Lin , >> >> Still its not working, same issue >> >>> PGXC createdb astpp -p 20004 >>> createdb: could not connect to database template1: could not connect to >>> server: No such file or directory >>> Is the server running locally and accepting >>> connections on Unix domain socket "/tmp/.s.PGSQL.20004"? >>> PGXC >> >> >> >> >> >> On Wed, Mar 5, 2014 at 9:01 PM, Lin Wang <lin...@gm...> wrote: >>> >>> I think you need point out one port of the coordinators when you create a >>> database, for example as below: >>> >>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 >>> createdb: could not connect to database template1: could not connect to >>> server: no that file or folder >>> Is the server running locally and accepting >>> connections on Unix domain socket "/tmp/.s.PGSQL.5432"? >>> >>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 -p 5300 >>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/psql -d postgres -p >>> 5300 -c "\l" >>> List of databases >>> Name | Owner | Encoding | Collate | Ctype | Access >>> privileges >>> >>> -----------+-------+----------+-------------+-------------+------------------- >>> db1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | >>> postgres | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | >>> template0 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln >>> + >>> | | | | | wln=CTc/wln >>> template1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln >>> + >>> | | | | | wln=CTc/wln >>> (4 rows) >>> >>> >>> Good Luck >>> --------- >>> waln >>> >>> >>> 2014-03-05 22:11 GMT+08:00 Juned Khan <jkh...@gm...>: >>>> >>>> Hi All, >>>> >>>> Since last few days i am trying to setup postgre-xc with 3 local >>>> systems. >>>> I have done with basic setup, but having issue with database creation. >>>> >>>> Below is the output of monitor all >>>> >>>>> PGXC monitor all >>>>> Running: gtm master >>>>> Running: coordinator master coord1 >>>>> Running: coordinator master coord2 >>>>> Running: datanode master datanode1 >>>>> Running: datanode master datanode2 >>>> >>>> >>>> But when i am trying to create database its giving me below error. >>>> >>>>> PGXC createdb astpp; >>>>> createdb: could not connect to database template1: could not connect to >>>>> server: No such file or directory >>>>> Is the server running locally and accepting >>>>> connections on Unix domain socket "/tmp/.s.PGSQL.5432"? >>>>> PGXC >>>> >>>> >>>> I am just one step away to done with my postgre-xc setup. >>>> Please suggest me, how to get it fixed . >>>> >>>> >>>> >>>> -- >>>> Thanks, >>>> Juned Khan >>>> iNextrix Technologies Pvt Ltd. >>>> www.inextrix.com >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> Subversion Kills Productivity. Get off Subversion & Make the Move to >>>> Perforce. >>>> With Perforce, you get hassle-free workflows. Merge that actually works. >>>> Faster operations. Version large binaries. Built-in WAN optimization >>>> and the >>>> freedom to use Git, Perforce or both. Make the move to Perforce. >>>> >>>> http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk >>>> _______________________________________________ >>>> Postgres-xc-general mailing list >>>> Pos...@li... >>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >>>> >>> >> >> >> >> -- >> Thanks, >> Juned Khan >> iNextrix Technologies Pvt Ltd. >> www.inextrix.com >> >> ------------------------------------------------------------------------------ >> Subversion Kills Productivity. Get off Subversion & Make the Move to >> Perforce. >> With Perforce, you get hassle-free workflows. Merge that actually works. >> Faster operations. Version large binaries. Built-in WAN optimization and >> the >> freedom to use Git, Perforce or both. Make the move to Perforce. >> >> http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk_______________________________________________ >> Postgres-xc-general mailing list >> Pos...@li... >> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >> >> > > > > -- > Thanks, > Juned Khan > iNextrix Technologies Pvt Ltd. > www.inextrix.com > > > > ------------------------------------------------------------------------------ > Subversion Kills Productivity. Get off Subversion & Make the Move to > Perforce. > With Perforce, you get hassle-free workflows. Merge that actually works. > Faster operations. Version large binaries. Built-in WAN optimization and > the > freedom to use Git, Perforce or both. Make the move to Perforce. > http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk > _______________________________________________ > Postgres-xc-general mailing list > Pos...@li... > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general > |
|
From: Juned K. <jkh...@gm...> - 2014-03-06 07:13:59
|
Hi Koichi, create database command is not working infact Createdb is worked but in that case error is somewhat changed (Failed to get pooled connections ) PGXC Createdb koichi; > Selected coord1. > createdb: database creation failed: ERROR: Failed to get pooled > connections > PGXC > still i need to do reinstall or this error is not related to configuration ? If yes then i will reinstall it quickly on all servers. On Thu, Mar 6, 2014 at 12:29 PM, Koichi Suzuki <koi...@gm...>wrote: > Please check the following steps: > > 1) cd to your postgres-xc source directory (at the top) > 2) ./configure --prefix=/usr/local/pgsql/include/server/pgxc > --enable-debug # this is a good practice to enable this. > 3) make > 4) make install > 5) make sure your pgxc binary went to the directory specified in --prefix > option > 6) pgxc_ctl --configure (your configuration file) > 7) deploy all # invoke within pgxc_ctl You should give write privilege > 8) Meke sure that all the binaries are installed in all the target > servers. which commandname will show you what binary really runs as > commandname command > 9) init all # invoke within pgxc_ctl > 10) Createdb dbname #invoke within pgxc_ctl, be sure to capitalize the > first letter. > > Please make sure that you've given appropriate privilege to xc > installation directory and each database installation directory, > specified by gtmMasterDir, cordMasterDirs and DatanodeMasterDirs in > each target server respectively. > > Regards; > --- > Koichi Suzuki > > > 2014-03-06 14:44 GMT+09:00 鈴木 幸市 <ko...@in...>: > > You should not use createdb from postgrereSQL. What is your > installation > > target of PGXC? > > > > You can also login to the database using psql and issue create database > > command. > > > > Regards; > > --- > > Koichi Suzuki > > > > 2014/03/06 14:30、Juned Khan <jkh...@gm...> のメール: > > > > Hi Koichi, > > > > Specified port and host but now getting below error: > > > >> PGXC createdb koichi -h node2 -p 20004 > >> createdb: database creation failed: ERROR: Failed to get pooled > >> connections > >> PGXC > > > > > > And which createdb command i should use which will select coordinator > > automatically. > > > >> [root@localhost ~]# find / -name createdb > >> /usr/src/postgres-xc/src/bin/scripts/createdb > >> /usr/local/pgsql/bin/createdb > >> /usr/local/bin/createdb > > > > > > Please suggest. > > > > > > > > > > On Thu, Mar 6, 2014 at 10:50 AM, 鈴木 幸市 <ko...@in...> wrote: > >> > >> Is your coordinator running locally? You may have to specify -h option > >> to tell where to go. > >> > >> Or, you can issue Createdb command, which is embedded pgxc_ctl command. > >> Createdb will chose one of the available coordinators and go there. > >> > >> Regards; > >> --- > >> Koichi Suzuki > >> > >> 2014/03/06 14:16、Juned Khan <jkh...@gm...> のメール: > >> > >> Hi Lin , > >> > >> Still its not working, same issue > >> > >>> PGXC createdb astpp -p 20004 > >>> createdb: could not connect to database template1: could not connect to > >>> server: No such file or directory > >>> Is the server running locally and accepting > >>> connections on Unix domain socket "/tmp/.s.PGSQL.20004"? > >>> PGXC > >> > >> > >> > >> > >> > >> On Wed, Mar 5, 2014 at 9:01 PM, Lin Wang <lin...@gm...> wrote: > >>> > >>> I think you need point out one port of the coordinators when you > create a > >>> database, for example as below: > >>> > >>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 > >>> createdb: could not connect to database template1: could not connect to > >>> server: no that file or folder > >>> Is the server running locally and accepting > >>> connections on Unix domain socket "/tmp/.s.PGSQL.5432"? > >>> > >>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 -p > 5300 > >>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/psql -d postgres > -p > >>> 5300 -c "\l" > >>> List of databases > >>> Name | Owner | Encoding | Collate | Ctype | Access > >>> privileges > >>> > >>> > -----------+-------+----------+-------------+-------------+------------------- > >>> db1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | > >>> postgres | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | > >>> template0 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln > >>> + > >>> | | | | | wln=CTc/wln > >>> template1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln > >>> + > >>> | | | | | wln=CTc/wln > >>> (4 rows) > >>> > >>> > >>> Good Luck > >>> --------- > >>> waln > >>> > >>> > >>> 2014-03-05 22:11 GMT+08:00 Juned Khan <jkh...@gm...>: > >>>> > >>>> Hi All, > >>>> > >>>> Since last few days i am trying to setup postgre-xc with 3 local > >>>> systems. > >>>> I have done with basic setup, but having issue with database creation. > >>>> > >>>> Below is the output of monitor all > >>>> > >>>>> PGXC monitor all > >>>>> Running: gtm master > >>>>> Running: coordinator master coord1 > >>>>> Running: coordinator master coord2 > >>>>> Running: datanode master datanode1 > >>>>> Running: datanode master datanode2 > >>>> > >>>> > >>>> But when i am trying to create database its giving me below error. > >>>> > >>>>> PGXC createdb astpp; > >>>>> createdb: could not connect to database template1: could not connect > to > >>>>> server: No such file or directory > >>>>> Is the server running locally and accepting > >>>>> connections on Unix domain socket "/tmp/.s.PGSQL.5432"? > >>>>> PGXC > >>>> > >>>> > >>>> I am just one step away to done with my postgre-xc setup. > >>>> Please suggest me, how to get it fixed . > >>>> > >>>> > >>>> > >>>> -- > >>>> Thanks, > >>>> Juned Khan > >>>> iNextrix Technologies Pvt Ltd. > >>>> www.inextrix.com > >>>> > >>>> > >>>> > ------------------------------------------------------------------------------ > >>>> Subversion Kills Productivity. Get off Subversion & Make the Move to > >>>> Perforce. > >>>> With Perforce, you get hassle-free workflows. Merge that actually > works. > >>>> Faster operations. Version large binaries. Built-in WAN optimization > >>>> and the > >>>> freedom to use Git, Perforce or both. Make the move to Perforce. > >>>> > >>>> > http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk > >>>> _______________________________________________ > >>>> Postgres-xc-general mailing list > >>>> Pos...@li... > >>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general > >>>> > >>> > >> > >> > >> > >> -- > >> Thanks, > >> Juned Khan > >> iNextrix Technologies Pvt Ltd. > >> www.inextrix.com > >> > >> > ------------------------------------------------------------------------------ > >> Subversion Kills Productivity. Get off Subversion & Make the Move to > >> Perforce. > >> With Perforce, you get hassle-free workflows. Merge that actually works. > >> Faster operations. Version large binaries. Built-in WAN optimization > and > >> the > >> freedom to use Git, Perforce or both. Make the move to Perforce. > >> > >> > http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk_______________________________________________ > >> Postgres-xc-general mailing list > >> Pos...@li... > >> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general > >> > >> > > > > > > > > -- > > Thanks, > > Juned Khan > > iNextrix Technologies Pvt Ltd. > > www.inextrix.com > > > > > > > > > ------------------------------------------------------------------------------ > > Subversion Kills Productivity. Get off Subversion & Make the Move to > > Perforce. > > With Perforce, you get hassle-free workflows. Merge that actually works. > > Faster operations. Version large binaries. Built-in WAN optimization and > > the > > freedom to use Git, Perforce or both. Make the move to Perforce. > > > http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk > > _______________________________________________ > > Postgres-xc-general mailing list > > Pos...@li... > > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general > > > -- Thanks, Juned Khan iNextrix Technologies Pvt Ltd. www.inextrix.com |
|
From: Masataka S. <pg...@gm...> - 2014-03-06 07:31:51
|
On 6 March 2014 16:13, Juned Khan <jkh...@gm...> wrote: > Hi Koichi, > > create database command is not working infact Createdb is worked > but in that case error is somewhat changed (Failed to get pooled connections > ) > >> PGXC Createdb koichi; >> Selected coord1. >> >> createdb: database creation failed: ERROR: Failed to get pooled >> connections >> PGXC > Did you customize coordPgHbaEntries and datanodePgHbaEntries parameters in pgxc_ctl.conf (or your configuration file) to suite your environment? The coordinator need to be privileged to access to other nodes (coordinators and datanodes) without authorization. Unfortunately default pgxc_ctl.conf is just a sample and it is not work well without customize. So you need to glance over the configuration to ensure that the parameters are suitable for you. Regards. > > still i need to do reinstall or this error is not related to configuration ? > > If yes then i will reinstall it quickly on all servers. > > > > > On Thu, Mar 6, 2014 at 12:29 PM, Koichi Suzuki <koi...@gm...> > wrote: >> >> Please check the following steps: >> >> 1) cd to your postgres-xc source directory (at the top) >> 2) ./configure --prefix=/usr/local/pgsql/include/server/pgxc >> --enable-debug # this is a good practice to enable this. >> 3) make >> 4) make install >> 5) make sure your pgxc binary went to the directory specified in --prefix >> option >> 6) pgxc_ctl --configure (your configuration file) >> 7) deploy all # invoke within pgxc_ctl You should give write privilege >> 8) Meke sure that all the binaries are installed in all the target >> servers. which commandname will show you what binary really runs as >> commandname command >> 9) init all # invoke within pgxc_ctl >> 10) Createdb dbname #invoke within pgxc_ctl, be sure to capitalize the >> first letter. >> >> Please make sure that you've given appropriate privilege to xc >> installation directory and each database installation directory, >> specified by gtmMasterDir, cordMasterDirs and DatanodeMasterDirs in >> each target server respectively. >> >> Regards; >> --- >> Koichi Suzuki >> >> >> 2014-03-06 14:44 GMT+09:00 鈴木 幸市 <ko...@in...>: >> > You should not use createdb from postgrereSQL. What is your >> > installation >> > target of PGXC? >> > >> > You can also login to the database using psql and issue create database >> > command. >> > >> > Regards; >> > --- >> > Koichi Suzuki >> > >> > 2014/03/06 14:30、Juned Khan <jkh...@gm...> のメール: >> > >> > Hi Koichi, >> > >> > Specified port and host but now getting below error: >> > >> >> PGXC createdb koichi -h node2 -p 20004 >> >> createdb: database creation failed: ERROR: Failed to get pooled >> >> connections >> >> PGXC >> > >> > >> > And which createdb command i should use which will select coordinator >> > automatically. >> > >> >> [root@localhost ~]# find / -name createdb >> >> /usr/src/postgres-xc/src/bin/scripts/createdb >> >> /usr/local/pgsql/bin/createdb >> >> /usr/local/bin/createdb >> > >> > >> > Please suggest. >> > >> > >> > >> > >> > On Thu, Mar 6, 2014 at 10:50 AM, 鈴木 幸市 <ko...@in...> wrote: >> >> >> >> Is your coordinator running locally? You may have to specify -h >> >> option >> >> to tell where to go. >> >> >> >> Or, you can issue Createdb command, which is embedded pgxc_ctl command. >> >> Createdb will chose one of the available coordinators and go there. >> >> >> >> Regards; >> >> --- >> >> Koichi Suzuki >> >> >> >> 2014/03/06 14:16、Juned Khan <jkh...@gm...> のメール: >> >> >> >> Hi Lin , >> >> >> >> Still its not working, same issue >> >> >> >>> PGXC createdb astpp -p 20004 >> >>> createdb: could not connect to database template1: could not connect >> >>> to >> >>> server: No such file or directory >> >>> Is the server running locally and accepting >> >>> connections on Unix domain socket "/tmp/.s.PGSQL.20004"? >> >>> PGXC >> >> >> >> >> >> >> >> >> >> >> >> On Wed, Mar 5, 2014 at 9:01 PM, Lin Wang <lin...@gm...> wrote: >> >>> >> >>> I think you need point out one port of the coordinators when you >> >>> create a >> >>> database, for example as below: >> >>> >> >>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 >> >>> createdb: could not connect to database template1: could not connect >> >>> to >> >>> server: no that file or folder >> >>> Is the server running locally and accepting >> >>> connections on Unix domain socket "/tmp/.s.PGSQL.5432"? >> >>> >> >>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 -p >> >>> 5300 >> >>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/psql -d postgres >> >>> -p >> >>> 5300 -c "\l" >> >>> List of databases >> >>> Name | Owner | Encoding | Collate | Ctype | Access >> >>> privileges >> >>> >> >>> >> >>> -----------+-------+----------+-------------+-------------+------------------- >> >>> db1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | >> >>> postgres | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | >> >>> template0 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln >> >>> + >> >>> | | | | | >> >>> wln=CTc/wln >> >>> template1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln >> >>> + >> >>> | | | | | >> >>> wln=CTc/wln >> >>> (4 rows) >> >>> >> >>> >> >>> Good Luck >> >>> --------- >> >>> waln >> >>> >> >>> >> >>> 2014-03-05 22:11 GMT+08:00 Juned Khan <jkh...@gm...>: >> >>>> >> >>>> Hi All, >> >>>> >> >>>> Since last few days i am trying to setup postgre-xc with 3 local >> >>>> systems. >> >>>> I have done with basic setup, but having issue with database >> >>>> creation. >> >>>> >> >>>> Below is the output of monitor all >> >>>> >> >>>>> PGXC monitor all >> >>>>> Running: gtm master >> >>>>> Running: coordinator master coord1 >> >>>>> Running: coordinator master coord2 >> >>>>> Running: datanode master datanode1 >> >>>>> Running: datanode master datanode2 >> >>>> >> >>>> >> >>>> But when i am trying to create database its giving me below error. >> >>>> >> >>>>> PGXC createdb astpp; >> >>>>> createdb: could not connect to database template1: could not connect >> >>>>> to >> >>>>> server: No such file or directory >> >>>>> Is the server running locally and accepting >> >>>>> connections on Unix domain socket "/tmp/.s.PGSQL.5432"? >> >>>>> PGXC >> >>>> >> >>>> >> >>>> I am just one step away to done with my postgre-xc setup. >> >>>> Please suggest me, how to get it fixed . >> >>>> >> >>>> >> >>>> >> >>>> -- >> >>>> Thanks, >> >>>> Juned Khan >> >>>> iNextrix Technologies Pvt Ltd. >> >>>> www.inextrix.com >> >>>> >> >>>> >> >>>> >> >>>> ------------------------------------------------------------------------------ >> >>>> Subversion Kills Productivity. Get off Subversion & Make the Move to >> >>>> Perforce. >> >>>> With Perforce, you get hassle-free workflows. Merge that actually >> >>>> works. >> >>>> Faster operations. Version large binaries. Built-in WAN optimization >> >>>> and the >> >>>> freedom to use Git, Perforce or both. Make the move to Perforce. >> >>>> >> >>>> >> >>>> http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk >> >>>> _______________________________________________ >> >>>> Postgres-xc-general mailing list >> >>>> Pos...@li... >> >>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >> >>>> >> >>> >> >> >> >> >> >> >> >> -- >> >> Thanks, >> >> Juned Khan >> >> iNextrix Technologies Pvt Ltd. >> >> www.inextrix.com >> >> >> >> >> >> ------------------------------------------------------------------------------ >> >> Subversion Kills Productivity. Get off Subversion & Make the Move to >> >> Perforce. >> >> With Perforce, you get hassle-free workflows. Merge that actually >> >> works. >> >> Faster operations. Version large binaries. Built-in WAN optimization >> >> and >> >> the >> >> freedom to use Git, Perforce or both. Make the move to Perforce. >> >> >> >> >> >> http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk_______________________________________________ >> >> Postgres-xc-general mailing list >> >> Pos...@li... >> >> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >> >> >> >> >> > >> > >> > >> > -- >> > Thanks, >> > Juned Khan >> > iNextrix Technologies Pvt Ltd. >> > www.inextrix.com >> > >> > >> > >> > >> > ------------------------------------------------------------------------------ >> > Subversion Kills Productivity. Get off Subversion & Make the Move to >> > Perforce. >> > With Perforce, you get hassle-free workflows. Merge that actually works. >> > Faster operations. Version large binaries. Built-in WAN optimization >> > and >> > the >> > freedom to use Git, Perforce or both. Make the move to Perforce. >> > >> > http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk >> > _______________________________________________ >> > Postgres-xc-general mailing list >> > Pos...@li... >> > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >> > > > > > > -- > Thanks, > Juned Khan > iNextrix Technologies Pvt Ltd. > www.inextrix.com > > ------------------------------------------------------------------------------ > Subversion Kills Productivity. Get off Subversion & Make the Move to > Perforce. > With Perforce, you get hassle-free workflows. Merge that actually works. > Faster operations. Version large binaries. Built-in WAN optimization and > the > freedom to use Git, Perforce or both. Make the move to Perforce. > http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk > _______________________________________________ > Postgres-xc-general mailing list > Pos...@li... > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general > |
|
From: Juned K. <jkh...@gm...> - 2014-03-06 07:59:23
|
Hi Mastaka, You hint worked for me. default setting was fine for my environment but i set static IP there and its worked like coordPgHbaEntries=(192.168.1.72/32 192.168.1.73/32 ) datanodePgHbaEntries=(192.168.1.72/32 192.168.1.73/32) thank you very much. On Thu, Mar 6, 2014 at 1:01 PM, Masataka Saito <pg...@gm...> wrote: > On 6 March 2014 16:13, Juned Khan <jkh...@gm...> wrote: > > Hi Koichi, > > > > create database command is not working infact Createdb is worked > > but in that case error is somewhat changed (Failed to get pooled > connections > > ) > > > >> PGXC Createdb koichi; > >> Selected coord1. > >> > >> createdb: database creation failed: ERROR: Failed to get pooled > >> connections > >> PGXC > > > > Did you customize coordPgHbaEntries and datanodePgHbaEntries > parameters in pgxc_ctl.conf (or your configuration file) to suite your > environment? The coordinator need to be privileged to access to other > nodes (coordinators and datanodes) without authorization. > > Unfortunately default pgxc_ctl.conf is just a sample and it is not > work well without customize. So you need to glance over the > configuration to ensure that the parameters are suitable for you. > > Regards. > > > > > still i need to do reinstall or this error is not related to > configuration ? > > > > If yes then i will reinstall it quickly on all servers. > > > > > > > > > > On Thu, Mar 6, 2014 at 12:29 PM, Koichi Suzuki <koi...@gm...> > > wrote: > >> > >> Please check the following steps: > >> > >> 1) cd to your postgres-xc source directory (at the top) > >> 2) ./configure --prefix=/usr/local/pgsql/include/server/pgxc > >> --enable-debug # this is a good practice to enable this. > >> 3) make > >> 4) make install > >> 5) make sure your pgxc binary went to the directory specified in > --prefix > >> option > >> 6) pgxc_ctl --configure (your configuration file) > >> 7) deploy all # invoke within pgxc_ctl You should give write privilege > >> 8) Meke sure that all the binaries are installed in all the target > >> servers. which commandname will show you what binary really runs as > >> commandname command > >> 9) init all # invoke within pgxc_ctl > >> 10) Createdb dbname #invoke within pgxc_ctl, be sure to capitalize the > >> first letter. > >> > >> Please make sure that you've given appropriate privilege to xc > >> installation directory and each database installation directory, > >> specified by gtmMasterDir, cordMasterDirs and DatanodeMasterDirs in > >> each target server respectively. > >> > >> Regards; > >> --- > >> Koichi Suzuki > >> > >> > >> 2014-03-06 14:44 GMT+09:00 鈴木 幸市 <ko...@in...>: > >> > You should not use createdb from postgrereSQL. What is your > >> > installation > >> > target of PGXC? > >> > > >> > You can also login to the database using psql and issue create > database > >> > command. > >> > > >> > Regards; > >> > --- > >> > Koichi Suzuki > >> > > >> > 2014/03/06 14:30、Juned Khan <jkh...@gm...> のメール: > >> > > >> > Hi Koichi, > >> > > >> > Specified port and host but now getting below error: > >> > > >> >> PGXC createdb koichi -h node2 -p 20004 > >> >> createdb: database creation failed: ERROR: Failed to get pooled > >> >> connections > >> >> PGXC > >> > > >> > > >> > And which createdb command i should use which will select coordinator > >> > automatically. > >> > > >> >> [root@localhost ~]# find / -name createdb > >> >> /usr/src/postgres-xc/src/bin/scripts/createdb > >> >> /usr/local/pgsql/bin/createdb > >> >> /usr/local/bin/createdb > >> > > >> > > >> > Please suggest. > >> > > >> > > >> > > >> > > >> > On Thu, Mar 6, 2014 at 10:50 AM, 鈴木 幸市 <ko...@in...> > wrote: > >> >> > >> >> Is your coordinator running locally? You may have to specify -h > >> >> option > >> >> to tell where to go. > >> >> > >> >> Or, you can issue Createdb command, which is embedded pgxc_ctl > command. > >> >> Createdb will chose one of the available coordinators and go there. > >> >> > >> >> Regards; > >> >> --- > >> >> Koichi Suzuki > >> >> > >> >> 2014/03/06 14:16、Juned Khan <jkh...@gm...> のメール: > >> >> > >> >> Hi Lin , > >> >> > >> >> Still its not working, same issue > >> >> > >> >>> PGXC createdb astpp -p 20004 > >> >>> createdb: could not connect to database template1: could not connect > >> >>> to > >> >>> server: No such file or directory > >> >>> Is the server running locally and accepting > >> >>> connections on Unix domain socket "/tmp/.s.PGSQL.20004"? > >> >>> PGXC > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> On Wed, Mar 5, 2014 at 9:01 PM, Lin Wang <lin...@gm...> > wrote: > >> >>> > >> >>> I think you need point out one port of the coordinators when you > >> >>> create a > >> >>> database, for example as below: > >> >>> > >> >>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 > >> >>> createdb: could not connect to database template1: could not connect > >> >>> to > >> >>> server: no that file or folder > >> >>> Is the server running locally and accepting > >> >>> connections on Unix domain socket "/tmp/.s.PGSQL.5432"? > >> >>> > >> >>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 > -p > >> >>> 5300 > >> >>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/psql -d > postgres > >> >>> -p > >> >>> 5300 -c "\l" > >> >>> List of databases > >> >>> Name | Owner | Encoding | Collate | Ctype | Access > >> >>> privileges > >> >>> > >> >>> > >> >>> > -----------+-------+----------+-------------+-------------+------------------- > >> >>> db1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | > >> >>> postgres | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | > >> >>> template0 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln > >> >>> + > >> >>> | | | | | > >> >>> wln=CTc/wln > >> >>> template1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln > >> >>> + > >> >>> | | | | | > >> >>> wln=CTc/wln > >> >>> (4 rows) > >> >>> > >> >>> > >> >>> Good Luck > >> >>> --------- > >> >>> waln > >> >>> > >> >>> > >> >>> 2014-03-05 22:11 GMT+08:00 Juned Khan <jkh...@gm...>: > >> >>>> > >> >>>> Hi All, > >> >>>> > >> >>>> Since last few days i am trying to setup postgre-xc with 3 local > >> >>>> systems. > >> >>>> I have done with basic setup, but having issue with database > >> >>>> creation. > >> >>>> > >> >>>> Below is the output of monitor all > >> >>>> > >> >>>>> PGXC monitor all > >> >>>>> Running: gtm master > >> >>>>> Running: coordinator master coord1 > >> >>>>> Running: coordinator master coord2 > >> >>>>> Running: datanode master datanode1 > >> >>>>> Running: datanode master datanode2 > >> >>>> > >> >>>> > >> >>>> But when i am trying to create database its giving me below error. > >> >>>> > >> >>>>> PGXC createdb astpp; > >> >>>>> createdb: could not connect to database template1: could not > connect > >> >>>>> to > >> >>>>> server: No such file or directory > >> >>>>> Is the server running locally and accepting > >> >>>>> connections on Unix domain socket "/tmp/.s.PGSQL.5432"? > >> >>>>> PGXC > >> >>>> > >> >>>> > >> >>>> I am just one step away to done with my postgre-xc setup. > >> >>>> Please suggest me, how to get it fixed . > >> >>>> > >> >>>> > >> >>>> > >> >>>> -- > >> >>>> Thanks, > >> >>>> Juned Khan > >> >>>> iNextrix Technologies Pvt Ltd. > >> >>>> www.inextrix.com > >> >>>> > >> >>>> > >> >>>> > >> >>>> > ------------------------------------------------------------------------------ > >> >>>> Subversion Kills Productivity. Get off Subversion & Make the Move > to > >> >>>> Perforce. > >> >>>> With Perforce, you get hassle-free workflows. Merge that actually > >> >>>> works. > >> >>>> Faster operations. Version large binaries. Built-in WAN > optimization > >> >>>> and the > >> >>>> freedom to use Git, Perforce or both. Make the move to Perforce. > >> >>>> > >> >>>> > >> >>>> > http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk > >> >>>> _______________________________________________ > >> >>>> Postgres-xc-general mailing list > >> >>>> Pos...@li... > >> >>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general > >> >>>> > >> >>> > >> >> > >> >> > >> >> > >> >> -- > >> >> Thanks, > >> >> Juned Khan > >> >> iNextrix Technologies Pvt Ltd. > >> >> www.inextrix.com > >> >> > >> >> > >> >> > ------------------------------------------------------------------------------ > >> >> Subversion Kills Productivity. Get off Subversion & Make the Move to > >> >> Perforce. > >> >> With Perforce, you get hassle-free workflows. Merge that actually > >> >> works. > >> >> Faster operations. Version large binaries. Built-in WAN optimization > >> >> and > >> >> the > >> >> freedom to use Git, Perforce or both. Make the move to Perforce. > >> >> > >> >> > >> >> > http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk_______________________________________________ > >> >> Postgres-xc-general mailing list > >> >> Pos...@li... > >> >> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general > >> >> > >> >> > >> > > >> > > >> > > >> > -- > >> > Thanks, > >> > Juned Khan > >> > iNextrix Technologies Pvt Ltd. > >> > www.inextrix.com > >> > > >> > > >> > > >> > > >> > > ------------------------------------------------------------------------------ > >> > Subversion Kills Productivity. Get off Subversion & Make the Move to > >> > Perforce. > >> > With Perforce, you get hassle-free workflows. Merge that actually > works. > >> > Faster operations. Version large binaries. Built-in WAN optimization > >> > and > >> > the > >> > freedom to use Git, Perforce or both. Make the move to Perforce. > >> > > >> > > http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk > >> > _______________________________________________ > >> > Postgres-xc-general mailing list > >> > Pos...@li... > >> > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general > >> > > > > > > > > > > > -- > > Thanks, > > Juned Khan > > iNextrix Technologies Pvt Ltd. > > www.inextrix.com > > > > > ------------------------------------------------------------------------------ > > Subversion Kills Productivity. Get off Subversion & Make the Move to > > Perforce. > > With Perforce, you get hassle-free workflows. Merge that actually works. > > Faster operations. Version large binaries. Built-in WAN optimization and > > the > > freedom to use Git, Perforce or both. Make the move to Perforce. > > > http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk > > _______________________________________________ > > Postgres-xc-general mailing list > > Pos...@li... > > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general > > > -- Thanks, Juned Khan iNextrix Technologies Pvt Ltd. www.inextrix.com |