Re: PostgerSQL 7.3 packages for woody

[eric lin]

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


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]