Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
"Danny Lu"
Date:
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. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

Re: how come I get this error message when I try to connect

From
Richard Huxton
Date:
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

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

From
Lonni J Friedman
Date:
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                                    netllama@gmail.com
LlamaLand                       http://netllama.linux-sxs.org