Why put on ltree?

Question

PostgreSQL

actually here

[email protected]:~$ psql -d viber -1 -f SHAREDIR/contrib/ltree.sql
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LANG = "ru_RU.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
SHAREDIR/contrib/ltree.sql: No such file or directory

localization en_US actually here

Name         |  Owner    | Encoding |   Collate            |    Ctype          |   Access privileges   
--------------+------------+-------------+---------------------+------------------+-----------------------
 viber          | admin     | UTF8       | en_US.UTF-8      | en_US.UTF-8 |

tell me how to install

Answer 1

You are doing something strange. What version of postgresql do you have?
If 9.1 and higher - then the only correct way to put the extension is to say create extension in the desired database. Usually you need the privileges of the superuser of the database (usually postgres on linux or pgsql on freebsd)
Scolding the locale is a configuration error of the OS itself, it has nothing to do with the database.