pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedDBT-5 & Postgres 9.0.3
12+ messages / 8 participants
[nested] [flat]
* DBT-5 & Postgres 9.0.3
@ 2011-04-12 07:51 Sethu Prasad <sethuprasad.in@gmail.com>
0 siblings, 1 reply; 12+ messages in thread
From: Sethu Prasad @ 2011-04-12 07:51 UTC (permalink / raw)
To: pgsql-performance
Hi,
Anyone lucky to have dbt5 run for PostgreSQL 9.0.3?!
I am trying on Novell SuSE Linux Enterprise Server 11 SP1 x86_64 with a
virtual machine and bit hard with no success run yet. If you can help me
with any docs will be more of a support.
Regards,
Sethu Prasad
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: DBT-5 & Postgres 9.0.3
@ 2011-05-12 03:22 Robert Haas <robertmhaas@gmail.com>
parent: Sethu Prasad <sethuprasad.in@gmail.com>
0 siblings, 1 reply; 12+ messages in thread
From: Robert Haas @ 2011-05-12 03:22 UTC (permalink / raw)
To: Sethu Prasad <sethuprasad.in@gmail.com>; +Cc: pgsql-performance
On Tue, Apr 12, 2011 at 3:51 AM, Sethu Prasad <sethuprasad.in@gmail.com> wrote:
> Anyone lucky to have dbt5 run for PostgreSQL 9.0.3?!
>
> I am trying on Novell SuSE Linux Enterprise Server 11 SP1 x86_64 with a
> virtual machine and bit hard with no success run yet. If you can help me
> with any docs will be more of a support.
What's going wrong for you?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: DBT-5 & Postgres 9.0.3
@ 2011-05-12 07:18 Sethu Prasad <sethuprasad.in@gmail.com>
parent: Robert Haas <robertmhaas@gmail.com>
0 siblings, 1 reply; 12+ messages in thread
From: Sethu Prasad @ 2011-05-12 07:18 UTC (permalink / raw)
To: Robert Haas <robertmhaas@gmail.com>; +Cc: pgsql-performance
http://sourceforge.net/mailarchive/forum.php?forum_name=osdldbt-general&max_rows=25&style=ne...
- Sethu
On Thu, May 12, 2011 at 5:22 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Tue, Apr 12, 2011 at 3:51 AM, Sethu Prasad <sethuprasad.in@gmail.com>
> wrote:
> > Anyone lucky to have dbt5 run for PostgreSQL 9.0.3?!
> >
> > I am trying on Novell SuSE Linux Enterprise Server 11 SP1 x86_64 with a
> > virtual machine and bit hard with no success run yet. If you can help me
> > with any docs will be more of a support.
>
> What's going wrong for you?
>
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: DBT-5 & Postgres 9.0.3
@ 2011-05-15 21:12 Robert Haas <robertmhaas@gmail.com>
parent: Sethu Prasad <sethuprasad.in@gmail.com>
0 siblings, 1 reply; 12+ messages in thread
From: Robert Haas @ 2011-05-15 21:12 UTC (permalink / raw)
To: Sethu Prasad <sethuprasad.in@gmail.com>; +Cc: pgsql-performance
On Thu, May 12, 2011 at 3:18 AM, Sethu Prasad <sethuprasad.in@gmail.com> wrote:
> http://sourceforge.net/mailarchive/forum.php?forum_name=osdldbt-general&max_rows=25&style=ne...
It's not very obvious from reading through that link what you still
need help with.
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: DBT-5 & Postgres 9.0.3
@ 2011-08-17 15:29 bobbyw <bobbyw@sendprobe.com>
parent: Robert Haas <robertmhaas@gmail.com>
0 siblings, 2 replies; 12+ messages in thread
From: bobbyw @ 2011-08-17 15:29 UTC (permalink / raw)
To: pgsql-performance
Hi, I know this is an old thread, but I wanted to chime in since I am having
problems with this as well.
I too am trying to run dbt5 against Postgres. Specifically I am trying to
run it against Postgres 9.1beta3.
After jumping through many hoops I ultimately was able to build dbt5 on my
debian environment, but when I attempt to run the benchmark with:
dbt5-run-workload -a pgsql -c 5000 -t 5000 -d 60 -u 1 -i ~/dbt5-0.1.0/egen
-f 500 -w 300 -n dbt5 -p 5432 -o /tmp/results
it runs to completion but all of the dbt5 log files contain errors like:
terminate called after throwing an instance of 'pqxx::broken_connection'
what(): could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket
"/var/run/postgresql/.s.PGSQL.5432"?
I'm lead to believe that this is an error I would receive if the Postgres db
were not running, but it is. In fact, the way dbt5-run-workload works it
starts the database automatically. I have also confirmed it is running by
manually connecting while this benchmark is in progress (and after it has
already started the database and logged the above error).
Any thoughts on why I might be getting this error?
--
View this message in context: http://postgresql.1045698.n5.nabble.com/DBT-5-Postgres-9-0-3-tp4297670p4708692.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: DBT-5 & Postgres 9.0.3
@ 2011-08-17 17:28 Andy Colson <andy@squeakycode.net>
parent: bobbyw <bobbyw@sendprobe.com>
1 sibling, 1 reply; 12+ messages in thread
From: Andy Colson @ 2011-08-17 17:28 UTC (permalink / raw)
To: bobbyw <bobbyw@sendprobe.com>; +Cc: pgsql-performance
On 8/17/2011 10:29 AM, bobbyw wrote:
> Hi, I know this is an old thread, but I wanted to chime in since I am having
> problems with this as well.
>
> I too am trying to run dbt5 against Postgres. Specifically I am trying to
> run it against Postgres 9.1beta3.
>
> After jumping through many hoops I ultimately was able to build dbt5 on my
> debian environment, but when I attempt to run the benchmark with:
>
> dbt5-run-workload -a pgsql -c 5000 -t 5000 -d 60 -u 1 -i ~/dbt5-0.1.0/egen
> -f 500 -w 300 -n dbt5 -p 5432 -o /tmp/results
>
> it runs to completion but all of the dbt5 log files contain errors like:
>
> terminate called after throwing an instance of 'pqxx::broken_connection'
> what(): could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket
> "/var/run/postgresql/.s.PGSQL.5432"?
>
> I'm lead to believe that this is an error I would receive if the Postgres db
> were not running, but it is. In fact, the way dbt5-run-workload works it
> starts the database automatically. I have also confirmed it is running by
> manually connecting while this benchmark is in progress (and after it has
> already started the database and logged the above error).
>
> Any thoughts on why I might be getting this error?
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/DBT-5-Postgres-9-0-3-tp4297670p4708692.html
> Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
>
Its trying to connect to unix socket "/var/run/postgresql/.s.PGSQL.5432",
but your postgresql.conf file probably has:
unix_socket_directory = '/tmp'
Change it to:
unix_socket_directory = '/var/run/postgresql'
and restart PG.
-Andy
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: DBT-5 & Postgres 9.0.3
@ 2011-08-17 17:59 bobbyw <bobbyw@sendprobe.com>
parent: Andy Colson <andy@squeakycode.net>
0 siblings, 1 reply; 12+ messages in thread
From: bobbyw @ 2011-08-17 17:59 UTC (permalink / raw)
To: pgsql-performance
Awesome.. that did it! It was actually not set at all in postgresql.conf,
although it was commented out as:
# unix_socket_directory = ''
Presumably it was using the default of '/tmp'?
Anyway, after making that change dbt5 runs fine, but now when I try to
connect via "psql" I get:
psql.bin: 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"?
Why is psql looking in /tmp?
--
View this message in context: http://postgresql.1045698.n5.nabble.com/DBT-5-Postgres-9-0-3-tp4297670p4709231.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: DBT-5 & Postgres 9.0.3
@ 2011-08-17 18:14 ktm@rice.edu <ktm@rice.edu>
parent: bobbyw <bobbyw@sendprobe.com>
0 siblings, 1 reply; 12+ messages in thread
From: ktm@rice.edu @ 2011-08-17 18:14 UTC (permalink / raw)
To: bobbyw <bobbyw@sendprobe.com>; +Cc: pgsql-performance
On Wed, Aug 17, 2011 at 10:59:12AM -0700, bobbyw wrote:
> Awesome.. that did it! It was actually not set at all in postgresql.conf,
> although it was commented out as:
>
> # unix_socket_directory = ''
>
> Presumably it was using the default of '/tmp'?
>
> Anyway, after making that change dbt5 runs fine, but now when I try to
> connect via "psql" I get:
>
> psql.bin: 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"?
>
> Why is psql looking in /tmp?
>
Because that is the default location. If you want to change it, you need
to use the -h commandline option.
Regards,
Ken
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: DBT-5 & Postgres 9.0.3
@ 2011-08-17 20:12 Tom Lane <tgl@sss.pgh.pa.us>
parent: ktm@rice.edu <ktm@rice.edu>
0 siblings, 1 reply; 12+ messages in thread
From: Tom Lane @ 2011-08-17 20:12 UTC (permalink / raw)
To: ktm@rice.edu <ktm@rice.edu>; +Cc: bobbyw <bobbyw@sendprobe.com>; pgsql-performance
"ktm@rice.edu" <ktm@rice.edu> writes:
> On Wed, Aug 17, 2011 at 10:59:12AM -0700, bobbyw wrote:
>> Why is psql looking in /tmp?
> Because that is the default location. If you want to change it, you need
> to use the -h commandline option.
It sounds to me like bobbyw might have two separate installations of
postgres (or at least two copies of psql), one compiled with /tmp as the
default socket location and one compiled with /var/run/postgresql as the
default. /tmp is the out-of-the-box default but I think Debian likes to
build it with /var/run/postgresql as the default.
regards, tom lane
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: DBT-5 & Postgres 9.0.3
@ 2011-08-17 20:41 Aidan Van Dyk <aidan@highrise.ca>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 12+ messages in thread
From: Aidan Van Dyk @ 2011-08-17 20:41 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: ktm@rice.edu <ktm@rice.edu>; bobbyw <bobbyw@sendprobe.com>; pgsql-performance
On Wed, Aug 17, 2011 at 4:12 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> It sounds to me like bobbyw might have two separate installations of
> postgres (or at least two copies of psql), one compiled with /tmp as the
> default socket location and one compiled with /var/run/postgresql as the
> default. /tmp is the out-of-the-box default but I think Debian likes to
> build it with /var/run/postgresql as the default.
It looked like the actual DBT-5 harness is built with "system
libraries" (libpqxx, linked to system libpq, with debian's
/var/run/postgresql), but the scaffolding around it uses a "local"
postgres (server and psql) using the source default of /tmp?
a.
--
Aidan Van Dyk Create like a god,
aidan@highrise.ca command like a king,
http://www.highrise.ca/ work like a slave.
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: DBT-5 & Postgres 9.0.3
@ 2011-08-17 21:17 Tom Lane <tgl@sss.pgh.pa.us>
parent: Aidan Van Dyk <aidan@highrise.ca>
0 siblings, 0 replies; 12+ messages in thread
From: Tom Lane @ 2011-08-17 21:17 UTC (permalink / raw)
To: Aidan Van Dyk <aidan@highrise.ca>; +Cc: ktm@rice.edu <ktm@rice.edu>; bobbyw <bobbyw@sendprobe.com>; pgsql-performance
Aidan Van Dyk <aidan@highrise.ca> writes:
> On Wed, Aug 17, 2011 at 4:12 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> It sounds to me like bobbyw might have two separate installations of
>> postgres (or at least two copies of psql), one compiled with /tmp as the
>> default socket location and one compiled with /var/run/postgresql as the
>> default. /tmp is the out-of-the-box default but I think Debian likes to
>> build it with /var/run/postgresql as the default.
> It looked like the actual DBT-5 harness is built with "system
> libraries" (libpqxx, linked to system libpq, with debian's
> /var/run/postgresql), but the scaffolding around it uses a "local"
> postgres (server and psql) using the source default of /tmp?
Hmm ... doesn't sound like an amazingly good idea. But if DBT wants to
do it that way, it'd be well advised to not assume that the system
libraries have either the port number or socket directory defaulting
to what it is using. Or maybe the problem is that it does override all
that stuff and works fine by itself, but then you can't easily connect
to the server manually?
regards, tom lane
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: DBT-5 & Postgres 9.0.3
@ 2011-09-24 15:45 Mark Wong <markwkm@gmail.com>
parent: bobbyw <bobbyw@sendprobe.com>
1 sibling, 0 replies; 12+ messages in thread
From: Mark Wong @ 2011-09-24 15:45 UTC (permalink / raw)
To: bobbyw <bobbyw@sendprobe.com>; +Cc: pgsql-performance@postgresql.org, osdldbt-general <osdldbt-general@lists.sourceforge.net>
On Wed, Aug 17, 2011 at 8:29 AM, bobbyw <bobbyw@sendprobe.com> wrote:
> Hi, I know this is an old thread, but I wanted to chime in since I am having
> problems with this as well.
>
> I too am trying to run dbt5 against Postgres. Specifically I am trying to
> run it against Postgres 9.1beta3.
>
> After jumping through many hoops I ultimately was able to build dbt5 on my
> debian environment, but when I attempt to run the benchmark with:
>
> dbt5-run-workload -a pgsql -c 5000 -t 5000 -d 60 -u 1 -i ~/dbt5-0.1.0/egen
> -f 500 -w 300 -n dbt5 -p 5432 -o /tmp/results
>
> it runs to completion but all of the dbt5 log files contain errors like:
>
> terminate called after throwing an instance of 'pqxx::broken_connection'
> what(): could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket
> "/var/run/postgresql/.s.PGSQL.5432"?
>
> I'm lead to believe that this is an error I would receive if the Postgres db
> were not running, but it is. In fact, the way dbt5-run-workload works it
> starts the database automatically. I have also confirmed it is running by
> manually connecting while this benchmark is in progress (and after it has
> already started the database and logged the above error).
>
> Any thoughts on why I might be getting this error?
Hi there,
Sorry I didn't catch this sooner. Can you try using the code from the
git repository? I removed libpqxx and just used libpq a while ago to
hopefully simplify the kit:
git://osdldbt.git.sourceforge.net/gitroot/osdldbt/dbt5
Regards,
Mark
^ permalink raw reply [nested|flat] 12+ messages in thread
end of thread, other threads:[~2011-09-24 15:45 UTC | newest]
Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-04-12 07:51 DBT-5 & Postgres 9.0.3 Sethu Prasad <sethuprasad.in@gmail.com>
2011-05-12 03:22 ` Robert Haas <robertmhaas@gmail.com>
2011-05-12 07:18 ` Sethu Prasad <sethuprasad.in@gmail.com>
2011-05-15 21:12 ` Robert Haas <robertmhaas@gmail.com>
2011-08-17 15:29 ` bobbyw <bobbyw@sendprobe.com>
2011-08-17 17:28 ` Andy Colson <andy@squeakycode.net>
2011-08-17 17:59 ` bobbyw <bobbyw@sendprobe.com>
2011-08-17 18:14 ` ktm@rice.edu <ktm@rice.edu>
2011-08-17 20:12 ` Tom Lane <tgl@sss.pgh.pa.us>
2011-08-17 20:41 ` Aidan Van Dyk <aidan@highrise.ca>
2011-08-17 21:17 ` Tom Lane <tgl@sss.pgh.pa.us>
2011-09-24 15:45 ` Mark Wong <markwkm@gmail.com>
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