Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WN7pZ-00052T-Cg for pgsql-admin@arkaria.postgresql.org; Mon, 10 Mar 2014 21:33:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WN7pY-0003yd-PX for pgsql-admin@arkaria.postgresql.org; Mon, 10 Mar 2014 21:33:52 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WN7pX-0003yX-N9 for pgsql-admin@postgresql.org; Mon, 10 Mar 2014 21:33:52 +0000 Received: from irnprt2.itd.nd.gov ([165.234.75.60]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WN7pT-0008Pf-Gz for pgsql-admin@postgresql.org; Mon, 10 Mar 2014 21:33:50 +0000 X-IronPort-AV: E=Sophos;i="4.97,626,1389765600"; d="scan'208,217";a="68968691" Received: from itdexchcas1.itd.nd.gov (HELO itdexchcas1.nd.gov) ([10.2.9.25]) by irnprt2.itd.nd.gov with ESMTP/TLS/AES128-SHA; 10 Mar 2014 16:33:23 -0500 Received: from ITDBISEXCHMBX1.nd.gov ([fe80::d19d:158d:28de:ce7d]) by itdexchcas1.nd.gov ([::1]) with mapi id 14.03.0174.001; Mon, 10 Mar 2014 16:33:23 -0500 From: "Moen, Paul T." To: "pgsql-admin@postgresql.org" Subject: pgbench Connection to database "bench" failed: Thread-Topic: pgbench Connection to database "bench" failed: Thread-Index: AQHPPKhccnS37cpqaEC5joJgxD/kkQ== Date: Mon, 10 Mar 2014 21:33:22 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.3.9.131030 x-originating-ip: [10.33.132.75] Content-Type: multipart/alternative; boundary="_000_CF4396EB1A896pmoenndgov_" MIME-Version: 1.0 X-Pg-Spam-Score: -3.9 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --_000_CF4396EB1A896pmoenndgov_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I am not sure where to ask this question, so sorry if this is the wrong lis= t. I am having connection issues with PostgreSQL 9.3.3 on my Mac Pro vs. a vir= tual machine on the same mac pro. I have EnterpriseDB running directly on my Mac Pro 3.5 GHz 6-Core Intel Xeo= n E5 with 64 GB 1867MHz DDR 3 ram. I also am running a virtual machine of = the same version of Mac OS X and EnterpriseDB on the Mac Pro. The PostgreSQL versions is, PostgreSQL 9.3.3 on x86_64-apple-darwin, compil= ed by i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc. bui= ld 5658) (LLVM build 2336.9.00), 64-bit. I created a bench database in PostgreSQL on both the VM machine, 10.33.132.= 38 and the direct installed Mac Pro 10.33.132.31. createdb -U postgres -h 10.33.132.31 bench createdb -U postgres -h 10.33.132.38 bench I followed the directions on wiki.postgresql.org/wiki/pgbenchtesting guide = under Connections and Contention. I use the Heavy Re-connection (simulates no connection pooling) sample and = it fails miserably on the Mac Pro. pmoen:~ pmoen$ pgbench -U postgres -h 10.33.132.31 -c 8 -j 2 -T 600 -C benc= h Password: starting vacuum...end. Connection to database "bench" failed: could not connect to server: Can't assign requested address Is the server running on host "10.33.132.31" and accepting TCP/IP connections on port ? Client 4 aborted in establishing connection. Connection to database "bench" failed: could not connect to server: Can't assign requested address Is the server running on host "10.33.132.31" and accepting TCP/IP connections on port ? Client 5 aborted in establishing connection. Connection to database "bench" failed: could not connect to server: Can't assign requested address Is the server running on host "10.33.132.31" and accepting TCP/IP connections on port ? Client 6 aborted in establishing connection. Connection to database "bench" failed: could not connect to server: Can't assign requested address Is the server running on host "10.33.132.31" and accepting TCP/IP connections on port ? Client 7 aborted in establishing connection. Connection to database "bench" failed: could not connect to server: Can't assign requested address Is the server running on host "10.33.132.31" and accepting TCP/IP connections on port ? Client 3 aborted in establishing connection. Connection to database "bench" failed: could not connect to server: Can't assign requested address Is the server running on host "10.33.132.31" and accepting TCP/IP connections on port ? Client 0 aborted in establishing connection. Connection to database "bench" failed: could not connect to server: Can't assign requested address Is the server running on host "10.33.132.31" and accepting TCP/IP connections on port ? Client 1 aborted in establishing connection. Connection to database "bench" failed: could not connect to server: Can't assign requested address Is the server running on host "10.33.132.31" and accepting TCP/IP connections on port ? Client 2 aborted in establishing connection. transaction type: TPC-B (sort of) scaling factor: 200 query mode: simple number of clients: 8 number of threads: 2 duration: 600 s number of transactions actually processed: 16352 tps =3D 477.022437 (including connections establishing) tps =3D 2018.412335 (excluding connections establishing) But it works just fine, albeit slow, on the PostgreSQL version in the virtu= al machine that is running in VMWare Fusion on the same Mac Pro. pmoen:~ pmoen$ pgbench -U postgres -h 10.33.132.38 -c 8 -j 2 -T 600 -C benc= h Password: starting vacuum...end. transaction type: TPC-B (sort of) scaling factor: 200 query mode: simple number of clients: 8 number of threads: 2 duration: 600 s number of transactions actually processed: 99174 tps =3D 165.289919 (including connections establishing) tps =3D 541.635056 (excluding connections establishing) Any ideas on where to look or what to change to make it work on the Mac pro= ? Thanks, Paul --_000_CF4396EB1A896pmoenndgov_ Content-Type: text/html; charset="us-ascii" Content-ID: Content-Transfer-Encoding: quoted-printable
I am not sure where to ask this question, so sorry if this is the wrong lis= t.

I am having connection issues with PostgreSQL 9.3.3 on my Mac Pro vs. a vir= tual machine on the same mac pro.  

I have EnterpriseDB running directly on my Mac Pro 3.5 GHz 6-Core Intel Xeo= n E5 with 64 GB 1867MHz DDR 3 ram.  I also am running a virtual machin= e of the same version of Mac OS X and EnterpriseDB on the Mac Pro.

The PostgreSQL versions is, PostgreSQL 9.3.3 on x86_64-apple-darwin, compil= ed by i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc. bui= ld 5658) (LLVM build 2336.9.00), 64-bit.

I created a bench database in PostgreSQL on both the VM machine, 10.33.132.= 38 and the direct installed Mac Pro 10.33.132.31.
createdb -U postgres -= h 10.33.132.31 bench
createdb -U postgres -= h 10.33.132.38 bench

I followed the directions on wiki.postg= resql.org/wiki/pgbenchtesting guide under Connections and Contention.

I use the Heavy Re-connection (simulates no connection pooling) sample and it fails mi= serably on the Mac Pro.

pmoen:~ pmoe= n$ pgbench -U postgres -h 10.33.132.31 -c 8 -j 2 -T 600 -C bench

Password:&nb= sp;

starting vac= uum...end.

Connection t= o database "bench" failed:

could not co= nnect to server: Can't assign requested address

Is the server running = on host "10.33.132.31" and accepting

TCP/IP connections on = port ?

Client 4 abo= rted in establishing connection.

Connection t= o database "bench" failed:

could not co= nnect to server: Can't assign requested address

Is the server running = on host "10.33.132.31" and accepting

TCP/IP connections on = port ?

Client 5 abo= rted in establishing connection.

Connection t= o database "bench" failed:

could not co= nnect to server: Can't assign requested address

Is the server running = on host "10.33.132.31" and accepting

TCP/IP connections on = port ?

Client 6 abo= rted in establishing connection.

Connection t= o database "bench" failed:

could not co= nnect to server: Can't assign requested address

Is the server running = on host "10.33.132.31" and accepting

TCP/IP connections on = port ?

Client 7 abo= rted in establishing connection.

Connection t= o database "bench" failed:

could not co= nnect to server: Can't assign requested address

Is the server running = on host "10.33.132.31" and accepting

TCP/IP connections on = port ?

Client 3 abo= rted in establishing connection.

Connection t= o database "bench" failed:

could not co= nnect to server: Can't assign requested address

Is the server running = on host "10.33.132.31" and accepting

TCP/IP connections on = port ?

Client 0 abo= rted in establishing connection.

Connection t= o database "bench" failed:

could not co= nnect to server: Can't assign requested address

Is the server running = on host "10.33.132.31" and accepting

TCP/IP connections on = port ?

Client 1 abo= rted in establishing connection.

Connection t= o database "bench" failed:

could not co= nnect to server: Can't assign requested address

Is the server running = on host "10.33.132.31" and accepting

TCP/IP connections on = port ?

Client 2 abo= rted in establishing connection.

transaction = type: TPC-B (sort of)

scaling fact= or: 200

query mode: = simple

number of cl= ients: 8

number of th= reads: 2

duration: 60= 0 s

number of tr= ansactions actually processed: 16352

tps =3D 477.= 022437 (including connections establishing)

tps =3D 2018= .412335 (excluding connections establishing)



But it works just fine, albeit slow, on the PostgreSQL version in the = virtual machine that is running in VMWare Fusion on the same Mac Pro.

pmoen:~ pmoe= n$ pgbench -U postgres -h 10.33.132.38 -c 8 -j 2 -T 600 -C bench

Password:&nb= sp;

starting vac= uum...end.

transaction = type: TPC-B (sort of)

scaling fact= or: 200

query mode: = simple

number of cl= ients: 8

number of th= reads: 2

duration: 60= 0 s

number of tr= ansactions actually processed: 99174

tps =3D 165.= 289919 (including connections establishing)

tps =3D 541.= 635056 (excluding connections establishing)


Any ideas on where to look or what to change to m= ake it work on the Mac pro?


Thanks, 


Paul

--_000_CF4396EB1A896pmoenndgov_--