By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,954 Members | 1,133 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,954 IT Pros & Developers. It's quick & easy.

Relocation error pg_dumpall undefined symbol get_progname in 7.4.3

P: n/a
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 ?

Nov 23 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
"NTPT" <nt**@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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #2

P: n/a
"NTPT" <nt**@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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #3

P: n/a

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
pg***@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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #4

P: n/a

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
pg***@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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #5

P: n/a

----- Original Message -----
From: "Tom Lane" <tg*@sss.pgh.pa.us>
To: "NTPT" <nt**@centrum.cz>
Cc: <pg***********@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" <nt**@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 ...


---------------------------(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

Nov 23 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.