| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | pgsql-pkg-debian(at)postgresql(dot)org |
| Subject: | PGDG debs not playing nice with pgxn (bug?) |
| Date: | 2014-06-19 15:41:48 |
| Message-ID: | 53A304BC.40908@pinpointresearch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-pkg-debian |
I attempted to install pg_repack on a server running PostgreSQL 9.1.13
on Ubuntu 12.04. As I didn't find pg_repack in the repository or
installed extensions, I decided to use pgxn.
I installed pgxnclient from PGDG. To use pgxn I had to install
postgresql-server-dev-9.1 which installed, as a requirement, libpq-dev.
The pgxn install failed with "error: unknown type name 'pg_int64'" as
described in this thread:
http://www.postgresql.org/message-id/53989C91.6050403@pinpointresearch.com
Further investigation revealed that the only seemingly available
libpg-dev in the repo is version 9.3.4. The end result is that there are
multiple versions of postgres_ext.h automatically installed and that
pgxnclient as installed from the PGDG repo chooses the wrong one:
/usr/include/postgresql/postgres_ext.h
/usr/include/postgresql/9.1/server/postgres_ext.h
Cheers,
Steve
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stuart Bishop | 2014-06-20 08:17:19 | Re: PGDG debs not playing nice with pgxn (bug?) |
| Previous Message | apt.postgresql.org repository | 2014-05-31 09:16:09 | postgresql-9.4 updated to version 9.4~beta1-2.pgdg+1 |