[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: PostgerSQL 7.3 packages for woody



Oliver Elphick wrote:
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

this step I failed, both as root and end-user,
so how should I modify?(at /etc/postgresql/postgresql.env ? or anywhere to do anything?)

please help again


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.



--
Sincere Eric
www.linuxspice.com
linux pc for sale



Reply to: