Re: Can´t connect but listen address and pg_hba configured correctly

Did you purposely change the default port?  Are you specifying the
change in pgadmin?  If the pg_hba.conf file is the problem, pgadmin will
tell you with a message like:

FATAL: no pg_hba.conf entry for host "IPADDRESS", user "USER", database
"DATABASE", SSL ON/OFF

Are you getting a similar message or is the connection timing out?

Marcelo de Moraes Serpa wrote:
>  I can´t connect to my postgresql8.1 server running on Debian. The pgadmin
> client says it can't connect. I already edited the pg_hba.conf and
> postgresql.conf (listen_addresses = '*' and port) but the problem remains,
> pg_admin is running on a XP machine without Firewalls enabled, Debian is
> also not running any kind of firewall. I should also note the I just
> upgraded to 8.1, some minutes ago I was running 7.4 and connections **were
> working fine**.
>
> pg_hba.conf:
>
> http://www.pastebin.ca/980122
>
> postgresql.conf (connection settings section):
>
> http://www.pastebin.ca/980147
>
> PostgreSQL 8.1 Debain Etch package.
>
> Any hints greatly appreciated!
>
> Marcelo.
>

--

  Kyle Wilcox
  NOAA Chesapeake Bay Office
  410 Severn Avenue
  Suite 107A
  Annapolis, MD 21403
  office: (410) 295-3151
  Kyle.Wilcox@noaa.gov

  A: It takes over twice as long to understand the conversation.
  Q: What's wrong with top-posting?
  A: Top-posting.
  Q: What's the worst thing about plain text email discussions?