Re: Problem Upgrading from 8.0 to 8.1 (WinXP) ...not still solved!! - Mailing list pgsql-novice

On 1/6/06, Info <info@juliusonline.it> wrote:
> 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.
> --
> Creato con M2, il rivoluzionario client e-mail di Opera:
> http://www.opera.com/m2/
>
>

I have a lot of services disabled and just try to upgrade and i see no
errors... i was hoping to find your and Ilias bug...

have you seen if you have remote login service running?

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)