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

Поиск
Список
Период
Сортировка
От Walter Roeland
Тема Version 8.2.5 for Windows doesn't startup normally after upgrading from 8.2.4
Дата
Msg-id 9D22EDA95B717C428B04F60A8272CFEC0164B9F8@mtelmy51.marcatel.ad
обсуждение исходный текст
Ответы Re: Version 8.2.5 for Windows doesn't startup normally after upgrading from 8.2.4  (Dave Page <dpage@postgresql.org>)
Список 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 по дате отправления:

Предыдущее
От: Felipe de Jesús Molina Bravo
Дата:
Сообщение: Re: Tsearch2 - spanish
Следующее
От: MargaretGillon@chromalloy.com
Дата:
Сообщение: Uninstall mess Postgresql 7.3.4, 8.1.4 on Redhat 9