Re: PgAdmin & PosgreSQL Plus Setup

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