Version 8.2.5 for Windows doesn't startup normally after upgrading from 8.2.4

From: "Walter Roeland" <wroeland(at)marcatel(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Version 8.2.5 for Windows doesn't startup normally after upgrading from 8.2.4
Date: 2007-09-18 19:58:36
Message-ID: 9D22EDA95B717C428B04F60A8272CFEC0164B9F8@mtelmy51.marcatel.ad
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message MargaretGillon 2007-09-18 22:06:32 Uninstall mess Postgresql 7.3.4, 8.1.4 on Redhat 9
Previous Message Felipe de Jesús Molina Bravo 2007-09-18 19:47:15 Re: Tsearch2 - spanish