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
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 |