Version 8.2.5 for Windows doesn't startup normally after upgrading from 8.2.4 - Mailing list pgsql-general

From Walter Roeland
Subject Version 8.2.5 for Windows doesn't startup normally after upgrading from 8.2.4
Date
Msg-id 9D22EDA95B717C428B04F60A8272CFEC0164B9F8@mtelmy51.marcatel.ad
Whole thread Raw
Responses Re: Version 8.2.5 for Windows doesn't startup normally after upgrading from 8.2.4
List pgsql-general
Hello,

I just upgraded from 8.2.4 to 8.2.5 on Windows but the service doesn't
startup normally.
This is the first time I have trouble with an upgrade of version 8.2.
I have the following non standard configuration:
 - Program directory: C:\Archivos de programa\PostgreSQL\8.2\bin
 - Data Directory: D:\PostgreSQL\data
 - SSL ON
 - Working database is IOP_IPR (there is no POSTGRES database)
---------
When using
    pg_ctl start -D D:\PostgreSQL\data\
The server comes up normally, 2 messages appear:
    LOG:  could not load root certificate file "root.crt": No such
file or directory
    DETAIL:  Will not verify client certificates.
The log file contains only:
2007-09-18 14:36:25    LOG:  database system was shut down at 2007-09-18
14:33:27
2007-09-18 14:36:25    LOG:  checkpoint record is at 29/D1D4100
2007-09-18 14:36:25    LOG:  redo record is at 29/D1D4100; undo record
is at 0/0; shutdown TRUE
2007-09-18 14:36:25    LOG:  next transaction ID: 0/326345; next OID:
42275
2007-09-18 14:36:25    LOG:  next MultiXactId: 1; next MultiXactOffset:
0
2007-09-18 14:36:25    LOG:  database system is ready

---------
When started as a service with the following value of
pgsql-8.2\ImagePath in the registry:
    "C:\Archivos de programa\PostgreSQL\8.2\bin\pg_ctl.exe"
runservice -w -N "pgsql-8.2" -D "D:\PostgreSQL\data\"

The log file contains:
2007-09-18 14:28:34    LOG:  database system was shut down at 2007-09-18
14:26:02
2007-09-18 14:28:34    LOG:  checkpoint record is at 29/D1D4060
2007-09-18 14:28:34    LOG:  redo record is at 29/D1D4060; undo record
is at 0/0; shutdown TRUE
2007-09-18 14:28:34    LOG:  next transaction ID: 0/326343; next OID:
42275
2007-09-18 14:28:34    LOG:  next MultiXactId: 1; next MultiXactOffset:
0
2007-09-18 14:28:34    LOG:  could not load root certificate file
"root.crt": No such file or directory
2007-09-18 14:28:34    DETAIL:  Will not verify client certificates.
2007-09-18 14:28:34    LOG:  database system is ready
2007-09-18 14:28:35 127.0.0.1 postgres postgres FATAL:  the database
system is starting up

And then an endless list of
2007-09-18 14:28:35    LOG:  could not load root certificate file
"root.crt": No such file or directory
2007-09-18 14:28:35    DETAIL:  Will not verify client certificates.
2007-09-18 14:28:35 127.0.0.1 postgres postgres FATAL:  database
"postgres" does not exist
2007-09-18 14:28:36    LOG:  could not load root certificate file
"root.crt": No such file or directory
2007-09-18 14:28:36    DETAIL:  Will not verify client certificates.
2007-09-18 14:28:36 127.0.0.1 postgres postgres FATAL:  database
"postgres" does not exist

And I have to abort the startup.

Maybe the next is a hint:
When I had blocked the access to localhost with SSL=ON (using hostnossl
pg_hba.conf) there was a constant complaint (2 times per second) with:
127.0.0.1 postgres postgres FATAL:  no pg_hba.conf entry for host
"127.0.0.1", user "postgres", database "postgres", SSL on

---------
Have I something wrong with the configuration of the service?

Thanks on forehand.

--------------
Walter Roeland


pgsql-general by date:

Previous
From: Felipe de Jesús Molina Bravo
Date:
Subject: Re: Tsearch2 - spanish
Next
From: MargaretGillon@chromalloy.com
Date:
Subject: Uninstall mess Postgresql 7.3.4, 8.1.4 on Redhat 9