Package: postgresql-common
Version: 36
Severity: normal
After upgrade postgresql-common from 30 to 36 start test failed, but
postgresql is started.
postgresql-common 36
postgresql 7.5.13
postgresql-7.4 1:7.4.9-2
/etc/init.d/postgresql-7.4 start &>postgresql.log
postgresql.log attached
shell locale ru_RU.UTF-8 or POSIX, result the same
from postgresql.conf:
client_encoding = utf-8 # actually, defaults to database encoding
# These settings are initialized by initdb -- they may be changed
lc_messages = 'POSIX' # locale for system error message strings
lc_monetary = 'ru_RU.ISO8859-5' # locale for monetary formatting
lc_numeric = 'ru_RU.ISO8859-5' # locale for number formatting
lc_time = 'ru_RU.ISO8859-5' # locale for time formatting
-- System Information:
Debian Release: testing/unstable
APT prefers testing
APT policy: (990, 'testing'), (500, 'unstable')
Architecture: amd64 (x86_64)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.14-2-amd64-k8-smp
Locale: LANG=ru_RU.UTF-8, LC_CTYPE=ru_RU.UTF-8 (charmap=UTF-8)
Versions of packages postgresql-common depends on:
ii adduser 3.80 Add and remove users and groups
ii debconf [debconf-2.0] 1.4.59 Debian configuration management sy
ii lsb-base 3.0-11 Linux Standard Base 3.0 init scrip
Versions of packages postgresql-common recommends:
ii openssl 0.9.8a-3 Secure Socket Layer (SSL) binary a
-- debconf information:
postgresql-common/obsolete-major:
Starting PostgreSQL 7.4 database server: mainThe PostgreSQL server failed to
start. Please check the log output:
2005-12-12 11:31:28 [18990] LOG: database system was shut down at 2005-12-12
11:31:15 MSK
2005-12-12 11:31:28 [18990] LOG: checkpoint record is at 1/DFADAFA8
2005-12-12 11:31:28 [18990] LOG: redo record is at 1/DFADAFA8; undo record is
at 0/0; shutdown TRUE
2005-12-12 11:31:28 [18990] LOG: next transaction ID: 164644; next OID: 187651
2005-12-12 11:31:29 [18990] LOG: database system is ready
2005-12-12 11:31:29 [18993] LOG: connection received: host=[local] port=
2005-12-12 11:31:29 [18993] LOG: incomplete startup packet
2005-12-12 11:31:30 [18997] LOG: connection received: host=[local] port=
2005-12-12 11:31:30 [18997] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:30 [18997] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:30 [18997] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:30 [18997] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:30 [18997] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:30 [18997] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:30 [18997] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:30 [18997] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:30 [18997] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:30 [18997] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:30 [18997] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:30 [18997] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:30 [19000] LOG: connection received: host=[local] port=
2005-12-12 11:31:30 [19000] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:30 [19000] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:30 [19000] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:30 [19000] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:30 [19000] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:30 [19000] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:30 [19000] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:30 [19000] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:30 [19000] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:30 [19000] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:30 [19000] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:30 [19000] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:31 [19011] LOG: connection received: host=[local] port=
2005-12-12 11:31:31 [19011] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:31 [19011] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:31 [19011] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:31 [19011] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:31 [19011] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:31 [19011] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:31 [19011] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:31 [19011] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:31 [19011] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:31 [19011] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:31 [19011] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:31 [19011] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:31 [19014] LOG: connection received: host=[local] port=
2005-12-12 11:31:31 [19014] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:31 [19014] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:31 [19014] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:31 [19014] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:31 [19014] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:31 [19014] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:31 [19014] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:31 [19014] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:31 [19014] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:31 [19014] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:31 [19014] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:31 [19014] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:32 [19017] LOG: connection received: host=[local] port=
2005-12-12 11:31:32 [19017] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:32 [19017] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:32 [19017] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:32 [19017] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:32 [19017] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:32 [19017] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:32 [19017] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:32 [19017] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:32 [19017] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:32 [19017] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:32 [19017] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:32 [19017] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:32 [19020] LOG: connection received: host=[local] port=
2005-12-12 11:31:32 [19020] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:32 [19020] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:32 [19020] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:32 [19020] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:32 [19020] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:32 [19020] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:32 [19020] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:32 [19020] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:32 [19020] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:32 [19020] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:32 [19020] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:32 [19020] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:33 [19023] LOG: connection received: host=[local] port=
2005-12-12 11:31:33 [19023] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:33 [19023] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:33 [19023] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:33 [19023] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:33 [19023] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:33 [19023] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:33 [19023] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:33 [19023] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:33 [19023] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:33 [19023] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:33 [19023] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:33 [19023] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:33 [19026] LOG: connection received: host=[local] port=
2005-12-12 11:31:33 [19026] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:33 [19026] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:33 [19026] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:33 [19026] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:33 [19026] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:33 [19026] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:33 [19026] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:33 [19026] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:33 [19026] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:33 [19026] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:33 [19026] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:33 [19026] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:34 [19032] LOG: connection received: host=[local] port=
2005-12-12 11:31:34 [19032] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:34 [19032] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:34 [19032] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:34 [19032] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:34 [19032] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:34 [19032] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:34 [19032] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:34 [19032] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:34 [19032] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:34 [19032] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:34 [19032] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:34 [19032] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:34 [19035] LOG: connection received: host=[local] port=
2005-12-12 11:31:34 [19035] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:34 [19035] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:34 [19035] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:34 [19035] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:34 [19035] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:34 [19035] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:34 [19035] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:34 [19035] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:34 [19035] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:34 [19035] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:34 [19035] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:34 [19035] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:35 [19038] LOG: connection received: host=[local] port=
2005-12-12 11:31:35 [19038] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:35 [19038] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:35 [19038] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:35 [19038] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:35 [19038] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:35 [19038] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:35 [19038] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:35 [19038] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:35 [19038] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:35 [19038] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:35 [19038] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:35 [19038] ERROR: syntax error at or near "º" at character 103
[31mfailed
