Thread: PgAdmin & PosgreSQL Plus Setup
I have PostgreSQL Plus setup on windows 2008 running on a vmware virtual machine on my Vista box. How can I connect to it from PgAdmin from my Vista box? http://www.nabble.com/file/p23064663/err-postgres-pgadmin1.png err-postgres-pgadmin1.png http://www.nabble.com/file/p23064663/err-postgres-pgadmin2.png err-postgres-pgadmin2.png -- View this message in context: http://www.nabble.com/PgAdmin---PosgreSQL-Plus-Setup-tp23064663p23064663.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On 15/04/2009 19:44, mrLami wrote: > http://www.nabble.com/file/p23064663/err-postgres-pgadmin1.png > err-postgres-pgadmin1.png > http://www.nabble.com/file/p23064663/err-postgres-pgadmin2.png > err-postgres-pgadmin2.png The second image says there's a problem with your pg_hba.conf. What does it say in the server log? Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
Find server log message below http://www.nabble.com/file/p23069775/pglog.txt pglog.txt - mrLami... Raymond O'Donnell wrote: > > On 15/04/2009 19:44, mrLami wrote: > >> http://www.nabble.com/file/p23064663/err-postgres-pgadmin1.png >> err-postgres-pgadmin1.png >> http://www.nabble.com/file/p23064663/err-postgres-pgadmin2.png >> err-postgres-pgadmin2.png > > The second image says there's a problem with your pg_hba.conf. What does > it say in the server log? > > Ray. > > ------------------------------------------------------------------ > Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland > rod@iol.ie > Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals > ------------------------------------------------------------------ > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > -- View this message in context: http://www.nabble.com/PgAdmin---PosgreSQL-Plus-Setup-tp23064663p23069775.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
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 ------------------------------------------------------------------