Redmine & Postgres

I set up redmine with MySQL originally and got everything working properly.

I then changed my config/database.yml file to use postgresql.

I loaded all of the tables and default data and then restarted the application. When I go to the main page I know get a 503 error.

In the error logs I get:
[Tue Jul 27 14:04:11 2010] [error] (111)Connection refused: proxy: HTTP: attempt to connect to 127.0.0.1:3001 (127.0.0.1) failed
[Tue Jul 27 14:04:11 2010] [error] ap_proxy_connect_backend disabling worker for (127.0.0.1)
[Tue Jul 27 14:04:11 2010] [error] (111)Connection refused: proxy: HTTP: attempt to connect to 127.0.0.1:3002 (127.0.0.1) failed
[Tue Jul 27 14:04:11 2010] [error] ap_proxy_connect_backend disabling worker for (127.0.0.1)

And when I do ./ctlscript.sh status it says that redmine is not running.

How can I get redmine so it works with Postgres?

After more digging I found

mongrel.3001.log
/opt/redmine/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:76:in `establish_connection’: Please install the postgresql adapter: `gem install activerecord-postgresql-adapter` (no such file to load — pg)

After googling this error it told me to do gem install pg

I’ve already done this and I’m still getting the error, any ideas?

Hi,

Have you isntalled on RedmineStack? Try the following in the installation directory:

$ ./use_redmine
$ gem install pg

It is the RedmineStack. I followed the commands and I still get the same error.

It seems also necessary to install the adapter: “gem install activerecord-postgresql-adapter” Have you tried that?