Ludek Finstrle <[EMAIL PROTECTED]> writes: > bash-2.05$ /opt/software/postgresql/7.4.2/bin/initdb -D > /data.sql/pgsql/7.4.X/standard -E UNICODE > ... > creating template1 database in /data.sql/pgsql/7.4.X/standard/base/1... ok > initializing pg_shadow... FATAL: conversion between LATIN2 and UNICODE is not > supported
Hm, it would seem that for some reason CLIENT_ENCODING is getting set to LATIN2. Digging in the code, the only reason I can find for that to happen within initdb is if you have set PGCLIENTENCODING as an environment variable in your shell. If you want to use LATIN2 as your client encoding, it'd probably be a good idea not to use UNICODE as the database encoding ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html