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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
