On Mon, Dec 24, 2012 at 4:13 PM, Georges Racinet <gracinet@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
