/usr/local/pgsql/bin/initdb -D /public/pgdata/general/ -E UTF8 --locale=ru_RU.UTF-8

db=# show client_encoding;
 client_encoding
-----------------
 utf8
(1 row)
db=# show server_encoding;
 server_encoding
-----------------
 UTF8
(1 row)

db=# select * from menuitem where caption @@ 'Petya';
ERROR:  invalid byte sequence for encoding "UTF8": 0xd1
HINT:  This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".

db=# show client_encoding;
 client_encoding
-----------------
 UTF8
(1 row)

db=# show server_encoding;
 server_encoding
-----------------
 UTF8
(1 row)

db=# select * from menuitem where caption @@ 'Petya';
 id | caption | link | menu_id | seq
----+---------+------+---------+-----
(0 rows)

client_encoding = 'UTF8'                # actually, defaults to database

 lc_collate                      | ru_RU.UTF-8                            | Shows the collation order locale.
 lc_ctype                        | ru_RU.UTF-8                            | Shows the character classification and case conversion locale.
 lc_messages                     | ru_RU.UTF-8                            | Sets the language in which messages are displayed.
 lc_monetary                     | ru_RU.UTF-8                            | Sets the locale for formatting monetary amounts.
 lc_numeric                      | ru_RU.UTF-8                            | Sets the locale for formatting numbers.
 lc_time                         | ru_RU.UTF-8                            | Sets the locale for formatting date and time values.

 id |         caption         |                    link                    | menu_id | seq
----+-------------------------+--------------------------------------------+---------+-----
  1 | п²п╟ пЁп╩п╟п╡пҐя┐я▌              | page:test                                  |       1 |   1
  3 | п÷я─п╬пЁя─п╟п╪п╪пҐп╬п╣ п╬п╠п╣я│п©п╣я┤п╣пҐп╦п╣ | menu:2                                     |       1 |   3
  ....