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.)
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 |