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

Where are you doing?:

"When I am trying to run localhost:3000 ..."

Or is the above the port the Rails Web server is running on?

More below.

>
> 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 o >
> 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.

https://guides.rubyonrails.org/configuring.html#configuring-a-database

From a Redmine install of mine(running against standard port(5432)):

# PostgreSQL configuration example
production:
adapter: postgresql
database: redmine
host: localhost
port: 5432
username: redmine
password: ********

>
> 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