Re: BUG #4321: 8.3 installer shortens allowable BASE_DIR path length?

Dave, Magnus, did you see this report?

---------------------------------------------------------------------------

Bob Kuhfahl wrote:
>
> The following bug has been logged online:
>
> Bug reference:      4321
> Logged by:          Bob Kuhfahl
> Email address:      bobk@asg.com
> PostgreSQL version: 8.3
> Operating system:   windows
> Description:        8.3 installer shortens allowable BASE_DIR path length?
> Details:
>
> We're a ISV using postgres in our product and we use the postgres silent
> installer from with ours.  We install postgres next to our product and the
> path can be anywhere the user chooses.  We're currently on 8.2 and looking
> to upgrade to 8.3.
> ---
> *  Testing found the following problem: Failed to retrieve the
> 'CustomActionData' property whilst preparing to execute initdb.
> ---
> *  This was a result of the following command line: MsiExec.exe /i
> postgresql-8.3-int.msi /qb  INTERNALLAUNCH=1  SERVICEDOMAIN=USRESXROBERTKU
> SERVICEPASSWORD="asgp0stg3sq(l)"  SERVICEACCOUNT=nispostgres
> SERVICENAME="asg postgresql"  SUPERUSER=postgres SUPERPASSWORD=naviplex
> CREATESERVICEUSER=1  LISTENPORT=5432  PERMITREMOTE=1
> BASEDIR="C:\Program Files\ASG\Naviplex Integration
> Services\postgresql-8.3.3-1" /l "postgres_install.log"
> ---
> *  Putting L*v on the above, we find this in the log:
> MSI (s) (CC:9C) [11:46:25:236]: Generating random cookie.
> MSI (s) (CC:9C) [11:46:25:252]: Created Custom Action Server with PID 3336
> (0xD08).
> MSI (s) (CC:94) [11:46:25:330]: Running as a service.
> MSI (s) (CC:3C) [11:46:25:330]: Hello, I'm your 32bit Elevated custom action
> server.
> MSI (s) (CC:70) [11:46:27:002]: Executing op:
> ActionStart(Name=RunInitdb,Description=Initializing database cluster (this
> may take a minute or two)...,)
> MSI (s) (CC:70) [11:46:27:002]: Executing op:
> CustomActionSchedule(Action=RunInitdb,ActionType=3073,Source=BinaryData,Targ
> et=_RunInitdb@4,CustomActionData=1033;C:\Program Files\ASG\Naviplex
> Integration Services\postgresql-8.3.3-1\;C:\Program Files\ASG\Naviplex
> Integration Services\postgresql-8.3.3-1\data\;C:\Program Files\ASG\Naviplex
> Integration
> Services\postgresql-8.3.3-1\share\;5432;1;C;SQL_ASCII;postgres;naviplex;USRE
> SXROBERTKU;nispostgres;asgp0stg3sq(l);;)
> MSI (s) (CC:AC) [11:46:27:049]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI60.tmp, Entrypoint: _RunInitdb@4
> MSI (s) (CC!7C) [11:52:48:286]: Note: 1: 2205 2:  3: Error
> MSI (s) (CC!7C) [11:52:48:286]: Note: 1: 2228 2:  3: Error 4: SELECT
> `Message` FROM `Error` WHERE `Error` = 1709
> MSI (s) (CC!7C) [11:52:48:380]: Product: PostgreSQL 8.3 -- Failed to
> retrieve the 'CustomActionData' property whilst preparing to execute
> initdb.
> ---
> *  A code search indicates this changed when going from 1.103 to 1.104 of
> pginstca.c
> i.e.
> http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/ca/pginstca.c
> .diff?r1=1.103&r2=1.104&f=u
> ============================================
> It's not clear from the comments why this change was needed, but if someone
> could change mybuf back to 8192 bytes (or something significantly more than
> MAX_PATH+1 (which on windows is only 260)) - I think it would be a good
> thing?
> Regards,
> Bob
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +