Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Tatsuo Ishii <ishii(at)postgresql(dot)org> writes:
>>> initdb -E UTF-8 --no-locale /path/to/database
>
>> So locale is "C". I believe we are not customizing
>> default_text_search_config. I'm not think of any nondefault
>> configuration settings.
>
> Huh. So that should be the same case I tested here. I wonder why
> I can't duplicate it. Can anyone else get the failure?
I can't duplicate it on beta2, either.
I didn't use the -E switch on initdb.
initdb --no-locale /path/to/database
kgrittn(at)ATHENA:~> uname -a
Linux ATHENA 2.6.16.60-0.31-smp #1 SMP Tue Oct 7 16:16:29 UTC 2008
x86_64 x86_64 x86_64 GNU/Linux
kgrittn(at)ATHENA:~> cat /etc/SuSE-release
SUSE Linux Enterprise Server 10 (x86_64)
VERSION = 10
PATCHLEVEL = 2
kgrittn(at)ATHENA:~> /usr/local/pgsql-8.4beta2/bin/pg_config
BINDIR = /usr/local/pgsql-8.4beta2/bin
DOCDIR = /usr/local/pgsql-8.4beta2/share/doc
HTMLDIR = /usr/local/pgsql-8.4beta2/share/doc
INCLUDEDIR = /usr/local/pgsql-8.4beta2/include
PKGINCLUDEDIR = /usr/local/pgsql-8.4beta2/include
INCLUDEDIR-SERVER = /usr/local/pgsql-8.4beta2/include/server
LIBDIR = /usr/local/pgsql-8.4beta2/lib
PKGLIBDIR = /usr/local/pgsql-8.4beta2/lib
LOCALEDIR = /usr/local/pgsql-8.4beta2/share/locale
MANDIR = /usr/local/pgsql-8.4beta2/share/man
SHAREDIR = /usr/local/pgsql-8.4beta2/share
SYSCONFDIR = /usr/local/pgsql-8.4beta2/etc
PGXS = /usr/local/pgsql-8.4beta2/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/usr/local/pgsql-8.4beta2'
'--enable-integer-datetimes' '--enable-debug' '--disable-nls'
'-with-libxml'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2
CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing
-fwrapv -g
CFLAGS_SL = -fpic
LDFLAGS = -Wl,--as-needed -Wl,-rpath,'/usr/local/pgsql-8.4beta2/lib'
LDFLAGS_SL =
LIBS = -lpgport -lxml2 -lz -lreadline -lcrypt -ldl -lm
VERSION = PostgreSQL 8.4beta2
kgrittn(at)ATHENA:~> /usr/local/pgsql-8.4beta2/bin/pg_controldata
/var/pgsql/data/kgrittn2
pg_control version number: 843
Catalog version number: 200904091
Database system identifier: 5340644220088610719
Database cluster state: in production
pg_control last modified: Wed 03 Jun 2009 05:42:18 PM CDT
Latest checkpoint location: 12/5F9CD778
Prior checkpoint location: 12/5F9CD700
Latest checkpoint's REDO location: 12/5F9CD778
Latest checkpoint's TimeLineID: 1
Latest checkpoint's NextXID: 0/4517
Latest checkpoint's NextOID: 57344
Latest checkpoint's NextMultiXactId: 1
Latest checkpoint's NextMultiOffset: 0
Time of latest checkpoint: Wed 03 Jun 2009 05:42:18 PM CDT
Minimum recovery ending location: 0/0
Maximum data alignment: 8
Database block size: 8192
Blocks per segment of large relation: 131072
WAL block size: 8192
Bytes per WAL segment: 16777216
Maximum length of identifiers: 64
Maximum columns in an index: 32
Maximum size of a TOAST chunk: 1996
Date/time type storage: 64-bit integers
Float4 argument passing: by value
Float8 argument passing: by value
kgrittn(at)ATHENA:~> cat /var/pgsql/data/kgrittn2/postgresql.conf
port = 5442
max_connections = 10
shared_buffers = 250MB
max_prepared_transactions = 0
work_mem = 50MB
maintenance_work_mem = 1GB
checkpoint_segments = 20
checkpoint_timeout = 30min
effective_cache_size = 100GB
geqo = off
from_collapse_limit = 20
join_collapse_limit = 20
datestyle = 'iso, mdy'
lc_messages = 'C'
lc_monetary = 'C'
lc_numeric = 'C'
lc_time = 'C'
default_text_search_config = 'pg_catalog.english'
escape_string_warning = off
sql_inheritance = off
standard_conforming_strings = on
-Kevin