The stock Bamboo AMI ami-e4399e8d is running Amazon Linux 2011.09; when I run yum install postgresql I get Postgres 8.4.
But my build requires Postgres 9, which isn't available except in Amazon Linux 2012.03. According to the Amazon Linux documentation http://aws.amazon.com/amazon-linux-ami/2012.03-release-notes/ I should be able to run yum update to upgrade to 2012.03, but when I do that on the Bamboo AMI it doesn't do anything.
How can I upgrade to Postgres 9 from a stock Bamboo AMI?
Lucas' answer got me on the right track. I did need to add a new yum repo, but it wouldn't work out of the box. This article explains what you need to do: http://blog.henrygis.com/2011/04/installing-postgresql-84-postgis-and.html
Running rpm -i http://yum.postgresql.org/9.1/redhat/rhel-6-x86_64/pgdg-redhat91-9.1-5.noarch.rpm installs a pgdg-91-redhat.repo file in /etc/yum.repos.d
The problem is that the file contains "$releasever" variables that insert the Amazon Linux version, e.g. "2011.09" instead of a valid RHEL version, e.g. "6.0".
This one-liner fixes the problem:
perl -pi -e 's/\$releasever/6.0/g' /etc/yum.repos.d/pgdg-91-redhat.repo
You can configure a new yum repo:
Them install the required package:
yum install postgresql91-server postgresql91-contrib
Start the service:
service postgresql-9.1 initdb
For more info:
That doesn't work, either when I use the URL you provided or when I grab the RHEL6 URL from here: http://yum.postgresql.org/repopackages.php
[ec2-user@ip-10-123-9-232 ~]$ sudo rpm -i http://yum.postgresql.org/9.0/redhat/rhel-6-i386/pgdg-redhat90-9.0-5.noarch.rpm
warning: /var/tmp/rpm-tmp.pmp1FA: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
[ec2-user@ip-10-123-9-232 ~]$ sudo yum install postgresql91-server postgresql91-contrib
Loaded plugins: fastestmirror, priorities, security, update-motd
Loading mirror speeds from cached hostfile
* amzn-main: packages.us-east-1.amazonaws.com
* amzn-updates: packages.us-east-1.amazonaws.com
amzn-main | 2.1 kB 00:00
amzn-updates | 2.3 kB 00:00
http://yum.postgresql.org/9.0/redhat/rhel-2011.09-x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404"
Trying other mirror.
Error: Cannot retrieve repository metadata (repomd.xml) for repository: pgdg90. Please verify its path and try again
The problem is that it knows it's running Amazon Linux 2011.09, and finds that it doesn't have a copy of Postgres for that version of Amazon Linux. (If I could just upgrade the box to Amazon Linux 2012.03, this would be trivial!)
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
Hey everyone! My name is Natalie and I'm an editor of the Atlassian Blog and I've got a question for you: What's your favorite quote about teamwork? We've compiled a list here, along with...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG