Why put ltree?

actually here
postgres@vps12482:~$ 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
June 8th 19 at 16:28
1 answer
June 8th 19 at 16:30
Solution
You are doing something strange. You have what version of postgresql?
If 9.1 or above, then the only correct way to use extension is to say create extension in the desired database. Generally need root privileges database (usually postgres on a linux or pgsql on freebsd)

Blame the locale configuration error OS to the database has nothing to do.
it is necessary to go under postecom in database and create extension ltree ? - vergie.Jerde commented on June 8th 19 at 16:33
Yes - Ignacio_Romaguera commented on June 8th 19 at 16:36

Find more questions by tags PostgreSQL