Thread: pgsql Windows installer fixed registry key

Hello

I am currently working on creating a build system for an open source portable
project that should be able to build the project on many platforms, POSIX and
non-POSIX such as Windows. Our project has the option for using PostgreSQL.

Searching for PostgreSQL includes/libraries is very easy on POSIX and Unices
but on Windows one has usually 3 options:
- have a relative location to the project source tree where those should be
found (like a $project-root/pgsql)
- have the user specify the location to them
- try to read the location from registry settings

Note that these methods do not exclude eachover.

The pgsql MSI installer does register a registry key but it's random everytime
it installs (probably something MSI choses). I am asking if someone could
make it (also) register a fixed registry key pointing to it's install
location (from which I could locate the includes/library to use when building
our project). This could be useful for other projects too of course. In a
similar way MySQL registers the key
HKEY_LOCAL_MACHINE\SOFTWARE\MySQL AB\MySQL Server 5.0;Location for a 5.0.x
version. Could it be possible to have PostgreSQL installer do something
similar?

Thank you!

--
Mihai RUSU                    Email: dizzy@roedu.net
GPG : http://dizzy.roedu.net/dizzy-gpg.txt    WWW: http://dizzy.roedu.net
            "Linux is obsolete" -- AST

> ------- Original Message -------
> From: Dizzy <dizzy@roedu.net>
> To: pgsql-general@postgresql.org
> Sent: 27/08/07, 21:12:55
> Subject: [GENERAL] pgsql Windows installer fixed registry key
>
> The pgsql MSI installer does register a registry key but it's random everytime
> it installs (probably something MSI choses).

No it's not random. It uses the product ID which only changes between major versions (ie. 8.2 - 8.3) or between distros
(eg.pgInstaller vs. EnterpriseDB Postgres). 

Regards, Dave

On Tuesday 28 August 2007 00:14:55 Dave Page wrote:
> > The pgsql MSI installer does register a registry key but it's random
> > everytime it installs (probably something MSI choses).
>
> No it's not random. It uses the product ID which only changes between major
> versions (ie. 8.2 - 8.3) or between distros (eg. pgInstaller vs.
> EnterpriseDB Postgres).

Yes, you are right, sorry for the spam then and thanks for the answer:)

--
Mihai RUSU                    Email: dizzy@roedu.net
            "Linux is obsolete" -- AST