Thread: Unable to (re) start PostgreSQL 8.4.4/WinXP
I have PostgreSQL 8.4.4 on Windows XP. I cannot get the service to (re) start. At first installation, the service started up fine, but I couldn't access the DB remotely. So I changed the pg_hba.conf file and the postgresql.conf file as suggested. Now, the service seems to take forever to start up (appears to hang), then "dies" with the message: "The postgresql-8.4-PostgreSQL Server 8.4 service on Local Computer started and then stopped. Some services start automatically if they have no work to do, for example, the Performance Logs and Alerts service." My pg_hba.conf file has the following line: host all all 192.168.0.1/24 trust If I remove the line, the server starts up instantly. If I restore the line, the server takes for ever to start-up and ends up with the same error in this thread. My listen_addresses value is set to '*'. The postgres user already has full permissions on all the folders, including data and pg_log. Any suggestions? Thanks in advance. -- View this message in context: http://old.nabble.com/Unable-to-%28re%29-start-PostgreSQL-8.4.4-WinXP-tp28875697p28875697.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
kunalashar wrote: > I have PostgreSQL 8.4.4 on Windows XP. I cannot get the service to (re) > start. > > At first installation, the service started up fine, but I couldn't access > the DB remotely. So I changed the pg_hba.conf file and the postgresql.conf > file as suggested. > > Now, the service seems to take forever to start up (appears to hang), then > "dies" with the message: "The postgresql-8.4-PostgreSQL Server 8.4 service > on Local Computer started and then stopped. Some services start > automatically if they have no work to do, for example, the Performance Logs > and Alerts service." > > My pg_hba.conf file has the following line: > host all all 192.168.0.1/24 trust > > If I remove the line, the server starts up instantly. If I restore the line, > the server takes for ever to start-up and ends up with the same error in > this thread. > > My listen_addresses value is set to '*'. > > The postgres user already has full permissions on all the folders, including > data and pg_log. > any errors in the latest file in pg_log ?
The pg_log files contain, rather inexplicably: 2010-06-14 09:47:32 IST LOG: invalid IP mask "trust": Unknown host 2010-06-14 09:47:32 IST CONTEXT: line 74 of configuration file "E:/Data/PostgreSQL/8.4/data/pg_hba.conf" 2010-06-14 09:47:32 IST FATAL: could not load pg_hba.conf 2010-06-14 09:45:06 IST LOG: invalid IP mask "md5": Unknown host 2010-06-14 09:45:06 IST CONTEXT: line 74 of configuration file "E:/Data/PostgreSQL/8.4/data/pg_hba.conf" 2010-06-14 09:45:06 IST FATAL: could not load pg_hba.conf 2010-06-14 09:45:06 IST LOG: invalid IP mask "md5": Unknown host 2010-06-14 09:45:06 IST CONTEXT: line 74 of configuration file "E:/Data/PostgreSQL/8.4/data/pg_hba.conf" 2010-06-14 09:45:06 IST FATAL: could not load pg_hba.conf 2010-06-14 09:37:36 IST LOG: invalid connection type "all " 2010-06-14 09:37:36 IST CONTEXT: line 70 of configuration file "E:/Data/PostgreSQL/8.4/data/pg_hba.conf" 2010-06-14 09:37:36 IST LOG: invalid CIDR mask in address "192.168.0.0/255" 2010-06-14 09:37:36 IST CONTEXT: line 74 of configuration file "E:/Data/PostgreSQL/8.4/data/pg_hba.conf" 2010-06-14 09:37:36 IST FATAL: could not load pg_hba.conf -- View this message in context: http://old.nabble.com/Unable-to-%28re%29-start-PostgreSQL-8.4.4-WinXP-tp28875697p28875911.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
kunalashar wrote: > The pg_log files contain, rather inexplicably: > > 2010-06-14 09:47:32 IST LOG: invalid IP mask "trust": Unknown host > 2010-06-14 09:47:32 IST CONTEXT: line 74 of configuration file > "E:/Data/PostgreSQL/8.4/data/pg_hba.conf" > 2010-06-14 09:47:32 IST FATAL: could not load pg_hba.conf > > > 2010-06-14 09:45:06 IST LOG: invalid IP mask "md5": Unknown host > 2010-06-14 09:45:06 IST CONTEXT: line 74 of configuration file > "E:/Data/PostgreSQL/8.4/data/pg_hba.conf" > 2010-06-14 09:45:06 IST FATAL: could not load pg_hba.conf > > > 2010-06-14 09:45:06 IST LOG: invalid IP mask "md5": Unknown host > 2010-06-14 09:45:06 IST CONTEXT: line 74 of configuration file > "E:/Data/PostgreSQL/8.4/data/pg_hba.conf" > 2010-06-14 09:45:06 IST FATAL: could not load pg_hba.conf > > > 2010-06-14 09:37:36 IST LOG: invalid connection type "all > " > 2010-06-14 09:37:36 IST CONTEXT: line 70 of configuration file > "E:/Data/PostgreSQL/8.4/data/pg_hba.conf" > 2010-06-14 09:37:36 IST LOG: invalid CIDR mask in address "192.168.0.0/255" > 2010-06-14 09:37:36 IST CONTEXT: line 74 of configuration file > "E:/Data/PostgreSQL/8.4/data/pg_hba.conf" > 2010-06-14 09:37:36 IST FATAL: could not load pg_hba.conf > > sounds liek there's more than just the entry you gave us before... > My pg_hba.conf file has the following line: > host all all 192.168.0.1/24 trust > which, btw, is probably wrong. with a mask of /24 (which is equivalent to 255.255.255.0, eg 24 '1's), the IP part would have to be 192.168.0.0 (as in this context, thats the network number). your last error, /255 is under no conditions a valid CIDR mask length.