BUG #13621: Program paths are registered incorrectly.

Lists: Postg스포츠 토토SQL : Postg스포츠 토토SQL 메일 링리스트 : 2015-09-15 이후 PGSQL-BUGS 13:37
From: userob(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13621: Program paths are registered incorrectly.
Date: 2015-09-15 13:37:54
Message-ID: 20150915133754.2678.40254@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: Postg스포츠 토토SQL : Postg스포츠 토토SQL 메일 링리스트 : 2015-09-15 이후 PGSQL-BUGS 13:37

The following bug has been logged on the website:

Bug reference: 13621
Logged by: Eugene
Email address: userob(at)gmail(dot)com
PostgreSQL version: 9.4.4
Operating system: Windows 8.1 Pro x64
Description:

The 9.4.4 version for windows registers its paths in registry with "/"
instead of "\".


From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: userob(at)gmail(dot)com
Cc: PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #13621: Program paths are registered incorrectly.
Date: 2015-09-15 18:52:24
Message-ID: CAB7nPqRArWZFTXAmN11DxOfrbm1N9AMKX3C-dtfis7xNq-rBmg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

On Tue, Sep 15, 2015 at 6:37 AM, <userob(at)gmail(dot)com> wrote:
> Bug reference: 13621
> Logged by: Eugene
> Email address: userob(at)gmail(dot)com
> PostgreSQL version: 9.4.4
> Operating system: Windows 8.1 Pro x64
> Description:
>
> The 9.4.4 version for windows registers its paths in registry with "/"
> instead of "\".

To which entries of the windows registry are you referring to and how
are you installing Postgres on Windows? Note that both slashes and
backslashes are compatible on Windows, so that's not really an issue
in any case whichever the ways those registry entries are used in your
environment and/or by the installer used.
--
Michael


From: Userob <userob(at)gmail(dot)com>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #13621: Program paths are registered incorrectly.
Date: 2015-09-16 11:11:02
Message-ID: CAEPw1JUhRbiQ5uudKaJCQy16H+OH7ZO11xAD7OuKCNGh6ikkiQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

Environment: windows 8.1 pro x64 with no extra software installed.

Install the postgresql-9.4.4-3-windows.exe binary with default settings and
proceed with installing PostGIS extention (PostGIS 2.1 Bundle for
PostgreSQL 9.4 (32-bit v2.1.8) with Stack Builder.

On the Choose Intallation Location screen of PostGIS intallation (see
attached screnshot) the Destination Folder will be pre-filled with the
value from the PostgreSQL Base Directory registry key but you won't be able
to proceed unless you replace slashes with backslathes.

Probably this is a PostGIS installer issue because there is no such problem
with x64 PostgreSQL+PostGIS bundle although the Base directory is also
defined with slashes in the registry but is desplayed with backslashes on
the Choose Intallation Location screen of PostGIS installer.

Here is a the list of registry keys with slashes in the paths which are
created at program installation.
------------------------
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Applications\pgAdmin3.exe\shell\open\command]
@="\"C:/Program Files (x86)/PostgreSQL/9.4\\bin\\pgAdmin3.exe\" -q -f
\"%1\""

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall
\PostgreSQL 9.4]
"InstallLocation"="C:/Program Files (x86)/PostgreSQL/9.4"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\PostgreSQL\Installations\postgresql-9.4]
"Base Directory"="C:/Program Files (x86)/PostgreSQL/9.4"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\PostgreSQL Global Development
Group\PostgreSQL]
"Location"="C:/Program Files (x86)/PostgreSQL/9.4"

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\Application\PostgreSQL]
"EventMessageFile"="C:/Program Files (x86)/PostgreSQL/9.4\\lib\\pgevent.dll"
------------------------

The user of slashes instead of backslathes in the Base Directory key cause
an issue when installing PostG

2015-09-15 21:52 GMT+03:00 Michael Paquier <michael(dot)paquier(at)gmail(dot)com>:

> On Tue, Sep 15, 2015 at 6:37 AM, <userob(at)gmail(dot)com> wrote:
> > Bug reference: 13621
> > Logged by: Eugene
> > Email address: userob(at)gmail(dot)com
> > PostgreSQL version: 9.4.4
> > Operating system: Windows 8.1 Pro x64
> > Description:
> >
> > The 9.4.4 version for windows registers its paths in registry with "/"
> > instead of "\".
>
> To which entries of the windows registry are you referring to and how
> are you installing Postgres on Windows? Note that both slashes and
> backslashes are compatible on Windows, so that's not really an issue
> in any case whichever the ways those registry entries are used in your
> environment and/or by the installer used.
> --
> Michael
>

Attachment Content-Type Size
image/png 25.6 KB