Message-ID: <4BA6F97C.5030703@2ndquadrant.com>
Date: Mon, 22 Mar 2010 01:00:44 -0400
From: Greg Smith <greg@2ndquadrant.com>
User-Agent: Thunderbird 2.0.0.24 (X11/20100317)
MIME-Version: 1.0
To: Reydan Cankur <reydan.cankur@gmail.com>
CC: pgsql-performance@postgresql.org
Subject: Re: pgbench installation
References: <fffc04cc1003192150y72c9e1c3g71c8a2259bfad263@mail.gmail.com>
In-Reply-To: <fffc04cc1003192150y72c9e1c3g71c8a2259bfad263@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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