Skip site navigation (1) Skip section navigation (2)

initdb initialization problem

From: "Daniel L Banta" <dan(at)netcandor(dot)net>
To: "pgsql novice" <pgsql-novice(at)postgresql(dot)org>
Subject: initdb initialization problem
Date: 2002-07-26 14:00:45
Message-ID: 003201c234ac$d696c6e0$ef0010ac@netcandor.net (view raw or flat)
Thread:
Lists: pgsql-novice
Good Morning,

I am having a little problem starting postgres.

I installed PostgreSQL without shared libraries (e.g. --disable-shared).
Once it was installed, I use a modified version of the postgresql.init file
include from the postgresql-7.2.1-2PGDG.src.rpm to start it. (All I changed
was /usr to /usr/local from the postgresql.init.) Database initializes
great, postgres starts like a dream come true. Then if I remove the
PostgreSQL installation except for my $PGDATA dir. Next I install enabling
shared libraries. Once completed, I run the modified postgresql.init. Again
postgres starts quite well. Now I know that it didn't run initdb because I
left the previous one there. I think it was no harm done, because it is the
same version and same configure options (minus the '--disable-shared').
Finally, getting to the error. If I remove both the installation and the
$PGDATA dir. Re-compile a third time, with shared libraries, then I run the
postgresql.init script, I get the following error after a closer inspection.

/*********** Start Error Message ************/
/usr/local/bin/initdb --pgdata=/var/lib/pgsql/data
/usr/local/bin/pg_encoding: error while loading shared libraries:
libpq.so.2: cannot open shared object file: No such file or directory
initdb: pg_encoding failed

Perhaps you did not configure PostgreSQL for multibyte support or
the program was not successfully installed.
/************ End Error Message *************/

I know the multibyte character is there, because template1 was created with
UNICODE. Also, I added /usr/local/lib/pgsql to my /etc/ld.so.conf and ran
ldconfig before trying to start on all instances.

I appreciate any assistance. If you need me to email my configuration output
or configure parameters please let me know.

Thanks for your time and patience.

Warmest Regards,

Dan


pgsql-novice by date

Next:From: Henshall, Stuart - WCPDate: 2002-07-26 14:16:12
Subject: Re: order by int
Previous:From: Duncan Adams (DNS)Date: 2002-07-26 12:26:00
Subject: order by int

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group