Upgrading to 7.4beta

Sorted :-)

Z.
----- Original Message -----
From: Zitan Broth
To: PostgreSQL general list
Sent: Monday, October 13, 2003 4:37 PM
Subject: [GENERAL] Upgrading to 7.4beta

Greetings All,

I compiled pg from source last week as pg 7.3.4 which worked sweet. Then I decided there was some functionality in 7.4beta that I just needed to look at :-)

So I:
*stopped pg
*downloaded the source
*deleted data dir
*configured, gmake, gmake install
*init db
*setup db

awesome? Accept when I go slection version() pg tells me 7.3.4 !!!!

I realise this is rather newbie, but suggestions are greatfully accepted :-)
Z.

Zitan Broth wrote:

Sorted :-)

Curiously, how?

Shridhar

Hi,
I just installed 7.3.4 on a solaris machine (solaris 8) but can't get
postmaster to start.

It always terminates with the message
ld.so.1: /..../postgres: fata: libreadline.so.4: open failed: No such
file or directory

1: LD_LIBRARY_PATH is set at installation time and when starting the
postmaster
2: the libreadline.so.4 is installed (solaris package)

I did not have a problem on other solaris machines but something seems
to be missing. Is there a way to link the libreadline ?

Alex

As far as i Know libreadline is a library file that comes with gcc. (
But don't quote me on that)
On my solaris 8 box it is insalled in /opt/sfw/lib. But there is a link
from libreadline.so set to libreadline.so.4
you could try making this link and setting the LD_LIBRARY_PATH to the
directory with the link.
I got the exact error you did before. It's just a library path error.
Postgres can't find the correct library to load.

David

Alex wrote:

The LD_LIBRARY_PATH actually points to the library, I am even able to
execute the initdb but the postmaster always fails

Alex

David McLoughlin wrote:

Alex <alex@meerkatsoft.com> writes:

The LD_LIBRARY_PATH actually points to the library, I am even able to
execute the initdb but the postmaster always fails

In that case, almost certainly, the environment you are starting the
postmaster in is different from the one you ran initdb in (no
LD_LIBRARY_PATH setting, probably). Better check where LD_LIBRARY_PATH
is set and how that setting will propagate to the postmaster.

regards, tom lane

El Lun 13 Oct 2003 11:38, Tom Lane escribió:

Alex <alex@meerkatsoft.com> writes:

The LD_LIBRARY_PATH actually points to the library, I am even able to
execute the initdb but the postmaster always fails

In that case, almost certainly, the environment you are starting the
postmaster in is different from the one you ran initdb in (no
LD_LIBRARY_PATH setting, probably). Better check where LD_LIBRARY_PATH
is set and how that setting will propagate to the postmaster.

Listen carfully to what Tom says, cuase he helped me with this same problem in
the past! :-)

What I did was put in the /etc/init.d/postgresql file, at the line that starts
the postmaster (executing the postamaster directly or running pg_ctl) the
longer LD_LIBRARY_PATH.

Something like this:

echo -n "Starting postgresql service: "
su - postgres -c "export
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib; /dbs/postgres/bin/pg_ctl -o
\"-o -e\" -D /dbs/postgres/data/ start >& /dev/null"

Sorry for the lines that got cut. :-(

--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués | mmarques@unl.edu.ar
Programador, Administrador, DBA | Centro de Telemática
Universidad Nacional
del Litoral
-----------------------------------------------------------------