Re: Connection refused (0x0000274D/10061)

Hi,
I have tried many time for setup postgreSQL for my local host. Hence I have
tried to reInstall the one click app from
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads - Windows
x86-64 - PostgreSQL Version 11.3. When installing using default port
5432, Its giving an error "Database Cluster Installation Failed". Please
advice how to resolve the issue. I am struggling to setup this POSTGRESQL
from more than a week.

The error screenshot is attached. PFA

On Mon, Jun 10, 2019 at 2:39 AM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

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

--
*Regards-*
*Sourav Majumdar*
*Mob.- 9732354141*