From: Moen, Paul T. <pmoen@nd.gov>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: pgbench Connection to database "bench" failed:
Date: Mon, 10 Mar 2014 21:33:22 +0000
Message-ID: <CF4396EB.1A896%pmoen@nd.gov> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pmoen@nd.gov
Subject: Re: pgbench Connection to database "bench" failed:
In-Reply-To: <CF4396EB.1A896%pmoen@nd.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox