Monday, January 30, 2017

psql: symbol lookup error: psql: undefined symbol: PQsslInUse

so, i have a postgres 9.4 on a fedora 23 when fedora 25 was released. i tend to keep the second recent version of OS, so i upgraded to fedora 24 via dnf. after upgrade, my rails apps that use my postgres worked okay. that means everything is running. but when i had to connect to postgres through console, i got this:


rather than committing myself to solving it, i made do with using rails console to access my database.

a friend upgraded his ubuntu 14 to ubuntu 16 and had his rails apps set up. his postgres was working as it should. so, it's time i had to make my console access to work again.

i checked postgresql packages installed on my box, and got these:


i uninstalled postgresql 9.5 installations done by my os upgrade and left these packages:


then i got a command not found when i run psql, i searched the psql command and created a sym link to /bin/ as so:



apir! psql through console is back yep, t'was just a postgresql client-server version mismatch :)

1 comment:

  1. The error "psql: symbol lookup error: psql: undefined symbol: PQsslInUse" typically occurs when there's a mismatch between the installed PostgreSQL libraries and the version of the client. To resolve this, ensure that your PostgreSQL installation is up to date and compatible with the libraries being used, or consider reconfiguring your environment to eliminate conflicts. GodMode9 can help troubleshoot and resolve such issues with its system management tools.

    ReplyDelete

SSH : No matching host key type found. Their offer: ssh-rsa,ssh-dss

Got this while connecting to my mikrotik router via ssh   Unable to negotiate with <ip address> port <ssh port>: no matching hos...