Wednesday, July 31, 2013

Error: no candidate version available for postgresql-contrib-9.2

This is the error I got when I set up PostgreSQL using chef on ubuntu 13.04:

no candidate version available for postgresql-contrib-9.2

Where does the error come from


So ... it is obvious that there is no Postgresql 9.2 found in all the apt repository the system can see.

It turns out that latest postgresql packages are distributed else where:
https://wiki.postgresql.org/wiki/Apt


Solve in command line


To include the repository and update your packages in command line, do this:

echo "deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main" > /etc/apt/sources.list.d/pgdg.list
wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update

Solve in chef


file "/etc/apt/sources.list.d/pgdg.list" do
  owner "root"
  group "root"
  mode 00644
  content "deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main"
end

execute "include pgdg repository key" do
  command "wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add -"
end

execute "update apt-get list" do
  command "sudo apt-get update"
end

No comments:

Post a Comment