From: | Atri Sharma <atri(dot)jiit(at)gmail(dot)com> |
---|---|
To: | Georges Racinet <gracinet(at)anybox(dot)fr> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pgbench help |
Date: | 2012-12-24 10:46:10 |
Message-ID: | CAOeZVies0mFSHbVF2_pbNkZfEULDzX4iEN8U8VM9oRJ+Y-MaOQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Dec 24, 2012 at 4:13 PM, Georges Racinet <gracinet(at)anybox(dot)fr> wrote:
> On 12/24/2012 08:50 AM, Atri Sharma wrote:
>> I have two 9.2 servers running in different data directories and
>> installation directories. One of them(the main one) has its bin in the
>> path of my system.The other one does not, hence, I need to use the
>> complete path(/usr/local/pgsql/...).
>>
>> I want to run pgbench on the second server. How should I configure
>> pgbench to use the second server's psql?
> Hi,
>
> I'm by no means an expert in pgbench, but this is client software
> relying on libpq.
> You can make it work against the secondary server simply by specifying
> its port with -p option or PGPORT environment variable.
>
> If that matters, to make sure that the right version of libpq is being
> used, you can use LD_LIBRARY_PATH, something like
>
> export LD_LIBRARY_PATH = /usr/local/pgsql/lib
>
> ann use if possible the pgbench from the secondary install.
>
> Make sure both servers aren't running at the same time :-)
Thanks a ton, I get it now.
Atri
--
Regards,
Atri
l'apprenant
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2012-12-24 11:32:22 | Re: pgbench help |
Previous Message | Georges Racinet | 2012-12-24 10:43:31 | Re: pgbench help |