Thread: BUG #17674: undefined symbol: pg_fprintf
The following bug has been logged on the website: Bug reference: 17674 Logged by: Kiswono Prayogo Email address: kiswono@gmail.com PostgreSQL version: 12.12 Operating system: Ubuntu 22.04 Description: pg_fprintf not found on the installed version of postgres, breaking existing application root@data:~# dpkg -l | grep postgres ii postgresql-12 12.12-0ubuntu0.20.04.1 amd64 object-relational SQL database, version 12 server ii postgresql-client-12 12.12-0ubuntu0.20.04.1 amd64 front-end programs for PostgreSQL 12 ii postgresql-client-common 238 all manager for multiple PostgreSQL client versions ii postgresql-common 238 all PostgreSQL database-cluster manager ii postgresql-doc-12 12.12-0ubuntu0.20.04.1 all documentation for the PostgreSQL database management system ii postgresql-server-dev-12 12.12-0ubuntu0.20.04.1 root@data:~# dpkg -l | grep libpq ii libpq-dev 12.12-0ubuntu0.20.04.1 amd64 header files for libpq5 (PostgreSQL library) ii libpq5:amd64 12.12-0ubuntu0.20.04.1 internal:/usr/lib/ruby/vendor_ruby/rubygems/core_ext/kernel_require.rb>:85:in `require': /var/lib/gems/3.0.0/gems/do_postgres-0.10.17/lib/do_postgres/do_postgres.so: undefined symbol: pg_fprintf https://stackoverflow.com/questions/74284886/require-var-lib-gems-3-0-0-gems-do-postgres-0-10-17-lib-do-postgres-do-postg
Nevermind, it was ruby3.0's issue, after downgrading to ruby2.7 it works fine.
On Wed, Nov 2, 2022 at 1:50 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:
Bug reference: 17674
Logged by: Kiswono Prayogo
Email address: kiswono@gmail.com
PostgreSQL version: 12.12
Operating system: Ubuntu 22.04
Description:
pg_fprintf not found on the installed version of postgres, breaking existing
application
root@data:~# dpkg -l | grep postgres
ii postgresql-12 12.12-0ubuntu0.20.04.1
amd64 object-relational SQL database, version 12 server
ii postgresql-client-12 12.12-0ubuntu0.20.04.1
amd64 front-end programs for PostgreSQL 12
ii postgresql-client-common 238
all manager for multiple PostgreSQL client versions
ii postgresql-common 238
all PostgreSQL database-cluster manager
ii postgresql-doc-12 12.12-0ubuntu0.20.04.1
all documentation for the PostgreSQL database management
system
ii postgresql-server-dev-12 12.12-0ubuntu0.20.04.1
root@data:~# dpkg -l | grep libpq
ii libpq-dev 12.12-0ubuntu0.20.04.1
amd64 header files for libpq5 (PostgreSQL library)
ii libpq5:amd64 12.12-0ubuntu0.20.04.1
internal:/usr/lib/ruby/vendor_ruby/rubygems/core_ext/kernel_require.rb>:85:in
`require':
/var/lib/gems/3.0.0/gems/do_postgres-0.10.17/lib/do_postgres/do_postgres.so:
undefined symbol: pg_fprintf
https://stackoverflow.com/questions/74284886/require-var-lib-gems-3-0-0-gems-do-postgres-0-10-17-lib-do-postgres-do-postg
--
Best Regards,
Kiswono P
Kiswono P
GB