Re: PostgerSQL 7.3 packages for woody
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.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"For thou art my hope, O Lord GOD; thou art my trust
from my youth." Psalms 71:5
Reply to: