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@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------