Re: Connection refused (0x0000274D/10061)

On 6/9/19 1:46 PM, Ray O'Donnell wrote:
> On 09/06/2019 20:49, Sourav Majumdar wrote:
>> Hello,
>> Thanks for your quick response. I am new to pgsql, didnot configured
>> it , can you please give a guidance for that? I will be highly oblised
>> if you can assist me.
>> I am using windows 8.1, 64 bit.
>> ruby 2.3.3p222 (2016-11-21 revision 56859) [i386-mingw32]
>> Rails 5.2.3
>> Trying to setup ruby on rails on my local host

Alright the penny just dropped, maybe:

1) You have started the Rails Web server on port 3000

2) You tried to do something that accessed the Postgres server.

3) You got connection refused error.

If the above is correct then the error message:

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

means either:

1) The server is not running. Check that the Postgres service is running
in Windows.

2) The server is running but not listening on port 5432. Check the
Postgres config file(postgresql.conf) to see what the settings I
mentioned earlier are.

>
> Hi,
>
> PostgreSQL's default port is 5432, and if the Postgres instance on your
> computer is the only one there then that's what it'll be listening on.
>
> I don't know anything about Ruby or how you connect to PG from it, but
> you need to tell it to use port 5432.
>
> Alternatively, if you really want to use port 3000, then you need to
> edit postgresql.conf and change the "port" setting there. You'll need to
> restart PG for this to take effect.
>
> Either way, you need to connect to the port on which PG is listening.
>
> Ray.
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com