Cannot find PGXS for Postgresql 8.4 on Ubuntu

postgresql ubuntu unaccent
user560494 picture user560494 · Sep 11, 2011 · Viewed 7.4k times · Source

I am trying to install the contrib/unaccent package for Postgresql 8.4 on my Ubuntu box. But I got the error message when I typed make:

/usr/lib/postgresql/8.4/lib/pgxs/src/makefiles/pgxs.mk: No such file or directory

Apparently PGXS is Postgresql's infrastructure for installing extensions, but I could not find the file pgxs.mk at all on my ubuntu box.

Following some leads on the Internet, I tried installing libpq-dev. Nonetheless, I couldn't find any pgxs.mk even after installing libpq-dev.

What's really frustrating is that I can't even find an example of pgxs.mk anywhere on the Internet. How do I install the PGXS infrastructure?

Answer

Grzegorz Szpetkowski picture Grzegorz Szpetkowski · Sep 11, 2011

Probably you need to install postgresql-server-dev-8.4 package, which contains your missing makefile:

/usr/lib/postgresql/8.4/lib/pgxs/src/makefiles/pgxs.mk

Related questions

Postgresql: password authentication failed for user "postgres"

I have installed PostgreSQL 8.4, Postgres client and Pgadmin 3. Authentication failed for user "postgres" for both console client and Pgadmin. I have typed user as "postgres" and password "postgres", because it worked before. But now authentication is failed. I did it …

Read More
How to thoroughly purge and reinstall postgresql on ubuntu?

Somehow I've managed to completely bugger the install of postgresql on Ubuntu karmic. I want to start over from scratch, but when I "purge" the package with apt-get it still leaves traces behind such that the reinstall configuration doesn't run …

Read More
"psql: could not connect to server: Connection refused" Error when connecting to remote database

I am trying to connect to a postgres database installed in a remote server using the following command: psql -h host_ip -U db_username -d db_name This the error that occurs: psql: could not connect to server: Connection …

Read More