Postgres install on Debian jessie
Heroku only uses postgresql and this was the first reason I wanted it installed.
In Debian jessie I needed to
apt-get install postgresql postgresql-contrib libpq-dev
- (without the postgresql-contrib package I got
- PG::UndefinedFile: ERROR: could not open extension control file “/usr/share/postgresql/9.3/extension/hstore.control”: No such file or directory
- CREATE EXTENSION IF NOT EXISTS “hstore”).
Then I needed to add a super-user to the db:
sudo -u postgres createuser YOUR.USERNAME -s
The defaults in Debian jessie postgresql are set to be secure. This is great if
you are serving something in the scary internet world but if you are developing
locally on a single login machine its a bit of a pain as it won’t work if your
superuser has no password. I edited my
trust instead of the
md5 connection method, e.g.
# TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust
Then restarted postgres
/etc/init.d/postgresql restart and off I went to get the pg gem…
blog comments powered by Disqus