Re: VMS x86-64 database server

On 7/7/25 12:01 PM, Arne Vajhøj wrote:

On 7/7/2025 10:50 AM, Mark Berryman wrote:

On 7/6/25 5:57 PM, Arne Vajhøj wrote:

And that PHP pgsql & pdo_pgsql and Python psychopg2
should be just a build problem.

>
$ php -i
.
.
.
PDO
PDO support => enabled
PDO drivers => mysql, pgsql, sqlite
pdo_mysql
PDO Driver for MySQL => enabled
pdo_pgsql
PDO Driver for PostgreSQL => enabled
pdo_sqlite
PDO Driver for SQLite 3.x => enabled
>
pgsql
pgsql.allow_persistent => On => On
pgsql.auto_reset_persistent => Off => Off
pgsql.ignore_notice => Off => Off
pgsql.log_notice => Off => Off
pgsql.max_links => Unlimited => Unlimited
pgsql.max_persistent => Unlimited => Unlimited
>
My PHP port has pgsql and pdo_pgsql support using the VSI libpq library.

 I do use your PHP.
 But I do not have pgsql and pdo_pgsql loaded.
 $ pipe php -i | search sys$input php,version/match=and
PHP Version => 8.1.23
$ pipe php -i | search sys$input pdo
...
PDO
PDO support => enabled
PDO drivers => mysql
pdo_mysql
PDO Driver for MySQL => enabled
...
 The funny thing is that unlike most other extensions
then PHP_PGSQL.EXE and PHP_PDO_PGSQL.EXE exist
as seperate files. But even if I try to load them in
php.ini, then nothing.
 I must be missing something. Probably something basic,
but ...

Some of the extensions were built as separate loadable modules either due to their size or because they require separate optional libraries that not everyone has.  All that is necessary to load them is to have the following in php_root:[000000]php.ini:
extension=php_pdo_pgsql.exe
extension=php_pgsql.exe
and to make sure that php.ini is readable by the account running php (and, of course, for libpq from VSI to be installed).
If that still doesn't work then try the following:
$ php -na
php > echo dl("php_pgsql.exe");
php >
If that returns a 1, you have successfully loaded the extension and there is something wrong with your php.ini file.  If it returns a 0, you will get an error message telling you why the extension could not be loaded.
Mark Berryman