Re: Connection refused (0x0000274D/10061)

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Ray O'Donnell <ray(at)rodonnell(dot)ie>, Sourav Majumdar <souravmajumdar2002(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Connection refused (0x0000274D/10061)
Date: 2019-06-09 21:01:34
Message-ID: 4d2a7529-d9d5-500d-80a3-313cc5c799e0@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-06-09 21:09:02 Re: Connection refused (0x0000274D/10061)
Previous Message Ray O'Donnell 2019-06-09 20:46:57 Re: Connection refused (0x0000274D/10061)