Re: Problem Upgrading from 8.0 to 8.1 (WinXP) ...not still solved!! - Mailing list 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@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@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.

i'll assume you deleted the postgres user and service
when you deleted the 8.0 version.  if so, i'd
recommend reinstalling the 8.0 version and then
upgrading to 8.1 via the upgrade script.

that won't troubleshoot this problem, but it may get
you productive again.

also, you may want to report this problem to
pgsql-ports.  they may be able to help resolve this
problem.

http://archives.postgresql.org/pgsql-ports/

best of luck.



__________________________________________
Yahoo! DSL – Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com