Postgresql and rails 4

May 12, 2013 6.8k views
Hi I've noticed tutorials for setting up MySQL but nothing for PostgreSQL. Is it possible to set PG up on DO? Also I want to launch a Rails 4 app. Are there any special instructions for that? I've never done any sys admin.! Not sure about what I need to know or where to find it, just that I'm using pg and rails
5 Answers

We have an article on installing RoR on Ubuntu: https://www.digitalocean.com/community/articles/how-to-install-ruby-on-rails-on-ubuntu-12-04-lts-precise-pangolin-with-rvm

You can follow this article on installing Postgresql on Ubuntu: http://hendrelouw73.wordpress.com/2012/11/14/how-to-install-postgresql-9-1-on-ubuntu-12-10-linux/
by Etel Sverdlov
This tutorial explains how to install RVM (Ruby Version Manager), and then how to install ruby, how to install ruby gems, and how to install rails on Ubuntu 12.04. RVM is a program that lets you use several versions of Ruby on one server and easily switch between them.
createuser: could not connect to database postgres: could not connect to server: No such file or directory
Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

This is the error which i get when i tried to createuser in postgres!
@i Is Postgresql running? sudo service postgresql status

I experienced the same problem above using the Ubuntu 12.04 stack. How do I start the postgres server? Thanks!
Fixed it. The problem is with the locale and not postgres.
Have another answer? Share your knowledge.