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
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Fixed it. The problem is with the locale and not postgres.
Hi, <br> <br>I experienced the same problem above using the Ubuntu 12.04 stack. How do I start the postgres server? Thanks!
@i Is Postgresql running? sudo service postgresql status
createuser: could not connect to database postgres: could not connect to server: No such file or directory <br>Is the server running locally and accepting connections on Unix domain socket “/var/run/postgresql/.s.PGSQL.5432”? <br> <br>This is the error which i get when i tried to createuser in postgres!
Hello, <br> <br>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 <br> <br>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/