Обсуждение: Urgent
Hi,
I am using Redhat linux 9. i had configure in pg_hba.conf as
host postgres postgres 10.10.0.76 255.255.255.0 password
If i try to connect with postgresql admin i am getting excpetion as
An erro has occured:
Error connecting to the server: could not connect to server:
Connection refuesed(0x0000274D/10061)
Is the server running on host "10.10.0.76" and accepting
TCP/IP connections on port 5432?
Please help me.
--
Warm Regards,
S.ElayaRaja
Mobile: (+91) 98450 59540
E-Mail: elayaraja.s@gmail.com
raja_nk@hotmail.com
Thank you for posting to a better list for these questions. Check your postgresql.conf file and make sure it's accepting TCP/IP connections on the IP you're looking for. If you look in your PGDATA directory you should find the config file, and if you open it and read it, it's well commented so you should be able to find the settting you need to tweak. Regards, Gavin ElayaRaja S wrote: >Hi, >I am using Redhat linux 9. i had configure in pg_hba.conf as >host postgres postgres 10.10.0.76 255.255.255.0 password > >If i try to connect with postgresql admin i am getting excpetion as > >An erro has occured: > >Error connecting to the server: could not connect to server: >Connection refuesed(0x0000274D/10061) > Is the server running on host "10.10.0.76" and accepting > TCP/IP connections on port 5432? > >Please help me. > > >
have you enabled tcp in postgresql.conf ? the parameter in question is pretty much on top of the file and should read tcpip_socket = true usually postgresql.conf is in /var/lib/pgsql/data/ on a RH system UC On Monday 18 April 2005 11:55, ElayaRaja S wrote: > Hi, > I am using Redhat linux 9. i had configure in pg_hba.conf as > host postgres postgres 10.10.0.76 255.255.255.0 password > > If i try to connect with postgresql admin i am getting excpetion as > > An erro has occured: > > Error connecting to the server: could not connect to server: > Connection refuesed(0x0000274D/10061) > Is the server running on host "10.10.0.76" and accepting > TCP/IP connections on port 5432? > > Please help me. -- Open Source Solutions 4U, LLC 2570 Fleetwood Drive Phone: +1 650 872 2425 San Bruno, CA 94066 Cell: +1 650 302 2405 United States Fax: +1 650 872 2417
On Monday 18 April 2005 21:07, Gavin M. Roy wrote: > Thank you for posting to a better list for these questions. Check > your postgresql.conf file and make sure it's accepting TCP/IP > connections on the IP you're looking for. If you look in your PGDATA > directory you should find the config file, and if you open it and > read it, it's well commented so you should be able to find the > settting you need to tweak. There's one thing I've been wondering about: Why isn't the postgresql config file in /etc, with all the rest? -- Leif Biberg Kristensen http://solumslekt.org/
On Mon, 2005-04-18 at 14:16, Leif B. Kristensen wrote: > On Monday 18 April 2005 21:07, Gavin M. Roy wrote: > > Thank you for posting to a better list for these questions. Check > > your postgresql.conf file and make sure it's accepting TCP/IP > > connections on the IP you're looking for. If you look in your PGDATA > > directory you should find the config file, and if you open it and > > read it, it's well commented so you should be able to find the > > settting you need to tweak. > > There's one thing I've been wondering about: Why isn't the postgresql > config file in /etc, with all the rest? Primarily, it's because postgresql is not a "system" level service. It is quite possible for ten people using the same server to install their own copies of postgresql (on differing ports of course) each of which would be in their own home directories. In this case, it might well be that each install would need its own postgresql.conf / pg_hba.conf file to operate properly. While a service like Bind/DNS, or kerberos, is only usually run one instance at a time, it isn't all that uncommon for things like apache or postgresql to be installed and run multiple times. Which is why, one some installations, apache's conf files are local to the server directory, and on others (where apache is installed as a system service) they're in /etc somewhere. Postgresql knows where it IS by use of either the -D switch or an envar. Also, by requiring it to be in a directory that belongs to the process owner and be permed at 700, it is ensured that regular folk AND sysadmin alike won't go editing it for fun.
"Uwe C. Schroeder" <uwe@oss4u.com> writes: > have you enabled tcp in postgresql.conf ? > the parameter in question is pretty much on top of the file and should read > tcpip_socket = true And if you have set that, look at the system's packet filtering rules --- recent Red Hat releases tend to disallow traffic to port 5432 by default. "Connection refused" is a kernel-level refusal --- it means that the postmaster never got your request at all, either because it wasn't listening on that port or because something in-between blocked the packet. So there's no point in looking at your pg_hba configuration. Some troubleshooting info is in these parts of the docs: http://www.postgresql.org/docs/8.0/static/postmaster-start.html#CLIENT-CONNECTION-PROBLEMS http://www.postgresql.org/docs/8.0/static/client-authentication-problems.html regards, tom lane
On Monday 18 April 2005 12:16, Leif B. Kristensen wrote:
> On Monday 18 April 2005 21:07, Gavin M. Roy wrote:
> > Thank you for posting to a better list for these questions. Check
> > your postgresql.conf file and make sure it's accepting TCP/IP
> > connections on the IP you're looking for. If you look in your PGDATA
> > directory you should find the config file, and if you open it and
> > read it, it's well commented so you should be able to find the
> > settting you need to tweak.
>
> There's one thing I've been wondering about: Why isn't the postgresql
> config file in /etc, with all the rest?
Because it would make multiple installs of different postgres versions
hard/impossible to do. You'd also have file access problems since postgres
doesn't run as root. It's also nicely "everything in one spot"
UC
--
Open Source Solutions 4U, LLC 2570 Fleetwood Drive
Phone: +1 650 872 2425 San Bruno, CA 94066
Cell: +1 650 302 2405 United States
Fax: +1 650 872 2417
"Leif B. Kristensen" <leif@solumslekt.org> writes: > There's one thing I've been wondering about: Why isn't the postgresql > config file in /etc, with all the rest? Because (a) that would mean you couldn't run Postgres without root privileges (to set up the config files), and (b) you couldn't run more than one postmaster on a system. Both of these ideas are complete nonstarters as far as the developers are concerned, even though they might be reasonable things as far as the average user is concerned (at least until he wants to run two different PG versions while testing an upgrade). As of PG 8.0 it is possible to keep all the hand-edited config files anyplace you please, so if keeping them under /etc appeals to you, you can do it. But it's unlikely to ever become the default. For details see http://www.postgresql.org/docs/8.0/static/runtime-config.html#RUNTIME-CONFIG-FILE-LOCATIONS regards, tom lane
Edit "postgres.conf" and "pg_hba.conf" to access database from a remote
machine
Edit "postgres.conf":
------------------------------------------
listen_addresse='*'
Edit "pg_hba.conf":
------------------------------------------
host all all 10.10.0.76 255.255.255.0
trust
Thanks
Dinesh Pandey
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of ElayaRaja S
Sent: Tuesday, April 19, 2005 12:26 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Urgent
Hi,
I am using Redhat linux 9. i had configure in pg_hba.conf as
host postgres postgres 10.10.0.76 255.255.255.0 password
If i try to connect with postgresql admin i am getting excpetion as
An erro has occured:
Error connecting to the server: could not connect to server:
Connection refuesed(0x0000274D/10061)
Is the server running on host "10.10.0.76" and accepting
TCP/IP connections on port 5432?
Please help me.
--
Warm Regards,
S.ElayaRaja
Mobile: (+91) 98450 59540
E-Mail: elayaraja.s@gmail.com
raja_nk@hotmail.com
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq