While establishing a PostgreSQL connection through PHP, you might get the following error: uncaught exception "could not find driver". That means you need to install PHP pgsql on Amazon Linux 2.
Prerequisites
- Amazon Linux 2
- sudo privileges
- PHP installed
Install PHP Pgsql on Amazon Linux 2
Step 1. Enable the desired PHP version.
sudo amazon-linux-extras enable php{version}
For example:
sudo amazon-linux-extras enable php7.4
Step 2. Install php-pgsql.
sudo yum clean metadata
sudo yum install php php-pgsql
Step 3. Restart your web server service.
sudo systemctl restart nginx
sudo systemctl restart php-fpm
or
sudo systemctl restart httpd
Step 4. Create the phpinfo file.
echo "<?php phpinfo(); ?>" > /var/www/html/info.php
Step 5. Verify the installation.
http://server_ip/info.php
Conclusion
Feel free to leave a comment below and if you find this tutorial useful, follow our official channel on Telegram.