После обновления 1С до версии 8.2.17.143 файл pgstartup.log стал быстро забиваться логами, такого содержания:

WARNING: nonstandard use of \\ in a string literal at character 707 HINT: Use the escape string syntax for backslashes, e.g., E’\\’. WARNING: nonstandard use of \\ in a string literal at character 736 HINT: Use the escape string syntax for backslashes, e.g., E’\\’. WARNING: nonstandard use of \\ in a string literal at character 807 HINT: Use the escape string syntax for backslashes, e.g., E’\\’. WARNING: nonstandard use of \\ in a string literal at character 840 HINT: Use the escape string syntax for backslashes, e.g., E’\\’. WARNING: nonstandard use of \\ in a string literal at character 93 HINT: Use the escape string syntax for backslashes, e.g., E’\\’. WARNING: nonstandard use of \\ in a string literal at character 276 HINT: Use the escape string syntax for backslashes, e.g., E’\\’. WARNING: nonstandard use of \\ in a string literal at character 422 HINT: Use the escape string syntax for backslashes, e.g., E’\\’. WARNING: nonstandard use of \\ in a string literal at character 645 HINT: Use the escape string syntax for backslashes, e.g., E’\\’. WARNING: nonstandard use of \\ in a string literal at character 707 HINT: Use the escape string syntax for backslashes, e.g., E’\\’. WARNING: nonstandard use of \\ in a string literal at character 736 HINT: Use the escape string syntax for backslashes, e.g., E’\\’. WARNING: nonstandard use of \\ in a string literal at character 807 HINT: Use the escape string syntax for backslashes, e.g., E’\\’. WARNING: nonstandard use of \\ in a string literal at character 840 HINT: Use the escape string syntax for backslashes, e.g., E’\\’. WARNING: nonstandard use of \\ in a string literal at character 324 HINT: Use the escape string syntax for backslashes, e.g., E’\\’. WARNING: nonstandard use of \\ in a string literal at character 57 HINT: Use the escape string syntax for backslashes, e.g., E’\\’. CONTEXT: compilation of PL/pgSQL function “binrowver” near line 2 WARNING: nonstandard use of \\ in a string literal at character 17 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(P1 / 16777216, 256)) CONTEXT: PL/pgSQL function “binrowver” line 4 at assignment WARNING: nonstandard use of \\ in a string literal at character 215 HINT: Use the escape string syntax for backslashes, e.g., E’\\’.

в результате, меньше чем за сутки, файл pgstartup.log вырастал больше 3 ГБ. Рекомендуются в postgresql.conf  установить параметр escape_string_warning = off и standard_conforming_strings = on

Такое поведение Posgresql связано с тем, что начиная с версии 8.1 введен режим совместимости с другими sql-серверами, который в будущем станет основным. А пока использование \ в sql-выражениях вызывает такое сообщение.

Ссылки: http://docs.communiware.org/guide/admin/xhtml/admin-faq.html#id2584155