Thread: BUG #3980: Can not Install PostgreSQL - error at the end of installation

BUG #3980: Can not Install PostgreSQL - error at the end of installation

From
"Miroslav Nachev"
Date:
The following bug has been logged online:

Bug reference:      3980
Logged by:          Miroslav Nachev
Email address:      miro@space-comm.com
PostgreSQL version: 8.3, 8.2
Operating system:   Windows Vista Ultimate
Description:        Can not Install PostgreSQL - error at the end of
installation
Details:

I try many times to install PostgreSQL 8.3 and older versions on my new
mobile computer Acer AS7720G-933G64Bn with installed Windows Vista Ultimate
OS. Unfortunately it is not possible. In the beginning I have one error.
After User Account Control (UAC) disabling the error is changed to "Failed
to create temporary directory." on "Initializing database cluster (...)...".
I can apply the  log file of installation if you tell me how and where?

Can you give me some idea how to solve that problem?

Re: BUG #3980: Can not Install PostgreSQL - error at the end of installation

From
"Dave Page"
Date:
On Fri, Feb 22, 2008 at 9:01 AM, Miroslav Nachev <miro@space-comm.com> wrote:
>
>  The following bug has been logged online:
>
>  Bug reference:      3980
>  Logged by:          Miroslav Nachev
>  Email address:      miro@space-comm.com
>  PostgreSQL version: 8.3, 8.2
>  Operating system:   Windows Vista Ultimate
>  Description:        Can not Install PostgreSQL - error at the end of
>  installation
>  Details:
>
>  I try many times to install PostgreSQL 8.3 and older versions on my new
>  mobile computer Acer AS7720G-933G64Bn with installed Windows Vista Ultimate
>  OS. Unfortunately it is not possible. In the beginning I have one error.
>  After User Account Control (UAC) disabling the error is changed to "Failed
>  to create temporary directory." on "Initializing database cluster (...)...".
>  I can apply the  log file of installation if you tell me how and where?
>
>  Can you give me some idea how to solve that problem?

It's possible you've hit one of a couple of Vista-related bugs that
we've found very recently. There is a test build at
http://developer.pgadmin.org/~dpage/postgresql-8.3-vista-fixes.zip if
you wish to try it. The changes there will be rolled into the next
official build.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Oracle-compatible database company

Re: BUG #3980: Can not Install PostgreSQL - error at the end of installation

From
Miroslav Nachev
Date:
The same bad result.


Miro.

Dave Page wrote:
<blockquote
 cite="mid:937d27e10802220753n70ed2ab3w867623bb0dd25b7@mail.gmail.com"
 type="cite">
  On Fri, Feb 22, 2008 at 9:01 AM, Miroslav Nachev <miro@space-comm.com> wrote:


     The following bug has been logged online:

 Bug reference:      3980
 Logged by:          Miroslav Nachev
 Email address:      miro@space-comm.com
 PostgreSQL version: 8.3, 8.2
 Operating system:   Windows Vista Ultimate
 Description:        Can not Install PostgreSQL - error at the end of
 installation
 Details:

 I try many times to install PostgreSQL 8.3 and older versions on my new
 mobile computer Acer AS7720G-933G64Bn with installed Windows Vista Ultimate
 OS. Unfortunately it is not possible. In the beginning I have one error.
 After User Account Control (UAC) disabling the error is changed to "Failed
 to create temporary directory." on "Initializing database cluster (...)...".
 I can apply the  log file of installation if you tell me how and where?

 Can you give me some idea how to solve that problem?



It's possible you've hit one of a couple of Vista-related bugs that
we've found very recently. There is a test build at
http://developer.pgadmin.org/~dpage/postgresql-8.3-vista-fixes.zip if
you wish to try it. The changes there will be rolled into the next
official build.

Re: BUG #3980: Can not Install PostgreSQL - error at the end of installation

From
"Dave Page"
Date:
On Fri, Feb 22, 2008 at 4:27 PM, Miroslav Nachev <miro@space-comm.com> wrote:
>
>  The same bad result.

There is one other bug in the server itself which can cause a similar
effect on Vista - the fix for that is waiting to be committed to the
main postgresql code, but is not in the installer you tested (I also
cannot update it at the moment as I'm overseas and only have a Mac
with me).

This bug is most likely to show up if you are running the installer
when logged into the Administrator account which can become the
default in some installations of Vista. Could this be the case for
you? If so, try creating a new user account with administrative
privileges, and then run the installer whilst logged in as that user.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Oracle-compatible database company

Re: BUG #3980: Can not Install PostgreSQL - error at the end of installation

From
Miroslav Nachev
Date:
I try with Administrator account. Then with PostgreSQL account which
has Administrators access, then I add Administrators access to my my
own account. All time the same result.


Miro.

Dave Page wrote:
<blockquote
 cite="mid:937d27e10802220833t39e9c5adl69a692be28294f5f@mail.gmail.com"
 type="cite">
  On Fri, Feb 22, 2008 at 4:27 PM, Miroslav Nachev <miro@space-comm.com> wrote:


     The same bad result.



There is one other bug in the server itself which can cause a similar
effect on Vista - the fix for that is waiting to be committed to the
main postgresql code, but is not in the installer you tested (I also
cannot update it at the moment as I'm overseas and only have a Mac
with me).

This bug is most likely to show up if you are running the installer
when logged into the Administrator account which can become the
default in some installations of Vista. Could this be the case for
you? If so, try creating a new user account with administrative
privileges, and then run the installer whilst logged in as that user.

Re: BUG #3980: Can not Install PostgreSQL - error at the end of installation

From
"Dave Page"
Date:
On Fri, Feb 22, 2008 at 5:43 PM, Miroslav Nachev <miro@space-comm.com> wrote:
>
>  I try with Administrator account. Then with PostgreSQL account which has
> Administrators access, then I add Administrators access to my my own
> account. All time the same result.

OK, let's go back to basics in that case. 8.3 should work fine with
UAC turned on, so please don't change that at the moment. What's the
exact messages when you see the failure? Does it refer you to an
initdb logfile? If so let's have a look at it (you *must* copy it out
before you click OK on the messagebox).

Failing that, please run the installer with the logging option enabled
on the first screen (the language selection one), and send the
resulting log.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Oracle-compatible database company

Re: BUG #3980: Can not Install PostgreSQL - error at the end of installation

From
"Dave Page"
Date:
On Sun, Feb 24, 2008 at 12:11 PM, Miroslav Nachev <miro@space-comm.com> wrote:
>
>  Hi Dave,
>
>  Please find the attached files - log in ZIP format and the messages from
> MessageBox-es (JPG files).

Hi Miro,

I don't see why that error would occur unless there's a tmp file in
C:\Program Files\PostgreSQL\8.3 already. I assume thats not the case?
Magnus; any ideas?

To get up and running though, you should be able to install with
initdb disabled and then run it manually from the commandline.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Oracle-compatible database company

Re: BUG #3980: Can not Install PostgreSQL - error at the end of installation

From
Miroslav Nachev
Date:
Can you send me a script (BAT/CMD) file? Or another installations where
more detail log is available?


Miro.

Dave Page wrote:
<blockquote
 cite="mid:937d27e10802250656j4cf16cafu1ccf3b96e4c77ff5@mail.gmail.com"
 type="cite">
  On Sun, Feb 24, 2008 at 12:11 PM, Miroslav Nachev <miro@space-comm.com> wrote:


     Hi Dave,

 Please find the attached files - log in ZIP format and the messages from
MessageBox-es (JPG files).



Hi Miro,

I don't see why that error would occur unless there's a tmp file in
C:\Program Files\PostgreSQL\8.3 already. I assume thats not the case?
Magnus; any ideas?

To get up and running though, you should be able to install with
initdb disabled and then run it manually from the commandline.

Re: BUG #3980: Can not Install PostgreSQL - error at the end of installation

From
"Dave Page"
Date:
On Mon, Feb 25, 2008 at 2:48 PM, Miroslav Nachev <miro@space-comm.com> wrote:
>
>  Can you send me a script (BAT/CMD) file? Or another installations where
> more detail log is available?

Script for what?



--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Oracle-compatible database company

Re: BUG #3980: Can not Install PostgreSQL - error at the end of installation

From
Miroslav Nachev
Date:
To get up and running though, you should be able to install with
initdb disabled and then run it manually from the commandline.


How to do the above?


Miro.


Dave Page wrote:
<blockquote
 cite="mid:937d27e10802250725h5234de4j7b1619f4379b144b@mail.gmail.com"
 type="cite">
  On Mon, Feb 25, 2008 at 2:48 PM, Miroslav Nachev <miro@space-comm.com> wrote:


     Can you send me a script (BAT/CMD) file? Or another installations where
more detail log is available?



Script for what?

Re: BUG #3980: Can not Install PostgreSQL - error at the end of installation

From
"Dave Page"
Date:
On Mon, Feb 25, 2008 at 3:39 PM, Miroslav Nachev <miro@space-comm.com> wrote:
>
>
>
>  To get up and running though, you should be able to install with
> initdb disabled and then run it manually from the commandline.
>
>  How to do the above?

When you install, un-check the initdb option on the initdb page of the
wizard. Then, initialise the cluster after installation by running a
command like:

initdb -D ../data

from the PostgreSQL command prompt window (there's a shortcut on the
start menu). See
http://www.postgresql.org/docs/8.3/interactive/app-initdb.html for
more info on the initdb options.

Once that's done you should register PostgreSQL as a service - see the
'register' mode of pg_ctl:
http://www.postgresql.org/docs/8.3/interactive/app-pg-ctl.html

Those steps are roughly what the installer normally does for you.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Oracle-compatible database company

Re: BUG #3980: Can not Install PostgreSQL - error at the end of installation

From
Miroslav Nachev
Date:
I can not start that command because:

C:\Program Files\PostgreSQL\8.3\bin>initdb -D ../data
The program "postgres" is needed by initdb but was not found in the
same directory as "C:\Program Files\PostgreSQL\8.3\bin/initdb".
Check your installation.

In the same time there are 2 files with that name:
C:\Program Files\PostgreSQL\8.3\bin>dir postgres.*
 Volume in drive C is ACER
 Volume Serial Number is 7C12-D67C

 Directory of C:\Program Files\PostgreSQL\8.3\bin

01.02.2008 г.  04:00 ч.         3 661 824
postgres.exe
01.02.2008 г.  04:00 ч.         1 092 970
postgres.lib
               2
File(s)     4 754 794 bytes 
               0 Dir(s) 
110 786 924 544bytes free 


Miro.

Dave Page wrote:
<blockquote
 cite="mid:937d27e10802250748q30052f7au4fe00b6a07cfa1ce@mail.gmail.com"
 type="cite">
  On Mon, Feb 25, 2008 at 3:39 PM, Miroslav Nachev <miro@space-comm.com> wrote:




 To get up and running though, you should be able to install with
initdb disabled and then run it manually from the commandline.

 How to do the above?



When you install, un-check the initdb option on the initdb page of the
wizard. Then, initialise the cluster after installation by running a
command like:

initdb -D ../data

from the PostgreSQL command prompt window (there's a shortcut on the
start menu). See
http://www.postgresql.org/docs/8.3/interactive/app-initdb.html for
more info on the initdb options.

Once that's done you should register PostgreSQL as a service - see the
'register' mode of pg_ctl:
http://www.postgresql.org/docs/8.3/interactive/app-pg-ctl.html

Those steps are roughly what the installer normally does for you.

Re: BUG #3980: Can not Install PostgreSQL - error at the end of installation

From
"Dave Page"
Date:
T24gTW9uLCBGZWIgMjUsIDIwMDggYXQgNDo1NiBQTSwgTWlyb3NsYXYgTmFj
aGV2IDxtaXJvQHNwYWNlLWNvbW0uY29tPiB3cm90ZToKPgo+ICBJIGNhbiBu
b3Qgc3RhcnQgdGhhdCBjb21tYW5kIGJlY2F1c2U6Cj4KPiAgQzpcUHJvZ3Jh
bSBGaWxlc1xQb3N0Z3JlU1FMXDguM1xiaW4+aW5pdGRiIC1EIC4uL2RhdGEK
PiAgVGhlIHByb2dyYW0gInBvc3RncmVzIiBpcyBuZWVkZWQgYnkgaW5pdGRi
IGJ1dCB3YXMgbm90IGZvdW5kIGluIHRoZQo+ICBzYW1lIGRpcmVjdG9yeSBh
cyAiQzpcUHJvZ3JhbSBGaWxlc1xQb3N0Z3JlU1FMXDguM1xiaW4vaW5pdGRi
Ii4KPiAgQ2hlY2sgeW91ciBpbnN0YWxsYXRpb24uCj4KPiAgSW4gdGhlIHNh
bWUgdGltZSB0aGVyZSBhcmUgMiBmaWxlcyB3aXRoIHRoYXQgbmFtZToKPiAg
QzpcUHJvZ3JhbSBGaWxlc1xQb3N0Z3JlU1FMXDguM1xiaW4+ZGlyIHBvc3Rn
cmVzLioKPiAgIFZvbHVtZSBpbiBkcml2ZSBDIGlzIEFDRVIKPiAgIFZvbHVt
ZSBTZXJpYWwgTnVtYmVyIGlzIDdDMTItRDY3Qwo+Cj4gICBEaXJlY3Rvcnkg
b2YgQzpcUHJvZ3JhbSBGaWxlc1xQb3N0Z3JlU1FMXDguM1xiaW4KPgo+ICAw
MS4wMi4yMDA4IMcuICAwNDowMCDeLiAgICAgICAgIDMgNjYxIDgyNCBwb3N0
Z3Jlcy5leGUKPiAgMDEuMDIuMjAwOCDHLiAgMDQ6MDAg3i4gICAgICAgICAx
IDA5MiA5NzAgcG9zdGdyZXMubGliCj4gICAgICAgICAgICAgICAgIDIgRmls
ZShzKSAgICAgIDQgNzU0IDc5NCBieXRlcwo+ICAgICAgICAgICAgICAgICAw
IERpcihzKSAgMTEwIDc4NiA5MjQgNTQ0IGJ5dGVzIGZyZWUKClRoYXRzIHRo
ZSBidWcgZml4ZWQgaW4gbXkgcmVjZW50IHBhdGNoIHRoYXQgSSBtZW50aW9u
ZWQuIFVzZSBhIHVzZXIKYWNjb3VudCBvdGhlciB0aGFuIEFkbWluaXN0cmF0
b3IgYW5kIGl0IHNob3VsZCB3b3JrLgoKLS0gCkRhdmUgUGFnZQpFbnRlcnBy
aXNlREIgVUs6IGh0dHA6Ly93d3cuZW50ZXJwcmlzZWRiLmNvbQpUaGUgT3Jh
Y2xlLWNvbXBhdGlibGUgZGF0YWJhc2UgY29tcGFueQo=

Re: BUG #3980: Can not Install PostgreSQL - error at the end of installation

From
Miroslav Nachev
Date:
For the current case is used user "miro" with administrator rights. You
suggest me to remove administrator rights?


Miro.

Dave Page wrote:
<blockquote
 cite="mid:937d27e10802250914h4b38fec3g3c3bfcd002511068@mail.gmail.com"
 type="cite">
  On Mon, Feb 25, 2008 at 4:56 PM, Miroslav Nachev <miro@space-comm.com> wrote:


     I can not start that command because:

 C:\Program Files\PostgreSQL\8.3\bin>initdb -D ../data
 The program "postgres" is needed by initdb but was not found in the
 same directory as "C:\Program Files\PostgreSQL\8.3\bin/initdb".
 Check your installation.

 In the same time there are 2 files with that name:
 C:\Program Files\PostgreSQL\8.3\bin>dir postgres.*
  Volume in drive C is ACER
  Volume Serial Number is 7C12-D67C

  Directory of C:\Program Files\PostgreSQL\8.3\bin

 01.02.2008 Ç.  04:00 Þ.         3 661 824 postgres.exe
 01.02.2008 Ç.  04:00 Þ.         1 092 970 postgres.lib
                2 File(s)      4 754 794 bytes
                0 Dir(s)  110 786 924 544 bytes free



Thats the bug fixed in my recent patch that I mentioned. Use a user
account other than Administrator and it should work.

Re: BUG #3980: Can not Install PostgreSQL - error at the end of installation

From
Miroslav Nachev
Date:
Hi,

When I see the error I suppose that the kind of the problem is space in
the path: "C:\Program Files\PostgreSQL\8.3\bin". Then I use another
program path without space and the installation is successful. I mean
the regular installation, not patched.


Regards,
Miro.


Miroslav Nachev wrote:


For the current case is used user "miro" with administrator rights. You
suggest me to remove administrator rights?


Miro.

Dave Page wrote:
  <blockquote
 cite="mid:937d27e10802250914h4b38fec3g3c3bfcd002511068@mail.gmail.com"
 type="cite">
    On Mon, Feb 25, 2008 at 4:56 PM, Miroslav Nachev <a
 moz-do-not-send="true" class="moz-txt-link-rfc2396E"
 href="mailto:miro@space-comm.com"><miro@space-comm.com> wrote:


       I can not start that command because:

 C:\Program Files\PostgreSQL\8.3\bin>initdb -D ../data
 The program "postgres" is needed by initdb but was not found in the
 same directory as "C:\Program Files\PostgreSQL\8.3\bin/initdb".
 Check your installation.

 In the same time there are 2 files with that name:
 C:\Program Files\PostgreSQL\8.3\bin>dir postgres.*
  Volume in drive C is ACER
  Volume Serial Number is 7C12-D67C

  Directory of C:\Program Files\PostgreSQL\8.3\bin

 01.02.2008 Ç.  04:00 Þ.         3 661 824 postgres.exe
 01.02.2008 Ç.  04:00 Þ.         1 092 970 postgres.lib
                2 File(s)      4 754 794 bytes
                0 Dir(s)  110 786 924 544 bytes free



Thats the bug fixed in my recent patch that I mentioned. Use a user
account other than Administrator and it should work.

Re: BUG #3980: Can not Install PostgreSQL - error at the end of installation

From
"Dave Page"
Date:
2008/2/25 Miroslav Nachev <miro@space-comm.com>:
>
>  Hi,
>
>  When I see the error I suppose that the kind of the problem is space in the
> path: "C:\Program Files\PostgreSQL\8.3\bin". Then I use another program path
> without space and the installation is successful. I mean the regular
> installation, not patched.

Sorry, you mean the installer works completely, including the initdb
steps if you use a path containing no spaces? That's just bizarre -
there are thousands, probably hundreds of thousands of working
installations in paths containing spaces. I've done hundreds myself!


--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Oracle-compatible database company

Re: BUG #3980: Can not Install PostgreSQL - error at the end of installation

From
"Miroslav Nachev"
Date:
Yes, this is curious for me also.


Miro.

On 2/25/08, Dave Page <dpage@pgadmin.org> wrote:
>
> 2008/2/25 Miroslav Nachev <miro@space-comm.com>:
>
> >
> >  Hi,
> >
> >  When I see the error I suppose that the kind of the problem is space in
> the
> > path: "C:\Program Files\PostgreSQL\8.3\bin". Then I use another program
> path
> > without space and the installation is successful. I mean the regular
> > installation, not patched.
>
>
> Sorry, you mean the installer works completely, including the initdb
> steps if you use a path containing no spaces? That's just bizarre -
> there are thousands, probably hundreds of thousands of working
> installations in paths containing spaces. I've done hundreds myself!
>
>
>
> --
> Dave Page
> EnterpriseDB UK: http://www.enterprisedb.com
> The Oracle-compatible database company
>

Re: BUG #3980: Can not Install PostgreSQL - error at the end of installation

From
Aaron Tuwhangai
Date:
I have had a problem installing PostgreSQL with the same symptoms.  I think
whats happening is this: I try to install and get an error (something to do
with Java I think).  The installer rolls back, but leaves a tmp directory
behind.  Next time I try to install I get the error message about creating a
temporary directory that Miro mentions.  After I deleted the directories
left behind, the installer works (after playing around with my Java settings
to fix the first problem).

I think it started working for Miro because by changing the install path,
the tmp directory previously left behind was no longer interfering.

Maybe the installer could be fixed to remove the tmp directory during
install rollback?  My errors always occurred during the database
initialisation phase.



Dave Page-7 wrote:
>
> 2008/2/25 Miroslav Nachev <miro@space-comm.com>:
>>
>>  Hi,
>>
>>  When I see the error I suppose that the kind of the problem is space in
>> the
>> path: "C:\Program Files\PostgreSQL\8.3\bin". Then I use another program
>> path
>> without space and the installation is successful. I mean the regular
>> installation, not patched.
>
> Sorry, you mean the installer works completely, including the initdb
> steps if you use a path containing no spaces? That's just bizarre -
> there are thousands, probably hundreds of thousands of working
> installations in paths containing spaces. I've done hundreds myself!
>
>
> --
> Dave Page
> EnterpriseDB UK: http://www.enterprisedb.com
> The Oracle-compatible database company
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>
>

--
View this message in context:
http://www.nabble.com/BUG--3980%3A-Can-not-Install-PostgreSQL---error-at-the-end-of-installation-tp15635482p16366246.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.