Re: 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