Re: More than one installation on the same machine - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: More than one installation on the same machine
Date
Msg-id 20030726173027.GA3291@wolff.to
Whole thread Raw
In response to More than one installation on the same machine  (Jay R <jaysjaded@yahoo.com>)
List pgsql-novice
On Fri, Jul 25, 2003 at 23:42:02 -0700,
  Jay R <jaysjaded@yahoo.com> wrote:
> I've installed 7.3 in its own directory, using the
> default configuration parameters, and I gather from
> the 7.3 documentation that I need to start it up on a
> different port and provide a different socket to point
> DBI::Pg at.  (7.2 has port 5432 and a socket in /tmp)
>  But I couldn't figure out quite how to do it, based
> on the documentation.  If anyone can provide me with
> more detailed instructions (or point me at them if
> they're out on the web somewhere), I'd be much
> obliged.

I use Pg.pm, but I think this may help.
I put:
SetEnv PGPORT 5433
in appropiate .htaccess files to have an area of my web site use the development
postgres instead of 7.3.3 which runs on the default port.

This makes it easy to switch back if I grab a new copy of 7.4 and it
has problems. (The databases are essentially static so I can keep both
loaded and switch back and forth without causing problems.)

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: More than one installation on the same machine
Next
From: "bruce"
Date:
Subject: Accessing Postgres db from apache using PHP