Thanks to Wayne for helping to refine these (they will ultimately be under
https://github.com/crowbar/barclamp-crowbar/blob/master/doc/devguide/devtool-build.md)
# we need Postgresql 9.3 (we rely on 9.3+ features)
# first, remove the automatically added old Posgresql
sudo apt-get remove postgresql
# Additional reference, please visit
[[https://wiki.postgresql.org/wiki/Apt]]
# for now you need to add the sources (please remove this step when 9.3 is
in the official repos!)
deb http://apt.postgresql.org/pub/repos/apt/ [your release]-pgdg main
wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc |
sudo apt-key add -
sudo apt-get update
# now install and set to use the special port/pipe config
sudo apt-get install postgresql-9.3 pgadmin3
sudo vi /etc/postgresql/9.3/main/pg_hba.conf
# add 'local all all trust'
sudo vi /etc/postgresql/9.3/main/postgresql.conf
# change 'port = 5439'
sudo createuser -s -d -U postgres crowbar
# you can test the install by making sure the following call returns
export PGCLUSTER=9.3/main
psql postgresql://crowbar@:5439/template1 -c 'select true;'
From: Hirschfeld, Rob
Sent: Wednesday, October 09, 2013 12:34 PM
To: crowbar
Subject: Crowbar 2 change to Postgresql 9.3
All,
Victor noted earlier that adding delayed_jobs created lock contention forcing
us to move away from sqlite (this was an anticipated consequence).
Consequently, we have added the requirement for Postgresql 9.3 to the Crowbar 2
dev tool. We are using 9.3 so we can leverage the latest json management
features - this is not the default Postgresql that gets installed and you will
be required to upgrade your dev environment.
Here's the steps Victor and I've been working on to make the change (they may
need some tweaks on per your environment)
# we need Postgresql 9.3 (we rely on 9.3+ features)
# first, remove the automatically added old Posgresql
sudo apt-get remove postgresql
# now install and set to use the special port/pipe config
sudo apt-get install postgresql-9.3 pgadmin3
sudo vi /etc/postgresql/9.3/main/pg_hba.conf
# add 'local all all trust'
sudo vi /etc/postgresql/9.3/main/postgresql.conf
# change 'port = 5439'
createuser -s -d -U crowbar
I'm working now to fix code broken by the change so that tests will pass again.
Rob
______________________________
Rob Hirschfeld
Sr. Distinguished Cloud Solution Architect
Dell | Cloud Edge, Data Center Solutions
blog robhirschfeld.com, twitter @zehicle
Please note, I am based in the CENTRAL (-6) time zone
_______________________________________________
Crowbar mailing list
[email protected]
https://lists.us.dell.com/mailman/listinfo/crowbar
For more information: http://crowbar.github.com/
