Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Cannot find PGXS for Postgresql 8.4 on Ubuntu

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?

like image 699
user560494 Avatar asked Sep 11 '11 05:09

user560494


People also ask

Where is Postgres bin directory Ubuntu?

PostgreSQL configuration files are stored in the /etc/postgresql/<version>/main directory. For example, if you install PostgreSQL 12, the configuration files are stored in the /etc/postgresql/12/main directory. To configure IDENT authentication, add entries to the /etc/postgresql/12/main/pg_ident. conf file.


1 Answers

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
like image 140
Grzegorz Szpetkowski Avatar answered Oct 04 '22 04:10

Grzegorz Szpetkowski