7.4 broke psql

Greetings all,

Yesterday I upgraded from 7.3 to 7.4 now psql doesn't work! I get the
following error.

psql: relocation error: psql: undefined symbol: get_progname

Any ideas out there?

Rob

I hate replying to my own posts but its not broken for everyone, just
regular users. It works for postgres and root, but not for my user "robs"
robs is a database super user... weird I guess but I can live with it...

Rob

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Rob Sell
Sent: Wednesday, November 19, 2003 8:05 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] 7.4 broke psql

Greetings all,

Yesterday I upgraded from 7.3 to 7.4 now psql doesn't work! I get the
following error.

psql: relocation error: psql: undefined symbol: get_progname

Any ideas out there?

Rob

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

On Wed, 2003-11-19 at 14:04, Rob Sell wrote:
> Greetings all,
>
> Yesterday I upgraded from 7.3 to 7.4 now psql doesn't work! I get the
> following error.
>
> psql: relocation error: psql: undefined symbol: get_progname
>
> Any ideas out there?

You are probably trying to link against an old version of libpq.so

Clean out your old installation and make sure the new psql picks up the
new shared library.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"To show forth thy lovingkindness in the morning, and
thy faithfulness every night." Psalms 92:2

On Wed, 2003-11-19 at 09:04, Rob Sell wrote:
> Greetings all,
>
> Yesterday I upgraded from 7.3 to 7.4 now psql doesn't work! I get the
> following error.
>
> psql: relocation error: psql: undefined symbol: get_progname
>
> Any ideas out there?
>

7.3 versions of psql may not work properly against 7.4 versions of the
database. Make sure you have a 7.4 version of psql.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Rob Sell wrote:
> Greetings all,
>
> Yesterday I upgraded from 7.3 to 7.4 now psql doesn't work! I get the
> following error.
>
> psql: relocation error: psql: undefined symbol: get_progname

Perhaps run ldconfig or remove the old binaries from your path.

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

Rob Sell wrote:
> I hate replying to my own posts but its not broken for everyone, just
> regular users. It works for postgres and root, but not for my user "robs"
> robs is a database super user... weird I guess but I can live with it...

If it works for some users and not others, it must be his PATH that is
looking at the old binaries.

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

"Rob Sell" <lists(at)facnd(dot)com> writes:
> I hate replying to my own posts but its not broken for everyone, just
> regular users. It works for postgres and root, but not for my user "robs"
> robs is a database super user... weird I guess but I can live with it...

Sounds to me like a permissions problem on some shared library --- ie,
it's owned by postgres and not world-readable.

regards, tom lane