On Fri, 2002-12-13 at 16:20, eric lin wrote:
Oliver Elphick wrote:
Packages of PostgreSQL 7.3 built for woody are available at
http://people.debian.org/~elphick
when I do apt-get isntall postgresql
it finaaly response error
Setting up postgresql (7.3rel-7) ...
initdb: pg_encoding failed
...
please help
This is a new one...
First of all, can you do this:
$ /usr/lib/postgresql/bin/pg_encoding 2
EUC_CN
If that is OK, try (as user postgres):
$ pg_encoding 2
If that fails, the search path is wrong; /etc/postgresql/postgresql.env
(from package postgresql-client) needs to be sourced by postgres's
.profile
If that works, make sure $PGDATA is empty and owned by postgres, or
non-existent and able to be created by postgres. Then (change C and
SQL_ASCII to suit your site):
$ LANG=C initdb --debug --pgdata $PGDATA --encoding SQL_ASCII
This will produce a lot of output, but it should indicate what is going
wrong. Post the relevant bits.