Skip site navigation (1) Skip section navigation (2)

Problem Upgrading from 8.0 to 8.1 (WinXP) ...not still solved!!

From: Info <info(at)juliusonline(dot)it>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Problem Upgrading from 8.0 to 8.1 (WinXP) ...not still solved!!
Date: 2005-11-22 12:52:25
Message-ID: op.s0m7dnwefjxods@mail.191.it (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

I have Still the same problems with the upgrading from 8.0 to 8.1.

I uninstalled the old version first and then i installed the 8.1 release
with an error message about ssleay32 library and some error messages about
the ┬źActivating procedural languages...┬╗ as this

************************************
*** from postgresql-8.1.log file ***
************************************
[...]
Action 11.55.11: InstallPl. Activating procedural languages...
MSI (s) (78:6C) [11:55:11:765]: Executing op:
CustomActionSchedule(Action=InstallPl,ActionType=1025,Source=BinaryData,Target=InstallPl(at)4,CustomActionData=1033;postgres;postgres;5432;C:\Programmi\PostgreSQL\8.1\share\;1;;;;;;;)
MSI (s) (78:D8) [11:55:11:828]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI3F.tmp, Entrypoint: InstallPl(at)4
MSI (c) (A0:A4) [11:55:24:453]: Note: 1: 2205 2:  3: Error
MSI (c) (A0:A4) [11:55:24:453]: Note: 1: 2228 2:  3: Error 4: SELECT
`Message` FROM `Error` WHERE `Error` = 2867
DEBUG: Error 2867:  The error dialog property is not set
The installer has encountered an unexpected error installing this package.
This may indicate a problem with this package. The error code is 2867. The
arguments are: , ,
MSI (c) (A0:A4) [11:55:24:468]: Font created.  Charset: Req=0, Ret=0,
Font: Req=MS Shell Dlg, Ret=MS Shell Dlg

Failed to connect to the database. Procedural languages files are
installed, but are not activated in any databases.
[...]
************************************



So the problem is simple:
Connecting by PgAdmin (but also by psql.exe), in the filelog appears this

*****************************
*** from pgadmin.log file ***
*****************************
[...]
2005-11-10 12:48:55 INFO   : Destroying an options dialogue
2005-11-10 12:48:57 INFO   : Attempting to create a connection object...
2005-11-10 12:48:57 INFO   : Creating a connect dialogue
2005-11-10 12:49:03 INFO   : Destroying a connect dialogue
2005-11-10 12:49:04 STATUS : Connecting to database...
2005-11-10 12:49:04 INFO   : Creating pgConnBase object
2005-11-10 12:49:04 INFO   : Server name: localhost (resolved to:
127.0.0.1)
2005-11-10 12:49:04 INFO   : Opening connection with connection string:
host='localhost' hostaddr='127.0.0.1' dbname='postgres' user='postgres'
password='postgres' port=5432
2005-11-10 12:49:04 STATUS : Connecting to database... (0,33 secs)
2005-11-10 12:49:04 ERROR  : Error connecting to the server: server closed
the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.

2005-11-10 12:49:05 INFO   : Destroying pgConnBase object
*****************************



I uninstalled and installed again postgres-8.1, also removing manually any
keys and values from the Windows registry before reinstalling, but with
same results.

Why????

Where are problems?

Thanks.
Fra.
-- 
Creato con M2, il rivoluzionario client e-mail di Opera:  
http://www.opera.com/m2/


pgsql-novice by date

Next:From: operationsengineer1Date: 2005-11-22 18:17:07
Subject: WinXP Apache2, PHP5 and PGSQL8 Install Instructions Online
Previous:From: Charles BaiDate: 2005-11-22 03:13:00
Subject: confused by role, privileges, and permission issues

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group