7.4 broke psql

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

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

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@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:

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

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