From: Greg Smith <greg@2ndquadrant.com>
To: Reydan Cankur <reydan.cankur@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: pgbench installation
Date: Mon, 22 Mar 2010 01:00:44 -0400
Message-ID: <4BA6F97C.5030703@2ndquadrant.com> (raw)
In-Reply-To: <fffc04cc1003192150y72c9e1c3g71c8a2259bfad263@mail.gmail.com>
References: <fffc04cc1003192150y72c9e1c3g71c8a2259bfad263@mail.gmail.com>
Reydan Cankur wrote:
>
> I have compiled PostgreSQL 8.4 from source code and in order to
> install pgbench, I go under contrib folder and run below commands:
> make
> make install
> when I write pgbench as a command system cannot find pgbench as a command.
Do regular PostgreSQL command such as psql work? pgbench should be
installed into the same directory those are.
Normally you just need to add the directory all these programs are in to
your PATH environment variable when you login. If you're not sure where
that is, you could re-install pgbench and note where it puts it at when
you reinstall:
cd contrib/pgbench
make clean
make
make install
Or you could use a system utility such as "locate pgbench" or "find" to
figure out where it went at.
> As a result I cannot use pgbench-tools because system does not
> interpret pgbench as a command?
You don't actually need pgbench to be in your PATH for pgbench-tools to
work. If you look at the "config" file it uses, you'll find this:
PGBENCHBIN=`which pgbench`
If pgbench is in your PATH, this will return its location, and since
that's normally the case for people running PostgreSQL it's the
default. But you could alternately update this to include a direct
location instead. For example, if pgbench was stored in your home
directory, something like this would work:
PGBENCHBIN="/home/me/pgsql/bin/pgbench"
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us
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-performance@postgresql.org
Cc: greg@2ndquadrant.com, reydan.cankur@gmail.com
Subject: Re: pgbench installation
In-Reply-To: <4BA6F97C.5030703@2ndquadrant.com>
* 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