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-30 19:33:31 |
Message-ID: | 00ce01c237ff$fcc089e0$fb0010ac@netcandor.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
Sincerely,
Daniel
From | Date | Subject | |
---|---|---|---|
Next Message | Chad Thompson | 2002-07-30 20:20:00 | Very slow query |
Previous Message | knut.suebert | 2002-07-30 19:22:46 | delete other similar entries with timestamp <= timestamp+15min? |