Thread: pgbench installation

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