This last weekend at a friends house I got tired of my desktop wallpaper and decided to migrate distro’s from my default, Debian, to Arch Linux. I’m now setting up my rails development environment. I prefer PostgreSql for my database.
To get the gem ‘pg’ running in my application I need a working instance of Postgres.
This installed postgresql-9.3.5-1 and postgresql-libs-9.3
Become the postgres user
Initialize the DB cluster
When I ran the above, I received a notice that I required polkit. I resolved this by running
I then had to reboot and retry starting the postgresql service
Create a postgres user for my app
I created a super user role with the same name as my linux user
Create a database
Add a new linux user with same name as created role
Access the database through the REPL as postgres user
Create user in database [Don’t forget the ‘;’ terminator]
And then there was a running postgres database!