Tom Lane wrote:
That was it! Thanks! Yeah I had the postgresql-client-8.2.6 package loaded from OpenBSD packages....Chris Paul <chris.paul@xxxxxxxxxxxxx> writes:I exported an 8.2.6 database and am trying to load it on 8.3.0. I get this error:[postgres@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 CP --
Chris Paul Sentinare Messaging Solutions, Inc 309 Cedar Street #72, Santa Cruz, CA 95060 email: chris.paul@xxxxxxxxxxxxx web: http://www.sentinare.com phone, toll-free: +1 (877) 727-9786 The
information transmitted is intended only for the person or entity to P Please don't print this e-mail, unless you really need to.
|