Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0000204Openbravo ERPK. Packagingpublic2008-05-07 21:582009-03-18 11:01
laurieb 
jpabloae 
normalcriticalalways
closedfixed 
102003 R2
 
 
No
Core
No
0000204: AT235MP4: Installer fails to build database on Postgres
Installer fails to build database. Install logs attached
Install 235MP4, Select Postgress, Full install (with demo data), developer install. Installer reports error
AT235MP4
zip installation_logs.zip (9,556) 2008-05-07 21:58
https://issues.openbravo.com/file_download.php?file_id=21&type=bug
Issue History
2008-05-07 21:58lauriebNew Issue
2008-05-07 21:58lauriebAssigned To => cromero
2008-05-07 21:58lauriebFile Added: installation_logs.zip
2008-05-07 23:09jpabloaeAssigned Tocromero => jpabloae
2008-05-08 00:16jpabloaeNote Added: 0000067
2008-05-08 00:16jpabloaeStatusnew => @40@
2008-05-08 00:36jpabloaeStatus@40@ => scheduled
2008-05-08 00:36jpabloaeNote Added: 0000068
2008-05-08 00:41jpabloaeRelationship addedhas duplicate 0000205
2008-05-08 00:42jpabloaeRelationship addedhas duplicate 0000203
2008-05-08 08:03pjuvaraTag Attached: AT235MP4
2008-05-08 08:09pjuvaraSummaryAT235MP4 => AT235MP4: Installer fails to build database on Postgres
2008-05-08 12:16jpabloaeNote Added: 0000071
2008-05-08 12:17lauriebNote Added: 0000072
2008-05-08 13:45lauriebNote Added: 0000074
2008-05-08 14:28jpabloaeNote Added: 0000075
2008-05-08 15:52lauriebNote Added: 0000076
2008-05-09 11:39jpabloaeProjectOpenbravo ERP => @5@
2008-05-11 11:47jpabloaeStatusscheduled => resolved
2008-05-11 11:47jpabloaeResolutionopen => fixed
2008-05-11 11:47jpabloaeNote Added: 0000128
2008-05-15 16:38jpabloaeCategoryA. Installation and Platform => Installer
2008-11-13 07:02jpabloaeStatusresolved => closed
2008-11-25 21:41pjuvaraSticky IssueNo => Yes
2008-11-25 21:43pjuvaraProject@5@ => Openbravo ERP
2008-11-25 21:45pjuvaraCategoryInstaller => K. Packaging
2008-11-25 21:47pjuvaraSticky IssueYes => No
2009-03-18 11:01anonymoussf_bug_id0 => 2691233

Notes
(0000067)
jpabloae   
2008-05-08 00:16   
Reproduced. The command assumes that the pg_restore executable is in the system path, and it shouldn't.
(0000068)
jpabloae   
2008-05-08 00:36   
A workaround until a new installer is provided:
Add the PostgreSQL binaries directory (PostgreSQL\8.2\bin) to the system's PATH environment variable. It's necessary to add it without spaces (use DOS name in case there are). For example:
C:\Progra~1\PostgreSQL\8.2\bin

This has to be fixed also in the upcoming 2.40alpha installer.
(0000071)
jpabloae   
2008-05-08 12:16   
Not a regression, the bug was also there in the 2.35MP1 installer.
(0000072)
laurieb   
2008-05-08 12:17   
Yes I can confirm it was also in 2.35MP1
(0000074)
laurieb   
2008-05-08 13:45   
The workround did not work for me. I tried adding ;C:\Progra~1\PostgreSQL\8.2\bin to my Path (thats correct on my test machine), but the same problem occurred.

I selected mode="complete", complete="developer" (not standard) and asked for sample data to be installed
(0000075)
jpabloae   
2008-05-08 14:28   
Hi laurieb,

After adding that to the path, to make sure it's been added correctly, open a command line windows (start->run->cmd), and run "pg_restore --version", to see if the command is available.
(0000076)
laurieb   
2008-05-08 15:52   
pg_restore --version says version 8.2.6 when in the bin directory.
I've tried lots of combinations in the path but I can't get it to find pg_restore unless I'm in the bin folder. I think the answer is DONT install Postgres in "Program Files".

I'll leave this for now and continue with other tests
(0000128)
jpabloae   
2008-05-11 11:47   
Fixed, now it uses the PostgreSQL path detected or specified in the installation. This will be available in the final 2.35MP4 installer.