X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 305E4DBC91 for ; Sat, 19 Nov 2005 18:01:12 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17360-05 for ; Sat, 19 Nov 2005 22:01:13 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web52014.mail.yahoo.com (web52014.mail.yahoo.com [206.190.48.97]) by svr1.postgresql.org (Postfix) with SMTP id 33813DBC7E for ; Sat, 19 Nov 2005 18:01:08 -0400 (AST) Received: (qmail 33435 invoked by uid 60001); 19 Nov 2005 22:01:10 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=q+jyj5UZpZwoDqHuAefn2pWMapHlXjGSSmvYPFZqRoXwnPpv7oK9qtXA76f8ijjX7gkmcL39FPALcuTn5sCcSS3F8pnymOy0Owp9Jp73VetPELb18N46AVD3f5yd4M2ichS3omkDkv7PpEfGO7/YIPUNlGRcVHFMRuSnTKXf6cE= ; Message-ID: <20051119220110.33429.qmail@web52014.mail.yahoo.com> Received: from [86.136.215.249] by web52014.mail.yahoo.com via HTTP; Sat, 19 Nov 2005 14:01:10 PST Date: Sat, 19 Nov 2005 14:01:10 -0800 (PST) From: olive Mckenzie Subject: Re: "ld.so.l: /usr/local/pgsql/bin/initdb: fatal: libreadline.so.4: open failed: No such file or directory" To: Jeff Frost Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1341648861-1132437670=:28257" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.4 required=5 tests=[AWL=-0.080, DNS_FROM_RFC_ABUSE=0.479, HTML_MESSAGE=0.001] X-Spam-Score: 0.4 X-Spam-Level: X-Archive-Number: 200511/257 X-Sequence-Number: 19630 --0-1341648861-1132437670=:28257 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit What is the exact command you are running (copy/paste)? As simply issuing "su postgres" should not run initdb on login. I typed # su postgres $ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data Then I got the message $ ld.so.l: /usr/local/pgsql/bin/initdb: fatal: libreadline.so.4: open failed: No such file or directory Note /usr/local/pgsql/data is owned by postgres Are you installing from the TARFILE or from a solaris pkg? I have installed all the files from Sun freeware sites for solaris 10 .gz files even postgresql-8.0.1. gunzip to unpack and pkgadd -d file name minus .gz to install. To get your command to run, you probably just need to do the following before you execute it, you could also add this to your bash profile: export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/sfw/lib Where is my bash file in /etc/skel/ I have local.cshrc local.login and local.profile Olive Jeff Frost wrote: Olive, please don't take the pgsql-admin@postgresql.org address out of the list as others will likely have excellent info for you as well, plus people can search the archives when they have similar problems. Are you installing from the TARFILE or from a solaris pkg? What is the exact command you are running (copy/paste)? As simply issuing "su postgres" should not run initdb on login. To get your command to run, you probably just need to do the following before you execute it, you could also add this to your bash profile: export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/sfw/lib On Sat, 19 Nov 2005, olive Mckenzie wrote: > Hello Jeff Frost, > > I have installed installed libreadline.so.4. When I do a search for it I > find it in /opt/sfw/lib. > > initdb kicks off even if i try the command from root. > > Olive > > Jeff Frost wrote: > Olive, > > You need to locate the libreadline.so.4 shared library on your system. I'm > guessing it's not in any of the standard locations and then add that path to > your LD_LIBRARY_PATH. You might also need to install libreadline if you do > not have it available on your system. > > I'm curious as to why initdb is kicking off when you su to the postgres user > though. Is this how the solaris pkg is set up? > > > I'm curious as to why initdb is kicking off when you su to the postgres > user though. Is this how the solaris pkg is set up? > The reason for using "su postgres" > is that it is part of the instructions give by postgresql-8.0.1 for > installing the software into the user postgres directory. -- Jeff Frost, Owner Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. --0-1341648861-1132437670=:28257 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
What is the exact command you are running (copy/paste)? As simply issuing "su
postgres" should not run initdb on login.

I typed
 
# su postgres
$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
 
Then I got the message
 
$ ld.so.l: /usr/local/pgsql/bin/initdb: fatal: libreadline.so.4: open failed: No such file or directory
 
Note /usr/local/pgsql/data is owned by postgres
 
Are you installing from the TARFILE or from a solaris pkg?
 
I have installed all the files from Sun freeware sites for solaris 10 .gz files even postgresql-8.0.1.
 
gunzip to unpack and pkgadd -d file name minus .gz to install.

To get your command to run, you probably just need to do the following before
you execute it, you could also add this to your bash profile:

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/sfw/lib
 
 
Where is my bash file
 
in /etc/skel/
 
I have    local.cshrc    local.login and local.profile 
 
 
Olive



Jeff Frost <jeff@frostconsultingllc.com> wrote:
Olive, please don't take the pgsql-admin@postgresql.org address out of the
list as others will likely have excellent info for you as well, plus people
can search the archives when they have similar problems.

Are you installing from the TARFILE or from a solaris pkg?

What is the exact command you are running (copy/paste)? As simply issuing "su
postgres" should not run initdb on login.

To get your command to run, you probably just need to do the following before
you execute it, you could also add this to your bash profile:

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/sfw/lib

On Sat, 19 Nov 2005, olive Mckenzie wrote:

> Hello Jeff Frost,
>
> I have installed installed libreadline.so.4. When I do a search for it I
> find it in /opt/sfw/lib.
>
> initdb kicks off even if i try the command fr om root.
>
> Olive
>
> Jeff Frost wrote:
> Olive,
>
> You need to locate the libreadline.so.4 shared library on your system. I'm
> guessing it's not in any of the standard locations and then add that path to
> your LD_LIBRARY_PATH. You might also need to install libreadline if you do
> not have it available on your system.
>
> I'm curious as to why initdb is kicking off when you su to the postgres user
> though. Is this how the solaris pkg is set up?
>
>
> I'm curious as to why initdb is kicking off when you su to the postgres
> user though. Is this how the solaris pkg is set up?

> The reason for using "su postgres"

> is that it is part of the instructions give by postgresql-8.0.1 for
> installing the software into the user postgres directory.


--
Jeff Frost, Owner
Frost Consu lting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954




Yahoo! FareChase - Search multiple travel sites in one click. --0-1341648861-1132437670=:28257--