Re: pgxs problem

From: Joe Conway <mail(at)joeconway(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Gregory Stark <gsstark(at)mit(dot)edu>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: pgxs problem
Date: 2006-07-19 22:06:01
Message-ID: 44BEACC9.5090204@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Michael Fuhr wrote:
> On Wed, Jul 19, 2006 at 10:29:14AM -0400, Tom Lane wrote:
>
>>The documented behavior is that pgxs invokes whatever pg_config is in
>>your PATH.
>
> How do people with multiple PostgreSQL installations keep track of
> which installation they're using? I use shell scripts that set
> PATH and a few other environment variables and then exec the command
> I want to run (shell aliases would also work). For example, I'd
> type "pg73 psql" to run the 7.3 version of psql (which would connect
> to a 7.3 server) and I'd type "pg82 gmake" to build an extension
> for 8.2devel. Prefixing each command with pgXX is a minor nuisance
> but by being explicit I always know what version I'm using.
>
> What are others doing?
>

I use something very similar that Tom Lane sent me a while back. The
only difference is I type, say, "pg81" just once, and it sets up my
environment for 8.1 (PATH, LD_LIBRARY_PATH, PGDATA, etc). From that
point on I just use normal commands. Works great for me.

Joe

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-07-19 22:09:25 Re: pgxs problem
Previous Message Jim C. Nasby 2006-07-19 21:58:00 How does the planner deal with multiple possible indexes?