Can't open Postgres just after instalation (Win-XP, SP3)

This message was edited 4 times. Last update was at 1 Sep 2010 00:47:35

Hi you.

I have just installed Postgres Plus Standard Server 8.4 in Windows XP, SP3, for a 'Program Development Environment', but I am not being able to open it.

When I click the 'Start Server' icon at 'Start => Programs', the command style window 'Start Server' is showed with about the following text (parts are translated from Portuguese) :

"Start DoCmd(net star postgresql-8.4)...
It happened the system error 1069.
It wasn't possible to start the service due to a logon failure.
The start command returned an error (2)
Press <return> to continue..."

When I press <return>, the window disappear and nothing happen.

---------

Now, follows some information on the install-postgresql.log file (the error part) :

Script stderr:

Starting the database server...
Executing cscript //NoLogo "C:\Arquivos de programas\PostgresPlus\8.4SS\installer\server\startserver.vbs" postgresql-8.4
Script exit code: 1

Script output:
Starting postgresql-8.4
Failed to start the database server (15)

Script stderr:
Program ended with an error exit code

Error running cscript //NoLogo "C:\Arquivos de programas\PostgresPlus\8.4SS\installer\server\startserver.vbs" postgresql-8.4 : Program ended with an error exit code
Problem running post-install step. Installation may not complete correctly
Failed to start the database server.
Problem running post-install step. Installation may not complete correctly
Failed to start the database server.
Creating Uninstaller
Creating uninstaller 25%
Creating uninstaller 50%
Creating uninstaller 75%
Creating uninstaller 100%
Installation completed
Log finished 08/31/10 at 17:41:15

----

At the end of the install-postgresplus.log file, I found the following:

Script stderr:

Unable to start pgAgent : Service not responding
Creating Uninstaller
Creating uninstaller 25%
Creating uninstaller 50%
Creating uninstaller 75%
Creating uninstaller 100%
Installation completed
Log finished 08/31/10 at 16:40:19
Executing C:\Arquivos de programas\PostgresPlus\8.4SS/StackBuilderPlus/bin/stackbuilderplus.exe
Script exit code: SIGABRT

Script output:

Script stderr:
child killed: SIGABRT

Error running C:\Arquivos de programas\PostgresPlus\8.4SS/StackBuilderPlus/bin/stackbuilderplus.exe : child killed: SIGABRT

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

And at the end of install-pgagent.log file, I found the following:

Executing E:\ArqsTEMPs\MCR\pgAgent\bin\CreatePGPassconfForUser.exe postgres "****" localhost 5432 postgres postgres "****"
Script exit code: 2

Script output:

Script stderr:
ERROR: API = ChangeToAppData.
error code = 2.
message = O sistema não pode encontrar o arquivo especificado.
.

Could not create or modify the pgpass.conf file in the postgres's %APPDATA%\postgresql directory.
Executing C:\Arquivos de programas\PostgresPlus\8.4SS\pgAgent\bin\pgagent.exe REMOVE pgAgent
Script exit code: 0

Script output:

Script stderr:

Executing C:\Arquivos de programas\PostgresPlus\8.4SS\pgAgent\bin\pgagent.exe INSTALL pgAgent -u postgres -p "****" host=localhost port=5432 user=postgres dbname=postgres
Script exit code: 0

Script output:

Script stderr:

Unable to start pgAgent : Service not responding
Installation completed
Log finished 08/31/10 at 17:23:10

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

I didn't found errors at the other log files.

A last info, for now: I have XAMPP installed in my system. When I was installing Postgres, I read something that I understood (with some doubts) that would be good if I installed it with Apache running, and so I did. But I kept MySQL and the other XAMPP applications closed.

Could you help me ? Let me know if any additional information is needed.

Thanks a lot.

Marcos

Hello,

Can you please attach the (%TEMP%\install-postgresql.log) and (%TEMP%\install-pgagent.log)?

There is no need to install Apache before installing PostgreSQL/PostgresPlus Standard Server. Though it may not harm either.

This message was edited 1 time. Last update was at 1 Sep 2010 03:43:27

Hello, Sachin.

Sure. They are going here.

Thanks.

Marcos.

Hello,

For the pgAgent error, Can you let us know what is the value of %APPDATA% on your machine?

The postgresql log does not contain much info as it is a log for an upgradation. Can you uninstall this installation and delete/backup the data directory also. It would be better if you delete the 'postgres' user as well. (net user postgres /delete) and re try the installation. If it fails please share the installation log with us.

This message was edited 1 time. Last update was at 1 Sep 2010 08:54:11

Hi Sachin.

For the pgAgent error, Can you let us know what is the value of %APPDATA% on your machine?

I am supposing that you want C:\Documents and Settings\{username}\Application Data. If so, it is C:\Documents and Settings\Marcos\Dados de aplicativos. (Obs: In the \postgrestsql folder inside it, there is only one file, pgpass.conf, that is completely empty. )

I also noticed a new folder, C:\Documents and Settings\postgres, alongside the normal ones: All users, Default users, Marcos, ... It has the same subfolders of Default users and 3 exclusive files: NTUSER.DAT, NTUSER.DAT.LOG and ntuser.ini. Maybe this helps.

The postgresql log does not contain much info as it is a log for an upgradation.

I only instaled it one time. After that, I run the StackBuilder Plus 2 times.

Can you uninstall this installation and delete/backup the data directory also.

Sure. What data directory is this ? Please, specify.

It would be better if you delete the 'postgres' user as well. (net user postgres /delete) and re try the installation.

Could you say step-by-step how do I delete the 'postgres' user ? And should I uninstall before the reinstall ?

If it fails please share the installation log with us.

I am waiting your answer before reinstalling.

Marcos.

Hello,

For pgAgent, please delete the postgresql subfolder and the pgpass.conf file from the %APPDATA% folder.

For postgresql, see below:

1) Uninstall the postgresplus using the uninstaller (See Add/Remove Programs) or there is a uninstaller in the "C:\Arquivos de programas\PostgresPlus\8.4SS" directory it should be uninstall-postgresplus.exe (and not uninstall-postgresql.exe)

2) Remove the directory "C:\Arquivos de programas\PostgresPlus\8.4SS\data" [Value taken from log you sent earlier]

3) Open a command prompt and type "net user postgres /delete" [This will delete the user].

4) Start the installation again.

(You can choose to deselect the pgAgent installation from the Components screen and later try to install it using the StackbuilderPlus). I am just trying to separate 2 errors here.

This message was edited 2 times. Last update was at 1 Sep 2010 10:58:13

Hi Sachin.

I did as you recommended: I deselect the pgAgent installation from the Components screen to try to install it later using the StackbuilderPlus.

During installation, there was 1 error message, but when I tried to move it's window to see the name of the file behind it, it simply disappeared and the installation continued.

After the installation, everything seemed ok : I could start, stop and restart the server and the command-like window showed success messages.

Then I second-clicked the Postgre tray icon and found that there were 7 updates available. I determined its installation. (I didn't restarted Windows between. Maybe it was an error.) Several updates went OK, but then, at the finish of a long one, it was displayed the following message:

"The installation of Postgres Database Server returned an error.
Click on the OK button to ignore this error and continue with any remaining installations, or click Cancel to abort the remaining installations.
Note that ignoring this error may result in failure of any later installations that depend on this one."

This same message was displayed the first time I had installed Postgre, at this same stage. That occasion, I clicked OK, and you know what happened. This time, I resolved to wait for your advice before any action. So, the window that shows this message is yet open.

This time, based in our conversation, I also took the care of copying the log files of the installation, before running the 7 updates. It seems I did well, because some were replaced during the updating process. I am attaching the 2 install-postgresql.log files here. I added "-1" at the end of the name of the installation file.

Well, what button shall I choose ?

Thanks.

Marcos

PS: Does the log files contain any information that open my computer to hacker attacks ?

This message was edited 2 times. Last update was at 2 Sep 2010 05:06:46

Hello,

First of all thanks to you for uncovering a small bug in the installer.

You can choose any of the buttons as it doesn't matter as the problem was at our end. I will keep you informed as soon as it gets rectified.

This message was edited 1 time. Last update was at 2 Sep 2010 09:54:22

Hi Sachin.

I'm happy I helped.

I opted for the Cancel button and, after some installation, the same window reappeared. This happened 2 times. So, the only alternative was the OK button, that ended the process.

I will uninstall the package as before and wait for its repaired version.

Meanwhile, I would like to now about the postscript (PS) of my last message.

Also in the meanwhile, I am considering to install the 8.3 version. Is it without the bug ? And how to update to the 8.4 when it is repaired ? Should it be installed over the 8.3 or should the 8.3 be uninstalled first ?

Thanks.

Marcos

Hello,

Posting of the logs here will not open up any security concerns.

You can have 8.3 installed on your system, However, 8.4 will not update 8.3 but will be installed as a parallel install. You can install the 8.4 with the installer you have, Just dont try to upgrade it to 8.4.4 (installed one will be 8.4.1). We will be fixing the update sometime later today.. So once done you can easily upgrade that also..

Thanks again Sachin.

Everything is clear.

As you will fix the problem so quickly, I will wait for it and install the 8.4.4 version. Please, tell me when it is done.

Best regards.

Marcos

Hello,

Thats now being fixed. You can use StackbuilderPlus to update the 8.4.1 to 8.4.4 now.

Thanks for your patience.