| 117 | You'll have to add the backports repo and pin the Postgres 9.1 packages to the "host" distro before installing the packages: |
| 118 | {{{ |
| 119 | sudo bash -c "cat >> /etc/apt/sources.list.d/backports.list <<EOF |
| 120 | deb http://backports.debian.org/debian-backports squeeze-backports main |
| 121 | EOF |
| 122 | " |
| 123 | |
| 124 | sudo bash -c "cat >> /etc/apt/preferences.d/postgresql.pref <<EOF |
| 125 | Package: libpq5 |
| 126 | Pin: release o=Debian Backports |
| 127 | Pin-Priority: 1000 |
| 128 | |
| 129 | Package: libpq-dev |
| 130 | Pin: release o=Debian Backports |
| 131 | Pin-Priority: 1000 |
| 132 | |
| 133 | Package: postgis |
| 134 | Pin: release o=Debian Backports |
| 135 | Pin-Priority: 1000 |
| 136 | |
| 137 | Package: postgresql-9.1 |
| 138 | Pin: release o=Debian Backports |
| 139 | Pin-Priority: 1000 |
| 140 | |
| 141 | Package: postgresql-client-9.1 |
| 142 | Pin: release o=Debian Backports |
| 143 | Pin-Priority: 1000 |
| 144 | |
| 145 | Package: postgresql-client-common |
| 146 | Pin: release o=Debian Backports |
| 147 | Pin-Priority: 1000 |
| 148 | |
| 149 | Package: postgresql-common |
| 150 | Pin: release o=Debian Backports |
| 151 | Pin-Priority: 1000 |
| 152 | |
| 153 | Package: postgresql-contrib |
| 154 | Pin: release o=Debian Backports |
| 155 | Pin-Priority: 1000 |
| 156 | |
| 157 | Package: postgresql-contrib-9.1 |
| 158 | Pin: release o=Debian Backports |
| 159 | Pin-Priority: 1000 |
| 160 | |
| 161 | Package: postgresql-plperl-9.1 |
| 162 | Pin: release o=Debian Backports |
| 163 | Pin-Priority: 1000 |
| 164 | |
| 165 | Package: postgresql-server-dev-9.1 |
| 166 | Pin: release o=Debian Backports |
| 167 | Pin-Priority: 1000 |
| 168 | EOF |
| 169 | " |
| 170 | |
| 171 | sudo apt-get update |
| 172 | }}} |