Thread: 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@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Rob Sell Sent: Wednesday, November 19, 2003 8:05 AM To: pgsql-general@postgresql.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@postgresql.org
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@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
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@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
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
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.Elphick@lfix.co.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
Ask him to type "which psql" to identify which binary he's running... Tim Clarke -----Original Message----- From: Bruce Momjian [mailto:pgman@candle.pha.pa.us] Sent: 19 November 2003 16:53 To: lists@facnd.com Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] 7.4 broke psql 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.
On Wed, Nov 19, 2003 at 05:01:52PM -0000, Tim Clarke wrote: > Ask him to type "which psql" to identify which binary he's running... And ldd `which psql` to find out which libraries are being used. -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "In fact, the basic problem with Perl 5's subroutines is that they're not crufty enough, so the cruft leaks out into user-defined code instead, by the Conservation of Cruft Principle." (Larry Wall, Apocalypse 6)
Tim Clarke wrote:
> Ask him to type "which psql" to identify which binary he's running...
and to type
ldd `which psql`
as well.
Jan
>
> Tim Clarke
>
> -----Original Message-----
> From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
> Sent: 19 November 2003 16:53
> To: lists@facnd.com
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] 7.4 broke psql
>
>
> 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.
>
> ---------------------------(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
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
"Rob Sell" <lists@facnd.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