how come I get this error message when I try to connect to Postgresql

[Danny Lu]

Hello all,
I am running Postgresql 8.0.0 on Windows 98. When I try to connect to the
database with
psql.exe using "psql.exe -h localhost -p 5432 template1 postgres" I get an
error message like this:

PSQL: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?

Please help me out



Dan

__________________________________________________ _______________
Is your PC infected? Get a FREE online computer virus scan from McAfee®
Security. [url]http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963[/url]


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Richard Huxton]

Danny Lu wrote:

> Hello all,
> I am running Postgresql 8.0.0 on Windows 98. When I try to connect to
> the database with
> psql.exe using "psql.exe -h localhost -p 5432 template1 postgres" I get
> an error message like this:
>
> PSQL: could not connect to server: Connection refused (0x0000274D/10061)
> Is the server running on host "localhost" and accepting
> TCP/IP connections on port 5432?

I'm not sure PG is supposed to work on Windows 98, so take care.

Having said that, there are three things to check:
1. Is the backend process running?
2. Does the logfile say anything interesting (connection failed etc)?
3. If you open a console, "telnet localhost:5432" type "A" and hit
return a couple of times do you get an error message back?

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Lonni J Friedman]

Is the server running on host "localhost" and accepting TCP/IP
connections on port 5432? What does your pg_hba.conf look like? Did
you enable TCP/IP connections in postgresql.conf ?


On Wed, 26 Jan 2005 10:04:35 -0500, Danny Lu <comtpig@hotmail.com> wrote:

> Hello all,
> I am running Postgresql 8.0.0 on Windows 98. When I try to connect to the
> database with
> psql.exe using "psql.exe -h localhost -p 5432 template1 postgres" I get an
> error message like this:
>
> PSQL: could not connect to server: Connection refused (0x0000274D/10061)
> Is the server running on host "localhost" and accepting
> TCP/IP connections on port 5432?

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~
L. Friedman [email]netllama@gmail.com[/email]
LlamaLand [url]http://netllama.linux-sxs.org[/url]

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [email]majordomo@postgresql.org[/email] so that your
message can get through to the mailing list cleanly