The server does not start

This message was edited 1 time. Last update was at 5 Jan 2009 07:41:15

Hi,

I'm trying to install PostgresSQL on windows XP, so i get the postgresql-8.3.5-2-windows installer but at 99% or 100% of the setup it caused an error
---------------------------------------------------------------------------
| "An unhandled win32 exception occurred in postgres.exe" |
---------------------------------------------------------------------------
however the setup finished and said that was successful. It launched Application Stack builder and all went fine.

Wen I launched pgAdminIII the server was not running I tried to connect the server i gave me the following error:

-------------------------------------------------------------------------------------------------------------------------
| An error has occurred: |
| Error connecting to the sever: could not conect to the server: Connection refused (0x0000274D/10061) |
| The server is running on "127.0.0.1" and accepting TCP/IP connections on port 5432? |
-----------------------------------------------------------------------------------------------------------------------------

And I tried to start the server with the Start Server executable and the following text appears:

--------------------------------------------------------------------------------
| The service PostgreSQL Server 8.3 is initiating .............. |
| It was not possible initiate the Service PostgreSQL Server 8.3 |
| |
| The Service has not reported one error |
| |
| For more help write NET HELPMSG 3534 |
---------------------------------------------------------------------------------

The version 8.2 runs perfectly

Thanks in advance,
Filipe Apóstolo.

Please check the contents of installation log file i.e.

SYSTEM_TEMP_DIRECTORY\install-postgresql.log

Please post the contents of that file (Error Part if any).

A possibility is initdb failed due to some reasons.

Regards,
Sachin Srivastava
www.enterprisedb.com

Ok, I found the log file :

Preferred installation mode : win32
Trying to init installer in mode win32
Mode win32 successfully initted
Existing base directory: C:\Program Files\PostgreSQL\8.3
Existing data directory: C:\Program Files\PostgreSQL\8.3\data
Executing cscript
Script exit code: 0

Script output:
Executing the runtime installer: C:\Documents and Settings\Developer\Defini‡äes locais\Temp\postgresql_installer\vcredist_x86.exe
installruntimes.vbs ran to completion

Script stderr:

Executing C:\Documents and Settings\Developer\Definições locais\Temp\postgresql_installer\pg_controldata.exe
Script exit code: 0

Script output:
pg_control version number: 833
Catalog version number: 200711281
Database system identifier: 5287772214884694512
Database cluster state: shut down
pg_control last modified: 05-01-2009 11:36:51
Latest checkpoint location: 0/4962C0
Prior checkpoint location: 0/496248
Latest checkpoint's REDO location: 0/4962C0
Latest checkpoint's TimeLineID: 1
Latest checkpoint's NextXID: 0/387
Latest checkpoint's NextOID: 11512
Latest checkpoint's NextMultiXactId: 1
Latest checkpoint's NextMultiOffset: 0
Time of latest checkpoint: 05-01-2009 11:36:51
Minimum recovery ending location: 0/0
Maximum data alignment: 8
Database block size: 8192
Blocks per segment of large relation: 131072
WAL block size: 8192
Bytes per WAL segment: 16777216
Maximum length of identifiers: 64
Maximum columns in an index: 32
Maximum size of a TOAST chunk: 1996
Date/time type storage: 64-bit integers
Maximum length of locale name: 128
LC_COLLATE: Portuguese_Brazil.1252
LC_CTYPE: Portuguese_Brazil.1252

Script stderr:

Existing cluster catalog version: 200711281, installer catalog version: 200711281
Switching to upgrade mode with cluster: C:\Program Files\PostgreSQL\8.3\data
Reading port number from C:\Program Files\PostgreSQL\8.3\data/postgresql.conf
Executing C:\Documents and Settings\Developer\Definições locais\Temp\postgresql_installer\validateuser.exe
Script exit code: 0

Script output:
C:\DOCUME~1\DEVELO~1\DEFINI~1\Temp\POSTGR~1\VALIDA~1.EXE ran to completion

Script stderr:

Preparing to Install
Creating directory C:\Program Files\PostgreSQL\8.3
Creating directory C:\Program Files\PostgreSQL\8.3\bin
Creating directory C:\Program Files\PostgreSQL\8.3\doc
Creating directory C:\Program Files\PostgreSQL\8.3\doc\contrib
.......
......
Unpacking files
Unpacking C:\Program Files\PostgreSQL\8.3\bin\clusterdb.exe
Unpacking C:\Program Files\PostgreSQL\8.3\bin\comerr32.dll
Unpacking C:\Program Files\PostgreSQL\8.3\bin\createdb.exe
...............
...............

Running the post-installation/upgrade actions:
Delete the temporary scripts directory...
Write the base directory to the ini file...
Write the version number to the ini file...
Creating service user account...
Executing C:\Program Files\PostgreSQL\8.3\installer\server\createuser.exe
Script exit code: 0

Script output:
User account 'TECKVM\postgres' already exists.
C:\PROGRA~2\POSTGR~1\8.3\INSTAL~1\server\CREATE~1.EXE ran to completion

Script stderr:

Configuring database server startup...
Executing cscript
Script exit code: 0

Script output:
startupcfg.vbs ran to completion

Script stderr:

Creating menu shortcuts...
Executing cscript
Script exit code: 0

Script output:
createshortcuts.vbs ran to completion

Script stderr:

Starting the database server...
Executing cscript
Script exit code: 0

Script output:
Starting postgresql-8.3
Service postgresql-8.3 started successfully
startserver.vbs ran to completion

Script stderr:

Write the data directory to the ini file...
Write the port number, service ID, locale and superuser to the ini file...
Write the server description to the ini file...
Finished running post-installation/upgrade tasks.
Creating Uninstaller
Creating uninstaller 25%
Creating uninstaller 50%
Creating uninstaller 75%
Creating uninstaller 100%
Installation completed

But here it seems all ok.

It looks like you have ran the installer more than one time, as from logs

Existing base directory: C:\Program Files\PostgreSQL\8.3
Existing data directory: C:\Program Files\PostgreSQL\8.3\data

or you must have a postgresql 8.3 installed before.

try a fresh installation (with new data directory) and see if the problem persists.
(You can also delete the postgres user if you want)

Yes, a run the installer twice, the second time was because I tough that the log file was in windows Temp directory and that directory was empty, so I run the second time to see if the file appears, however the directory was in my user definitions Temp folder.
But the problem is the same as before. And the strange thing is that I don't heave problems with 8.2.x, I installed over the 8.3 installation (after my previous posts) and now I see both services (8.2 and 8.3) with pgAdmin. And I'm working fine with 8.2, however I would like to upgrade to 8.3.

Same problem here. The postgre.exe crashes but the instalation is OK. I tried to start the service in tree PCs with Windows XP.
The previous version works fine.

Same problem here. The instalation is OK but the postgres.exe crashes when starting the service.
I tried in tree PCs with Windows XP but the result is the same.

The previous version works fine.

Hi.

I tried to install PostgreSQL in a Windows XP machine, without anything installed (just firefox

).

In the file bitrock_installer.log the following errors appear:

The machine where I install the software is an virtualbox machine. Can we have a problem with the installation of the PostgreSQL in a virtual machine?

The machine where I install the software is an virtualbox machine. Can we have a problem with the installation of the PostgreSQL in a virtual machine?

Only if 8.3 has problems with virtual machine, because I use 8.2 in VBox without problems.

This message was edited 2 times. Last update was at 8 Jan 2009 07:24:28

No solutions?? It seems to be a bug with postgre 8.3.5 and Windows XP to me since 8.3.4 works fine.
I noticed the locale is set to portuguese brazil. Same as mine. I will try with english.

Hi,

I have a similar problem. I'm however trying to install postgresql-8.3.5-2-windows installer on Vista Home Premium. When the installation is almost complete I get this error message:

"Problem running post-install step. Installation may not complete correctly. The database cluster initialisation failed". Any idea why. I've tried to disable my virus scanner but that didn't help.

When I try to start of restart the server I get an error.

Anybody got a link to version 8.3.4?

Anybody got a solution?

Thanks
Jens

Hi

I had the same problem. I got mine working by re-installing after logging in as administrator on the local machine. I tried this because I got some other programs working this way. If I remain logged in on the domain while installing, the server does not want to start. Now it is running fine.

Louis