[Tutorial] How to install the unaccent extension for PostgreSQL 9.3

[Fernando Paladini] [Tutorial] How to install the unaccent extension for Postgresql 9.3

Sometimes you need to "unaccent" words, phrases or long texts, but how can you do that using a database? PostgreSQL, the "world's most advanced open source database" provide a nice solution to this common problem: the unaccent extension. 

Our point is not to show you how to use the unaccent extension, but how to install it. If you already know how to install this extension, you can read the official documentation of unaccent extension here

If you're receiving one of these errors:

ERROR: could not open extension control file "/usr/share/postgresql/9.1/extension/unaccent.control": No such file or directory
ERROR: could not open extension control file "/usr/share/postgresql/9.3/extension/unaccent.control": No such file or directory
This tutorial is for you. Now let's solve this thing once. 

How to install unaccent extension for PostgreSQL 9.3:

Ubuntu / Debian:
sudo apt-get install postgresql-contrib
Fedora:
yum install postgresql-contrib
CentOS:
sudo yum install postgres*contrib
I hope this solves your problem. If this not helps, please let me know through the comments below. Otherwise, I'm waiting for feedback in the comments too :)

Thanks!

4 comentários:

  1. Hello,

    found your page from a google search... tried the command, it didn't install the unaccent extension.... (no changes in /usr/share/postgresql/9.3/extension/ )

    ubuntu 14

    cheers

    ResponderExcluir
    Respostas
    1. Hello!

      Are you still getting this issue? At the moment I'm using Fedora, another Linux distro, so I think I can't help you (I don't work with programming anymore, too).

      :/

      Excluir
  2. Este comentário foi removido pelo autor.

    ResponderExcluir
  3. Thanks! worked for me well on ubuntu 14.04

    ResponderExcluir