From: | Chris Kelly <sampro_domains(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Ubuntu 18 + PHP 8.2 + PDO: can't find drivers |
Date: | 2023-09-23 18:56:38 |
Message-ID: | 1579525868.3160198.1695495398844@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Ubuntu "18.04.6 LTS (Bionic Beaver)":
# apt-cache search pgsql | grep 8
pike7.8-pg - PostgreSQL modules for Pike
pike8.0-pg - PostgreSQL modules for Pike
# apt-cache search pgsql | grep php
php-pgsql - PostgreSQL module for PHP [default]
php7.2-pgsql - PostgreSQL module for PHP
php-db - Database Abstraction Layer
php-mdb2-driver-pgsql - pgsql MDB2 driver
This is for an existing site with an existing db dump and an existing codebase. I can't use PHP7 due to composer requirements.
I tried to add the ondrej repo but got "The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29".
On Friday, September 22, 2023 at 02:38:24 PM PDT, Ray O'Donnell <ray(at)rodonnell(dot)ie> wrote:
On 22 September 2023 21:40:38 Chris Kelly <sampro_domains(at)yahoo(dot)com> wrote:
The need has mostly passed (I used another computer with Ubuntu 20) but are there clear, *working* instructions for how to connect to Postgress on Ubuntu 18 via PDO? I don't see drivers that would work. This is for a Drupal site.
From memory (not at my laptop now) you need to install the php8.2-pgsql package (or maybe it's php8.2-pdo-pgsql). It should just work then... Drupal will notice the driver and offer Postgresql as an option on installation. Don't forget to restart Apache after installing that package
Ray.
From | Date | Subject | |
---|---|---|---|
Next Message | postmaster | 2023-09-23 21:14:58 | Re: Ubuntu 18 + PHP 8.2 + PDO: can't find drivers |
Previous Message | Alan Hodgson | 2023-09-22 22:43:03 | Re: connecting to new instance |