Thread: 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.
Sorted :-)
Z.
----- Original Message -----From: Zitan BrothSent: Monday, October 13, 2003 4:37 PMSubject: [GENERAL] Upgrading to 7.4betaGreetings 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 dbawesome? 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: > 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 > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > > >
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: > 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: > >> 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 >> >> >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 7: don't forget to increase your free space map settings >> >> >> > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if > your > joining column's datatypes do not match > >
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
-----------------------------------------------------------------