build(deps): bump pg from 1.5.9 to 1.6.2

[dependabot[bot]]

Bumps pg from 1.5.9 to 1.6.2.

Changelog

Sourced from pg's changelog.

v1.6.2 [2025-09-02] Lars Kanis [email protected]

• Remove several absolute paths from native binaries which pointed to build directories. #668
• Fix bad fallback path to pg_service.conf. #666
• Use rbpg_ prefix for base64_* functions to avoid name clashes with functions provided by other libraries like Heimdal on Macos. #667
• Raise a more descriptive error message in case of pg_ext LoadError. #664
• Freeze some constants to make them available in a Ractor context. #660
• Several documentation improvements.
• Update native binary gems to OpenSSL-3.5.2, krb5-1.22.1 and PostgreSQL-17.6.

v1.6.1 [2025-08-03] Lars Kanis [email protected]

• Add binary gems for platforms aarch64-linux-musl and x86_64-linux-musl without the need to install package gcompat. #657.
• Serialize CompositeCoder#dimensions only when set. #652 This fixes the compatibility to pg-1.5.9, when deserializing Marshal data from pg-1.6, as long as the new attribute isn't used.
• Remove dependency to MSYS2 package "postgresql" from binary Windows gem #654

v1.6.0 [2025-07-27] Lars Kanis [email protected]

Added:

• Add binary gems for Ruby 3.4.
• Add fat binary gem for platform aarch64-mingw-ucrt aka Windows on ARM #626, for platform Macos on Intel and ARM #643, for platform aarch64-linux #646 and for platform x86_64-linux #551.
• Update fat binary gem to OpenSSL-3.5.1 and PostgreSQL-17.5.
• Add a patch to libpq to avoid starvation on bigger SSL records, which some database engines other than vanilla PostgreSQL use. This patch applies to platform specific binary gems only. #616
• Add support for new query cancel functions of PostgreSQL-17. This adds the new class PG::CancelConnection which provides the ability to cancel a query per blocking or per non-blocking functions. If the new functions are available they are used and the older are no longer compiled in. This way we can get rid of reading out the internal PGcancel struct by Connection#backend_key. #614
• Add PG::BinaryDecoder::Array and PG::BinaryEncoder::Array to parse and encode PostgreSQL arrays in binary format. #603
• Add possibility to define the number of array dimensions to be encoded. Setting dimensions is especially useful, when a Record shall be encoded into an Array, since the Array encoder can not distinguish if the array shall be encoded as a higher dimension or as a record otherwise. #622
• Add Connection#set_chunked_rows_mode #610
• Add PG::Connection#close_prepared, PG::Connection#close_portal, PG::Connection#send_close_prepared and PG::Connection#send_close_portal which are new in PostgreSQL-17. #611
• Add Connection#send_pipeline_sync, async_pipeline_sync and release GVL at PQ(sendP|P)ipelineSync. #612
• Add MINGW package dependency which is resolved by RubyInstaller. #617
• Change conn.server_version and conn.protocol_version to raise instead of return 0 on error. #632
• Fix connecting to multiple hosts after connnect_timeout. #637

... (truncated)

Commits

• c75ed8d Bump VERSION to 1.6.2
• 90a00e5 Update CHANGELOG for pg-1.6.2
• c584348 Merge pull request #670 from larskanis/update-deps
• 227653d Update dependencies
• 428415d Prepare CHANGELOG for 1.6.2 [skip ci]
• 4282e5c Merge pull request #669 from larskanis/test-rpath
• 19a3547 Strip darwin C-ext to remove paths to C files
• 5e2ac6e Temporary enable head version of rake-compiler-dock
• 70551b9 Add spec/pg_spec.rb to tests
• 35b2704 Add tests for rpath or other build related paths
• Additional commits viewable in compare view

You can trigger a rebase of this PR by commenting @dependabot rebase.

---

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot show <dependency name> ignore conditions will show all of the ignore conditions of the specified dependency
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

Note Automatic rebases have been disabled on this pull request as it has been open for over 30 days.

[compwron]

@dependabot rebase

[compwron]

Run docker compose exec -T web rails db:setup
bin/rails aborted!
Bundler::GemRequireError: There was an error while trying to load the gem 'pg'. (Bundler::GemRequireError)
Gem Load Error is: pg's C extension failed to load:
  Error loading shared library libresolv.so.2: No such file or directory (needed by /usr/local/bundle/gems/pg-1.6.2-x86_64-linux/lib/3.3/../../ports/x86_64-linux/lib/libpq-ruby-pg.so.1) - /usr/local/bundle/gems/pg-1.6.2-x86_64-linux/lib/3.3/pg_ext.so
  cannot load such file -- pg_ext

Backtrace for gem load error is:
/usr/local/lib/ruby/3.3.0/bundled_gems.rb:69:in `require'
/usr/local/lib/ruby/3.3.0/bundled_gems.rb:69:in `block (2 levels) in replace_require'

[compwron]

@dependabot rebase

[compwron]

@dependabot rebase