Re: how to build extensions when not on 9.3?

On Jul 24, 2014, at 12:14 AM, Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr> wrote:

> Sorry to only see that now, but it seems to me that your question is
> answered in the FAQ:
>
> http://wiki.postgresql.org/wiki/Apt/FAQ#I_want_libpq5_for_version_X.2C_but_there_is_only_version_Y_in_the_repository
>
> Namely in your case you should tweak your sources.list entry like this:
>
> deb http://apt.postgresql.org/pub/repos/apt/ squeeze-pgdg main 9.2

Not sure how I missed this in the docs, but that got me going like so:

sudo apt-get install postgresql-server-dev-9.2 postgresql-9.2 postgresql-9.2-postgis-2.1 postgresql-9.2-slony1-2 postgresql-contrib-9.2 postgresql-client-9.2 libpq-dev=9.2.9-1.pgdg14.04+1 libpq5=9.2.9-1.pgdg14.04+1 pgxnclient

Then I had to install a couple other -dev packages and pg_repack built just fine.

Thanks!