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