CREATE TRUSTED LANGUAGE plpgsql HANDLER language_handler_in;
REVOKE ALL ON LANGUAGE plpgsql FROM public;
Из остнаски сервер создался, а вот при попытки создания базы ошибка (через пару секунд после нажатия OK):
"Ошибка создания информационной базы:
Ошибка информационной базы
Ошибка установки или изменения национальных настроек информационной базы
Порядок сортировки не поддерживается базой данных"
Записи о базе есть, при попытки подключится к ней через 1С-клиент выдается ошибка о несоответствии региональных настроек, воспользуйтесь конструктором (он тоже ругается).
Логи:
Код:
cat postgresql-2008-07-22_120750.log
LOG: система была отключена: 2008-07-22 12:07:49 YEKST
LOG: контрольная точка: 0/61510C
LOG: redo-запись: 0/61510C; undo-запись: 0/0; отключение: TRUE
LOG: next transaction ID: 0/596; next OID: 10830
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: система готова к использованию
NOTICE: using pg_pltemplate information instead of CREATE LANGUAGE parameters
WARNING: nonstandard use of \' in a string literal at character 97
HINT: Use '' to write quotes in strings, or use the escape string syntax (E'...').
WARNING: nonstandard use of escape in a string literal at character 1811
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING: nonstandard use of \\ in a string literal at character 17
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
QUERY: SELECT $1 || '\\000'
CONTEXT: SQL statement in PL/PgSQL function "btrim" near line 10
WARNING: nonstandard use of \\ in a string literal at character 18
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
QUERY: SELECT SET_BYTE('\\000\\000\\000\\000\\000\\000\\000\\000'::bytea, 4, MOD( $1 / 16777216, 256))
CONTEXT: SQL statement in PL/PgSQL function "binrowver" near line 4
NOTICE: type "mchar" is not yet defined
DETAIL: Creating a shell type definition.
NOTICE: argument type mchar is only a shell
NOTICE: argument type mchar is only a shell
NOTICE: return type mchar is only a shell
NOTICE: type "mvarchar" is not yet defined
DETAIL: Creating a shell type definition.
NOTICE: argument type mvarchar is only a shell
NOTICE: argument type mvarchar is only a shell
NOTICE: return type mvarchar is only a shell
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'\\'.
NOTICE: using pg_pltemplate information instead of CREATE LANGUAGE parameters
LOG: получен запрос о быстром останове
LOG: отключение в процессе
LOG: система отключена
LOG: остановка логгера
cat postgresql-2008-07-22_121157.log
LOG: database system was shut down at 2008-07-22 12:11:56 YEKST
LOG: checkpoint record is at 0/7B4010
LOG: redo record is at 0/7B4010; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 0/653; next OID: 16737
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system is ready
NOTICE: using pg_pltemplate information instead of CREATE LANGUAGE parameters
WARNING: nonstandard use of \' in a string literal at character 97
HINT: Use '' to write quotes in strings, or use the escape string syntax (E'...').
WARNING: nonstandard use of escape in a string literal at character 1811
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING: nonstandard use of \\ in a string literal at character 17
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
QUERY: SELECT $1 || '\\000'
CONTEXT: SQL statement in PL/PgSQL function "btrim" near line 10
WARNING: nonstandard use of \\ in a string literal at character 18
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
QUERY: SELECT SET_BYTE('\\000\\000\\000\\000\\000\\000\\000\\000'::bytea, 4, MOD( $1 / 16777216, 256))
CONTEXT: SQL statement in PL/PgSQL function "binrowver" near line 4
NOTICE: type "mchar" is not yet defined
DETAIL: Creating a shell type definition.
NOTICE: argument type mchar is only a shell
NOTICE: argument type mchar is only a shell
NOTICE: return type mchar is only a shell
NOTICE: type "mvarchar" is not yet defined
DETAIL: Creating a shell type definition.
NOTICE: argument type mvarchar is only a shell
NOTICE: argument type mvarchar is only a shell
NOTICE: return type mvarchar is only a shell
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'\\'.
Может кто помочь?