Search Postgresql Archives

Re: Connection refused (0x0000274D/10061)

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

 



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.klaver@xxxxxxxxxxx





[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