Re: running multiple versions

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: running multiple versions
Date: 2012-02-16 23:10:56
Message-ID: 4F3D8D00.6070805@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 02/16/12 3:00 PM, Adrian Klaver wrote:
> This is a limitation of the Postgres Windows Installer? Compiling from source
> would allow running different minor versions.

probably the windows service names is the sticking point. you'd need to
create a custom service, which could be done with the 'sc' command
(windows built in utility).

E:\>sc qc postgresql-8.4
[SC] GetServiceConfig SUCCESS

SERVICE_NAME: postgresql-8.4
TYPE : 10 WIN32_OWN_PROCESS
START_TYPE : 2 AUTO_START
ERROR_CONTROL : 1 NORMAL
BINARY_PATH_NAME : D:/postgres/8.4/bin/pg_ctl.exe runservice
-N "postgresql-8.4" -D "D:/postgres/8.4/data" -w
LOAD_ORDER_GROUP :
TAG : 0
DISPLAY_NAME : postgresql-8.4 - PostgreSQL Server 8.4
DEPENDENCIES : RPCSS
SERVICE_START_NAME : .\postgres

so, if I was to install 8.4.somethignelse into a different directory,
I'd need to create a seperate service for it, like...

sc create postgres-8.4.5 binPath="D:/postgres/8.4.5/bin/pg_ctl.exe
runservice -N postgresql-8.4.5 -D D:/postgres/8.4.5/data -w"
type=own start=auto error=normal DisplayName="postgresql-8.4.5
- PostgreSQL Server 8.4.5" depend=RPCSS
obj=.\postgres

(thats all one gnarly command line)

then

sc start postgres-8.4.5

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-02-16 23:19:37 Re: running multiple versions
Previous Message Merlin Moncure 2012-02-16 23:09:17 Re: How to dereference 2 dimensional array?