Обсуждение: Problem Upgrading from 8.0 to 8.1 (WinXP) ...not still solved!!
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/
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 ;)
> 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