From: Tom Lane <tgl@sss.pgh.pa.us>
To: dbx postgres <dbx2postgres@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: psql error
Date: Wed, 21 Mar 2018 15:06:36 -0400
Message-ID: <13002.1521659196@sss.pgh.pa.us> (raw)
In-Reply-To: <CAPecLkD4twu14L82La+Q7wAzryexb53psXhKf87F04BmvLTBiA@mail.gmail.com>
References: <CAPecLkD4twu14L82La+Q7wAzryexb53psXhKf87F04BmvLTBiA@mail.gmail.com>
dbx postgres <dbx2postgres@gmail.com> writes:
> I have postgres running on my server but when i try to run psql I get the
> below error
> *psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams *
Apparently, you have a 9.0-or-later psql trying to use a pre-9.0 copy
of libpq.so, because that function was added in 9.0. This would seem
to mean that you have (portions of?) at least two different PG
installations, and they're not staying out of each others' way.
Hard to say more than that with only this much data.
If this is a Linux platform, applying "ldd" to the psql executable
would reveal which libpq it's trying to use.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, dbx2postgres@gmail.com
Subject: Re: psql error
In-Reply-To: <13002.1521659196@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox