Thread: no such file euc2004... while initdb 9.0Beta

Hello,

I've tried to install the latest 9.0Beta (Fedora12, pgdg repository), but with
no success. "initdb" returns with an error described below.

========================================================
blub#> yum list postgres*
Loaded plugins: refresh-packagekit
Installed Packages
postgresql.i386                    9.0-alpha4_1PGDG.fc12      @pgdg90
postgresql-docs.i386           9.0-alpha4_1PGDG.fc12     @pgdg90
postgresql-libs.i386             9.0-alpha4_1PGDG.fc12      @pgdg90
postgresql-server.i386        9.0-alpha4_1PGDG.fc12     @pgdg90

blub#> /etc/init.d/postgresql-9.0 initdb
Initializing database:                                     [FAILED]

blub#> cat /var/lib/pgsql/9.0/pgstartup.log
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale en_US.UTF-8.
The default database encoding has accordingly been set to UTF8.
The default text search configuration will be set to "english".

fixing permissions on existing directory /var/lib/pgsql/9.0/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 28MB
creating configuration files ... ok
creating template1 database in /var/lib/pgsql/9.0/data/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... FATAL:  could not access file
"$libdir/euc2004_sjis2004": No such file or directory
STATEMENT:  CREATE OR REPLACE FUNCTION euc_jis_2004_to_shift_jis_2004
(INTEGER, INTEGER, CSTRING, INTERNAL, INTEGER) RETURNS VOID AS
'$libdir/euc2004_sjis2004', 'euc_jis_2004_to_shift_jis_2004' LANGUAGE C
STRICT;

child process exited with exit code 1
initdb: removing contents of data directory "/var/lib/pgsql/9.0/data"

======================================================

Where should the file "euc2004..." with this function "euc..." come from ..?

thanks in advance....GERD.....

On Wed, May 5, 2010 at 4:05 PM, Gerd Koenig <koenig@transporeon.com> wrote:

--
Shoaib Mir
http://shoaibmir.wordpress.com/

Hi Shoaib,

thanks for your hint it solved the problem just by "yum update postgresql-*"
since I had the correct repository already ;-)

regards...GERD...

On Wednesday 05 May 2010 08:28:08 am Shoaib Mir wrote:
> On Wed, May 5, 2010 at 4:05 PM, Gerd Koenig <koenig@transporeon.com> wrote:
> > Hello,
> >
> > I've tried to install the latest 9.0Beta (Fedora12, pgdg repository), but
> > with
> > no success. "initdb" returns with an error described below.
> >
> > ========================================================
> > blub#> yum list postgres*
> > Loaded plugins: refresh-packagekit
> > Installed Packages
> > postgresql.i386                    9.0-alpha4_1PGDG.fc12      @pgdg90
> > postgresql-docs.i386           9.0-alpha4_1PGDG.fc12     @pgdg90
> > postgresql-libs.i386             9.0-alpha4_1PGDG.fc12      @pgdg90
> > postgresql-server.i386        9.0-alpha4_1PGDG.fc12     @pgdg90
>
> Looks like you still using the alpha4 packages, try following this:
>
> http://people.planetpostgresql.org/devrim/index.php?/archives/43-How-to-ins
> tall-PostgreSQL-9.0-Beta-1-to-FedoraCentOSRHEL.html
>
> <http://people.planetpostgresql.org/devrim/index.php?/archives/43-How-to-in
> stall-PostgreSQL-9.0-Beta-1-to-FedoraCentOSRHEL.html>....and see if that
> fixes the problem.

On Wed, 2010-05-05 at 08:05 +0200, Gerd Koenig wrote:
> "$libdir/euc2004_sjis2004": No such file or directory
> STATEMENT:  CREATE OR REPLACE FUNCTION euc_jis_2004_to_shift_jis_2004
> (INTEGER, INTEGER, CSTRING, INTERNAL, INTEGER) RETURNS VOID AS
> '$libdir/euc2004_sjis2004', 'euc_jis_2004_to_shift_jis_2004' LANGUAGE
> C
> STRICT;
>
> child process exited with exit code 1
> initdb: removing contents of data directory "/var/lib/pgsql/9.0/data"
>
> ======================================================
>
> Where should the file "euc2004..." with this function "euc..." come
> from ..?

This is an known issue with alpha4 RPMs, and I fixed it in 2nd set:

http://svn.pgrpms.org/browser/rpm/redhat/9.0/postgresql/F-12/postgresql-9.0.spec#L758

A workaround is installing contrib package. Please install beta 1 RPMs.
They are available in the same repository. A mini howto is here:


http://people.planetpostgresql.org/devrim/index.php?/archives/43-How-to-install-PostgreSQL-9.0-Beta-1-to-FedoraCentOSRHEL.html

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz