Re: Segmentation fault (core dumped) loading data on 8.3 upgrade: undefined symbol 'pg_valid_server_encoding_id', lazy binding failed!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris Paul <chris(dot)paul(at)sentinare(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Segmentation fault (core dumped) loading data on 8.3 upgrade: undefined symbol 'pg_valid_server_encoding_id', lazy binding failed!
Date: 2008-03-13 19:06:15
Message-ID: 27389.1205435175@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Chris Paul <chris(dot)paul(at)sentinare(dot)com> writes:
> I exported an 8.2.6 database and am trying to load it on 8.3.0. I get
> this error:

> [postgres(at)prague:/var/postgres]$ ql -d postgres <
> bak/dump.bak <
> /usr/local/bin/psql:/usr/local/bin/psql: undefined symbol
> 'pg_valid_server_encoding_id'
> lazy binding failed!

pg_valid_server_encoding_id() is exported by 8.3's libpq, but it does
not exist in 8.2 and before. What is evidently happening is that psql
is binding to an old copy of libpq.so. Check your PG installation.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message kevin 2008-03-13 19:06:33 Re: Is there a way to elegantly do a : CREATE TEMP TABLE X AS SELECT .... ON COMMIT DROP
Previous Message Steve Crawford 2008-03-13 19:02:36 Re: postgre vs MySQL