Search Postgresql Archives

Re: Unable to (re) start PostgreSQL 8.4.4/WinXP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux