pgbench Connection to database "bench" failed:

From: "Moen, Paul T(dot)" <pmoen(at)nd(dot)gov>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: pgbench Connection to database "bench" failed:
Date: 2014-03-10 21:33:22
Message-ID: CF4396EB.1A896%pmoen@nd.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I am not sure where to ask this question, so sorry if this is the wrong list.

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

I have EnterpriseDB running directly on my Mac Pro 3.5 GHz 6-Core Intel Xeon 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, compiled by i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc. build 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 bench

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 = 477.022437 (including connections establishing)

tps = 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:~ pmoen$ pgbench -U postgres -h 10.33.132.38 -c 8 -j 2 -T 600 -C bench

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 = 165.289919 (including connections establishing)

tps = 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

Browse pgsql-admin by date

  From Date Subject
Next Message Kieren Scott 2014-03-12 15:44:09 data_directory symlinks
Previous Message pgorg_aav 2014-03-10 14:17:46 Re: streaming replication sent location not advancing - feature request?