Re: Error running initdb

Thanks for the response. As it happens, I DID search the archives, but
did not see this post. I saw a couple of related questions with no
follow-up answers....

I am not running this under a separate username, so the LD_LIBRARY_PATH
set in my own .cshrc should apply, I would think. Does
/etc/init.d/postgresql still need to be modified, even if there is no
special postgresql user?

- DAP

-----Original Message-----
From: Jim Seymour [mailto:jseymour@linxnet.com]
Sent: Tuesday, June 01, 2004 11:57 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Error running initdb


"David Parker" <dparker@tazznetworks.com> wrote:
>
> I'm new to postgresql, first of all, and I'm not sure if this is the
> correct list....
>
> I have built 7.4.2 on Solaris 8/SPARC. I *think* "make install"
> generated all the expected
> artifacts.
>
> When I run initdb, I get the following output:
>
> % initdb -D /home/dparker/servers/install/data/testdb1
[snip]
> creating conversions... ERROR:  could not access file
> "$libdir/ascii_and_mic": No such file or directory
>
> initdb: failed
>
> The ascii_and_mic.so is in $PREFIX/lib/postgresql. I've tried copying
> it up one level, and also tried including that path in
> LD_LIBRARY_PATH. The value for $libdir in config.status appears to be
correct.
>
> I'm pretty sure I'm missing something obvious. Can somebody give me a
> clue where to look?
[snip]

Had you searched the mailing list's archives, you would've seen this...

| From jseymour Tue May  4 19:26:27 2004
| To: pgsql-admin@postgresql.org
| Subject: Re: [ADMIN] initdb error
|
| "Kevin Schroeder" <kschroeder@mirageworks.com> wrote:
| > Message-ID: <5a6301c431fd$1cb1d580$0200a8c0@WORKSTATION>
| >
| > Hello,
| >     I'm trying to install PostgreSQL on Solaris 9.  Everything's
| > compiled properly but when I run initdb I get the following error:
| >
| [snip]
| > creating conversions... ERROR:  could not load library
| > "/usr/local/pgsql/lib/ascii_and_mic.so": ld.so.1:
| > /usr/local/pgsql/bin/postgres: fatal: libgcc_s.so.1: open failed: No

| > such file or directory
| >
| > I found libgcc_s.so.1 in /usr/local/lib and that directory is in
| > $LD_LIBRARY_PATH.  Is there anything that I'm missing here or that I

| > need to look for in my configure settings?
|
| Is that directory in LD_LIBRARY_PATH when you're su'd to the
| postgreSQL user?
|
| I added
|
|     LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib; export
| LD_LIBRARY_PATH
|
| to /etc/init.d/postgresql and created a .profile in its home directory

| with that in it.
|
| Solved all those problems :).
|
| You can also solve such problems by using the -R switch during build
| (man ld) and with Solaris 8/9's new "crle" utility.

Jim

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org