Thread: initdb error

initdb error

From
"Kevin Schroeder"
Date:
Hello,
    I'm trying to install PostgreSQL on Solaris 9.  Everything's compiled
properly but when I run initdb I get the following error:

Sun Microsystems Inc.   SunOS 5.9       Generic May 2002
The files belonging to this database system will be owned by user "pgsql".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /usr/local/pgsql/data... ok
creating directory /usr/local/pgsql/data/base... ok
creating directory /usr/local/pgsql/data/global... ok
creating directory /usr/local/pgsql/data/pg_xlog... ok
creating directory /usr/local/pgsql/data/pg_clog... ok
selecting default max_connections... 40
selecting default shared_buffers... 800
creating configuration files... ok
creating template1 database in /usr/local/pgsql/data/base/1... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
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?

Kevin


Re: initdb error

From
jseymour@LinxNet.com (Jim Seymour)
Date:
"Kevin Schroeder" <kschroeder@mirageworks.com> wrote:
>
> 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 Seymour                  | PGP Public Key available at:
jseymour@LinxNet.com         | http://www.uk.pgp.net/pgpnet/pks-commands.html
http://jimsun.LinxNet.com    |

Re: initdb error

From
"Kevin Schroeder"
Date:
That would seem to be the problem.

Thanks.

Kevin

----- Original Message -----
From: "Jim Seymour" <jseymour@LinxNet.com>
To: <pgsql-admin@postgresql.org>
Sent: Tuesday, May 04, 2004 6:26 PM
Subject: Re: [ADMIN] initdb error


> "Kevin Schroeder" <kschroeder@mirageworks.com> wrote:
> >
> > 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 Seymour                  | PGP Public Key available at:
> jseymour@LinxNet.com         |
http://www.uk.pgp.net/pgpnet/pks-commands.html
> http://jimsun.LinxNet.com    |
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend