Arch Linux

Rocketfuel

Member

Registered: 2025-02-17

Posts: 1

pdo_pgsql error

Good day! I have a problem after updating the module PHP up to 8.4.3-1. Reinstallation does not help, I give the output below. I will be grateful for help

php -v

PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo_pgsql' (tried: /usr/lib/php/modules/pdo_pgsql (/usr/lib/php/modules/pdo_pgsql: cannot open shared object file: No such file or directory), /usr/lib/php/modules/pdo_pgsql.so (/usr/lib/php/modules/pdo_pgsql.so: undefined symbol: PQclosePrepared)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'pgsql' (tried: /usr/lib/php/modules/pgsql (/usr/lib/php/modules/pgsql: cannot open shared object file: No such file or directory), /usr/lib/php/modules/pgsql.so (/usr/lib/php/modules/pgsql.so: undefined symbol: PQchangePassword)) in Unknown on line 0
PHP 8.4.3 (cli) (built: Jan 15 2025 08:09:27) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.4.3, Copyright (c) Zend Technologies
    with Zend OPcache v8.4.3, Copyright (c), by Zend Technologies

pacman -Qkk php

backup file: php: /etc/php/php.ini (Modification time mismatch)
backup file: php: /etc/php/php.ini (Size mismatch)
backup file: php: /etc/php/php.ini (SHA256 checksum mismatch)
php: 421 total files, 0 altered files

pacman -Qi php

Name            : php
Version         : 8.4.3-1
Description     : A general-purpose scripting language that is especially suited to web development
Architecture    : x86_64
URL             : [url]https://www.php.net/[/url]
Licenses        : PHP-3.01
Groups          : None
Provides        : php-interpreter=8.4  php-intl=8.4.3
Depends On      : libxml2  curl  libzip  pcre2  argon2  oniguruma
Optional Deps   : None
Required By     : php-apcu  php-cgi  php-fpm  php-gd  php-geoip  php-igbinary  php-imagick  php-memcache  php-memcached  php-pgsql  php-sodium  wp-cli
                  zabbix-frontend-php
Optional For    : None
Conflicts With  : php-intl
Replaces        : php-intl
Installed Size  : 31.49 MiB
Packager        : Pierre Schmitz <pierre@archlinux.org>
Build Date      : Wed 15 Jan 2025 12:09:27 PM +02
Install Date    : Mon 17 Feb 2025 11:16:24 AM +02
Install Reason  : Explicitly installed
Install Script  : No
Validated By    : Signature

Last edited by Rocketfuel (2025-02-17 08:59:34)

gromit

Administrator

From: Germany

Registered: 2024-02-10

Posts: 1,526

Website

Re: pdo_pgsql error

Someone now filed an issue about this: https://gitlab.archlinux.org/archlinux/ … -/issues/6

loqs

Member

Registered: 2014-03-06

Posts: 18,877

Re: pdo_pgsql error

Strangely I can not reproduce this in a chroot either with or without testing enabled:
Without testing:

# php -v
PHP 8.4.3 (cli) (built: Jan 15 2025 08:09:27) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.4.3, Copyright (c) Zend Technologies
php -m
[PHP Modules]
Core
ctype
curl
date
dom
fileinfo
filter
hash
json
libxml
mbstring
mysqlnd
openssl
pcntl
pcre
PDO
pdo_pgsql
pgsql
Phar
posix
random
readline
Reflection
session
SimpleXML
SPL
standard
tokenizer
xml
xmlreader
xmlwriter
zip
zlib

[Zend Modules]

With testing:

# php -v
PHP 8.4.4 (cli) (built: Feb 11 2025 18:24:50) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.4.4, Copyright (c) Zend Technologies
# php -m
[PHP Modules]
Core
ctype
curl
date
dom
fileinfo
filter
hash
json
libxml
mbstring
mysqlnd
openssl
pcntl
pcre
PDO
pdo_pgsql
pgsql
Phar
posix
random
readline
Reflection
session
SimpleXML
SPL
standard
tokenizer
xml
xmlreader
xmlwriter
zip
zlib

[Zend Modules]

baumwolltier

Member

Registered: 2025-02-18

Posts: 1

Re: pdo_pgsql error

I encountered this error as well (I created the ticket on the issue tracker). My problem was that I pinned the `postgresql` and `postgresql-libs` packages and they were out of date (16.x). After manually upgrading these packages to 17.x (see https://wiki.archlinux.org/title/Postgr … ostgreSQL), the `php-pgsql` module works again for me