Thread: Relocation error pg_dumpall undefined symbol get_progname in 7.4.3

"NTPT" <ntpt@centrum.cz> writes:
> I recently compile Postgresql 7.4.3 with gcc 3.4.0 on RH 7.3 . Regression t=
> ests work well All passed, but
> Some binaries report a relocation error: :pg_dumpall undefined symbol get_p=
> rogname .=20
> This error occures in most of the binaries. What is wrong  ?

They're linking to an older version of libpq.so.  Check your ldconfig
library search path.

            regards, tom lane

It means you have an old version of the PostgreSQL libraries in your
library search path.

---------------------------------------------------------------------------

NTPT wrote:
> Regardi
>
> I recently compile Postgresql 7.4.3 with gcc 3.4.0 on RH 7.3 . Regression tests work well All passed, but
>
> Some binaries report a relocation error: :pg_dumpall undefined symbol get_progname .
>
> This error occures in most of the binaries. What is wrong  ?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "NTPT" <ntpt@centrum.cz>
Cc: <pgsql-general@postgresql.org>
Sent: Sunday, June 20, 2004 3:28 PM
Subject: Re: [GENERAL] Relocation error pg_dumpall undefined symbol
get_progname in 7.4.3


> "NTPT" <ntpt@centrum.cz> writes:
> > I recently compile Postgresql 7.4.3 with gcc 3.4.0 on RH 7.3 .
Regression t=
> > ests work well All passed, but
> > Some binaries report a relocation error: :pg_dumpall undefined symbol
get_p=
> > rogname .=20
> > This error occures in most of the binaries. What is wrong  ?
>
> They're linking to an older version of libpq.so.  Check your ldconfig
> library search path.
>

Bingo. I was fooled by  maual, saying me that :

To make the backup, you can use the pg_dumpall command from the version you
are currently running. For best results, however, try to use the pg_dumpall
command from PostgreSQL 7.4.2, since this version contains bug fixes and
improvements over older versions. While this advice might seem idiosyncratic
since you haven't installed the new version yet, it is advisable to follow
it if you plan to install the new version in parallel with the old version.
In that case you can complete the installation normally and transfer the
data ater. This will also decrease the downtime.
so I  thing  recomended approach should be :

gmake -C src/bin install
gmake -C src/include install
gmake -C src/interfaces installto install a new version of the tools for
"best results"

pg_dumpall  to dump databse

/etc/init.d/postgresql stop

gmake  ... etc

Thanx for help ...