Search Postgresql Archives

Re: Connection refused (0x0000274D/10061)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux