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.klaver@aklaver.com