Добрый день !!! Есть такая проблема:
Скачал с сайта 1с PostgreSQL 8.3 с патчами. Пропатчил

`debian:/usr/src/pgsql/postgresql-8.3.3/src# patch -p1 < ../1cFull.patch`
нормально пропатчилось, потом скомпилировал тоже без ощибок
mchar скомпилировал без проблем, установил mchar.so положил в /usr/local/pgsql/lib/
проинициализировал базу , su -l postgres , psql template1 заходит без проблем.
при попытке создать базу с сервера 1с на виндовой машине пишет ощибку invalid value for parameter "lc_messages": "en_US никак не могу что он от меня хочет и почему требует именно такую локаль а не ru_RU.UTF-8. Люди добрые помоги 3 день сижу мучаюсь

Люди неужели никто не сталкивался с такой проблемой ?

template1=# select * from pg_settings where name like 'lc_%';
name | setting | unit | category | short_desc | extra_desc | context | vartype | source | min_val | max_val
-------------+-------------+------+----------------------------------------------------+----------------------------------------------------------------+------------+-----------+---------+--------------------+---------+---------
lc_collate | ru_RU.UTF-8 | | Client Connection Defaults / Locale and Formatting | Shows the collation order locale. | | internal | string | override | |
lc_ctype | ru_RU.UTF-8 | | Client Connection Defaults / Locale and Formatting | Shows the character classification and case conversion locale. | | internal | string | override | |
lc_messages | ru_RU.UTF-8 | | Client Connection Defaults / Locale and Formatting | Sets the language in which messages are displayed. | | superuser | string | configuration file | |
lc_monetary | ru_RU.UTF-8 | | Client Connection Defaults / Locale and Formatting | Sets the locale for formatting monetary amounts. | | user | string | configuration file | |
lc_numeric | ru_RU.UTF-8 | | Client Connection Defaults / Locale and Formatting | Sets the locale for formatting numbers. | | user | string | configuration file | |
lc_time | ru_RU.UTF-8 | | Client Connection Defaults / Locale and Formatting | Sets the locale for formatting date and time values. | | user | string | configuration file | |

lc_messages = 'ru_RU.UTF-8' # locale for system error message
# strings
lc_monetary = 'ru_RU.UTF-8' # locale for monetary formatting
lc_numeric = 'ru_RU.UTF-8' # locale for number formatting
lc_time = 'ru_RU.UTF-8' # locale for time formatting

а где можно посмотреть скрипт для создания базы ?
ощибка вылетает при создании базы из консоли 1с сервера

Да база test_db создалась без проблем !!!

Запустил базу в режиме отладки вот что получилось
LOG: подсоединение авторизировано: пользователь=postgres база=test_db
DEBUG: postgres child[8367]: starting with (
DEBUG: postgres
DEBUG: -i
DEBUG: -v196608
DEBUG: -y
DEBUG: test_db
DEBUG: )
DEBUG: InitPostgres
DEBUG: StartTransaction
DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG: CommitTransaction
DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG: StartTransactionCommand
DEBUG: StartTransaction
DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
LOG: PARSER STATISTICS
ПОДРОБНОСТИ: ! system usage stats:
! 0.000104 elapsed 0.000000 user 0.000000 system sec
! [0.004000 user 0.004000 sys total]
! 0/0 [0/160] filesystem blocks in/out
! 0/42 [0/676] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 0/0 [2/29] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
КОМАНДА: SET SESSION default_with_oids = on; SET client_min_messages=error
LOG: команда: SET SESSION default_with_oids = on; SET client_min_messages=error
LOG: PARSE ANALYSIS STATISTICS
ПОДРОБНОСТИ: ! system usage stats:
! 0.000006 elapsed 0.000000 user 0.000000 system sec
! [0.004000 user 0.004000 sys total]
! 0/0 [0/160] filesystem blocks in/out
! 0/2 [0/688] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 0/0 [2/31] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
КОМАНДА: SET SESSION default_with_oids = on; SET client_min_messages=error
DEBUG: parse tree:
ПОДРОБНОСТИ: {QUERY :commandType 5 :querySource 0 :canSetTag true :utilityStmt ?
:resultRelation 0 :intoClause <> :hasAggs false :hasSubLinks false :rtable <>
:jointree <> :targetList <> :returningList <> :groupClause <> :havingQual <>
:distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :rowMarks <>
:setOperations <>}

LOG: REWRITER STATISTICS
ПОДРОБНОСТИ: ! system usage stats:
! 0.000140 elapsed 0.000000 user 0.000000 system sec
! [0.004000 user 0.004000 sys total]
! 0/0 [0/160] filesystem blocks in/out
! 0/8 [0/696] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 0/1 [2/33] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
КОМАНДА: SET SESSION default_with_oids = on; SET client_min_messages=error
DEBUG: ProcessUtility
LOG: PARSE ANALYSIS STATISTICS
ПОДРОБНОСТИ: ! system usage stats:
! 0.000002 elapsed 0.000000 user 0.000000 system sec
! [0.004000 user 0.004000 sys total]
! 0/0 [0/160] filesystem blocks in/out
! 0/0 [0/704] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 0/0 [2/35] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
КОМАНДА: SET SESSION default_with_oids = on; SET client_min_messages=error
DEBUG: parse tree:
ПОДРОБНОСТИ: {QUERY :commandType 5 :querySource 0 :canSetTag true :utilityStmt ?
:resultRelation 0 :intoClause <> :hasAggs false :hasSubLinks false :rtable <>
:jointree <> :targetList <> :returningList <> :groupClause <> :havingQual <>
:distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :rowMarks <>
:setOperations <>}

LOG: REWRITER STATISTICS
ПОДРОБНОСТИ: ! system usage stats:
! 0.000124 elapsed 0.000000 user 0.000000 system sec
! [0.004000 user 0.004000 sys total]
! 0/0 [0/160] filesystem blocks in/out
! 0/0 [0/704] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 0/1 [2/37] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
КОМАНДА: SET SESSION default_with_oids = on; SET client_min_messages=error
DEBUG: ProcessUtility
DEBUG: CommitTransactionCommand
DEBUG: CommitTransaction
DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG: StartTransactionCommand
DEBUG: StartTransaction
DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
LOG: PARSER STATISTICS
ПОДРОБНОСТИ: ! system usage stats:
! 0.000033 elapsed 0.000000 user 0.000000 system sec
! [0.004000 user 0.004000 sys total]
! 0/0 [0/160] filesystem blocks in/out
! 0/5 [0/710] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 0/0 [3/42] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
КОМАНДА: SET lc_messages to 'en_US';
LOG: команда: SET lc_messages to 'en_US';
LOG: PARSE ANALYSIS STATISTICS
ПОДРОБНОСТИ: ! system usage stats:
! 0.000002 elapsed 0.000000 user 0.000000 system sec
! [0.004000 user 0.004000 sys total]
! 0/0 [0/160] filesystem blocks in/out
! 0/0 [0/710] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 0/0 [3/42] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
КОМАНДА: SET lc_messages to 'en_US';
DEBUG: parse tree:
ПОДРОБНОСТИ: {QUERY :commandType 5 :querySource 0 :canSetTag true :utilityStmt ?
:resultRelation 0 :intoClause <> :hasAggs false :hasSubLinks false :rtable <>
:jointree <> :targetList <> :returningList <> :groupClause <> :havingQual <>
:distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :rowMarks <>
:setOperations <>}

LOG: REWRITER STATISTICS
ПОДРОБНОСТИ: ! system usage stats:
! 0.000054 elapsed 0.000000 user 0.000000 system sec
! [0.004000 user 0.004000 sys total]
! 0/0 [0/160] filesystem blocks in/out
! 0/0 [0/710] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 0/0 [3/42] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
КОМАНДА: SET lc_messages to 'en_US';
DEBUG: ProcessUtility
ERROR: неверное значение для параметра "lc_messages": "en_US"
КОМАНДА: SET lc_messages to 'en_US';
DEBUG: StartTransactionCommand
DEBUG: StartTransaction
DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
LOG: PARSER STATISTICS
ПОДРОБНОСТИ: ! system usage stats:
! 0.000006 elapsed 0.000000 user 0.000000 system sec
! [0.004000 user 0.004000 sys total]
! 0/0 [0/160] filesystem blocks in/out
! 0/0 [0/720] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 0/0 [5/42] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
КОМАНДА: ROLLBACK
LOG: команда: ROLLBACK
LOG: PARSE ANALYSIS STATISTICS
ПОДРОБНОСТИ: ! system usage stats:
! 0.000001 elapsed 0.000000 user 0.000000 system sec
! [0.004000 user 0.004000 sys total]
! 0/0 [0/160] filesystem blocks in/out
! 0/0 [0/720] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 0/0 [5/42] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
КОМАНДА: ROLLBACK
DEBUG: parse tree:
ПОДРОБНОСТИ: {QUERY :commandType 5 :querySource 0 :canSetTag true :utilityStmt ?
:resultRelation 0 :intoClause <> :hasAggs false :hasSubLinks false :rtable <>
:jointree <> :targetList <> :returningList <> :groupClause <> :havingQual <>
:distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :rowMarks <>
:setOperations <>}

LOG: REWRITER STATISTICS
ПОДРОБНОСТИ: ! system usage stats:
! 0.000034 elapsed 0.000000 user 0.000000 system sec
! [0.004000 user 0.004000 sys total]
! 0/0 [0/160] filesystem blocks in/out
! 0/0 [0/720] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 0/0 [5/42] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
КОМАНДА: ROLLBACK
DEBUG: ProcessUtility
NOTICE: нет транзакции в процессе выполнения
DEBUG: CommitTransactionCommand
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
LOG: disconnection: session time: 0:00:00.028 user=postgres database=test_db host=10.1.7.30 port=1631
DEBUG: exit(0)
DEBUG: процесс сервера (PID 8367) завершился с кодом выхода 0
DEBUG: StartTransaction
DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG: CommitTransaction
DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG: autovacuum: processing database "test_db"
DEBUG: StartTransaction
DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG: pg_authid: vac: 0 (threshold 50), anl: 0 (threshold 50)
DEBUG: pg_database: vac: 0 (threshold 50), anl: 1 (threshold 50)
DEBUG: pg_shdepend: vac: 0 (threshold 50), anl: 0 (threshold 50)
DEBUG: pg_attribute: vac: 0 (threshold 405), anl: 0 (threshold 227)
DEBUG: pg_class: vac: 0 (threshold 95), anl: 0 (threshold 73)
DEBUG: pg_index: vac: 0 (threshold 68), anl: 0 (threshold 59)
DEBUG: pg_opclass: vac: 0 (threshold 72), anl: 0 (threshold 61)
DEBUG: pg_am: vac: 0 (threshold 51), anl: 0 (threshold 50)
DEBUG: pg_amop: vac: 0 (threshold 119), anl: 0 (threshold 85)
DEBUG: pg_amproc: vac: 0 (threshold 99), anl: 0 (threshold 74)
DEBUG: pg_trigger: vac: 0 (threshold 51), anl: 0 (threshold 50)
DEBUG: pg_tablespace: vac: 0 (threshold 50), anl: 0 (threshold 50)
DEBUG: CommitTransaction
DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
DEBUG: exit(0)
DEBUG: процесс сервера (PID 8368) завершился с кодом выхода 0

SET lc_messages to 'en_US'; выдает ощибку ERROR: неверное значение для параметра "lc_messages": "en_US"

$ locale -a | grep en_US
en_US
en_US.iso88591
en_US.utf8
?

выдает en_US.utf8

Я так понял у меня почемуто нет локали en_US посмотрел в /usr/share/locale/en_US/ там только файлик
entry.desktop пробовал dpkg-reconfigure locales не помогает подскажите как в ubuntu поставить локаль en_US ?

Ты в самый нужный момент присоединился к топику и дал самый ценный совет

Помогло locale-gen en_US

Но теперь другая проблема

there is no transaction in progress
ERROR: syntax error at or near "application" at character 24
STATEMENT: lock table pg_class in application share mode
NOTICE: there is no transaction in progress
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "config_pkey" for table "config"
WARNING: nonstandard use of \\ in a string literal at character 145
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "configsave_pkey" for table "configsave"
WARNING: nonstandard use of \\ in a string literal at character 149
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "params_pkey" for table "params"
WARNING: nonstandard use of \\ in a string literal at character 145
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "files_pkey" for table "files"
WARNING: nonstandard use of \\ in a string literal at character 144
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
ERROR: syntax error at or near "application" at character 24
STATEMENT: lock table pg_class in application share mode
NOTICE: there is no transaction in progress
WARNING: nonstandard use of \\ in a string literal at character 149
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING: nonstandard use of \\ in a string literal at character 146
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING: nonstandard use of \\ in a string literal at character 151
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
LOG: получен запрос об умном останове

База создается а потом говорит что "база непригодна для использованиея" есть мысли по этому поводу ???

!!! Проблема разрешилась очень просто нужно просто скомпилировать в fulleq fasttrun из директории src
потом загрузить в template1 и скопировать собранные файлики *.so с соответсвующими названиями в каталог библиотеки для postgresql и все работает кстати не забыть и про mchar !!!

ВСЕМ БОЛЬШОЕ ЗА ПОМОШЬ !!!

СПАСИБО !!!