Search Postgresql Archives

Re: Pgadmin access to Postgresql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Luciano Martin Galletti <galletti77@xxxxxxxxxxx> writes:
> The server doesn't accept connections: the connection library reports
> could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "IP_OF_THE_SERVER" and accepting TCP/IP connections on port 5432?

> Do i have to set something in pg_hba.conf

Probably, because what you showed doesn't include any line permitting
external connections; but that's not your problem yet.  "Connection
refused" is a network-level error: your connection is never getting to the
Postgres server.  Double-check addresses, check network connectivity,
check firewall settings.  My first bet is you need to poke a hole in the
server machine's firewall --- see iptables or local equivalent.  Another
possibility is that the server's listen_addresses setting only tells it
to listen for local TCP connections not remote ones.  You typically want
listen_addresses set to "*" if you intend to allow remote connections.

When you start getting complaints phrased along the lines of "no
pg_hba.conf entry" then it'll be time to fix pg_hba.conf.

			regards, tom lane


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux