Re: More than one installation on the same machine

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Jay R <jaysjaded(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: More than one installation on the same machine
Date: 2003-07-26 17:30:27
Message-ID: 20030726173027.GA3291@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Fri, Jul 25, 2003 at 23:42:02 -0700,
Jay R <jaysjaded(at)yahoo(dot)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.)

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bruce Momjian 2003-07-27 03:52:03 Re: [NOVICE] connectby(... pos_of_sibling)
Previous Message Tom Lane 2003-07-26 14:00:14 Re: More than one installation on the same machine