On 16/04/2009 01:59, mrLami wrote: > Find server log message below > > http://www.nabble.com/file/p23069775/pglog.txt pglog.txt Please paste log extracts, error messages, etc, into the email itself rather than just links to them: it makes the thread easier for others to follow, and in particular it means that the details are in the searchable archives. Also, please avoid top-posting, for the same reasons. Thanks! :-) To your question....these bits jumped out at me: 2009-04-15 14:29:18 EDT FATAL: no pg_hba.conf entry for host "172.30.142.45", user "postgres", database "postgres", SSL off [snip] 2009-04-15 14:31:13 EDT FATAL: no pg_hba.conf entry for host "172.30.142.45", user "postgres", database "postgres", SSL off [snip] 2009-04-15 14:32:08 EDT FATAL: no pg_hba.conf entry for host "172.30.142.45", user "postgres", database "postgres", SSL off [snip] 2009-04-15 14:32:34 EDT FATAL: no pg_hba.conf entry for host "172.30.142.45", user "postgres", database "postgres", SSL off [snip] 2009-04-15 14:32:40 EDT FATAL: no pg_hba.conf entry for host "172.30.142.45", user "postgres", database "postgres", SSL off [snip] These bits mean that you need to add an entry in pg_hba.conf for the postgres user from the client host. 2009-04-15 14:34:12 EDT FATAL: missing or erroneous pg_hba.conf file This bit says that there's a syntax error in one of the entries in pg_hba.conf.... 2009-04-15 14:42:23 EDT LOG: invalid IP mask "md5" in file "C:/PostgresPlus/8.3/data/pg_hba.conf" line 72: Unknown host 2009-04-15 14:42:23 EDT FATAL: missing or erroneous pg_hba.conf file ...and this bit tells you exactly what the problem is. Read the docs in pg_hba.conf itself, or here - http://www.postgresql.org/docs/8.3/static/auth-pg-hba-conf.html - and correct the error - without seeing the file, I'd guess you've left out the host address. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
