rails app use postgresql shows PG::Error

Question

I just started a new rails app using

rails new myapp --database=postgresql

Then I generate some static pages:

rails g controller StaticPages home about

When I started the server and visit localhost:3000/static_pages/home, the PG::Error shows up:

PG::Error

could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5432?

I didn't change anything else

Any idea how to make postgresql work?

Your PostgreSQL server appears to be down or listening on some other port. — vyegorov
– vyegorov, Commented Apr 13, 2012 at 19:43

Justin Herrick · Accepted Answer · 2012-04-12 22:38:56Z

3

It looks like your postgres server is not running. Have you started it up? If you check your system processes do you see the postgres daemon running?

If you are trying to use rails + postgres, I would recommend checking out this great video by Pete Cooper.

answered Apr 12, 2012 at 22:38

Justin Herrick

3,04119 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

alexZ Over a year ago

yeah I didn't see it running. Any idea how to start it? Thanks for the video BTW, great resource. But I'm using windows now

kgrittn Over a year ago

How you start it depends on how you installed it, but you could start by looking for a Windows server to start.

Collectives™ on Stack Overflow

rails app use postgresql shows PG::Error

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related