#32026 – PostgreSQL

Posted in ‘Akeeba Solo (standalone)’
This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Thursday, 21 November 2019 09:51 CST
Hello,

I am trying to back up a site using a PostgreSQL database. The error says not connecting to MySQL but the connection details are correct.

I have attached the error log so hopefully, you can see what is going wrong.

EDIT: please use the log in my reply. Not this log

Regards,
Geoff
Custom Fields
PHP version (in x.y.z format) 7.1
Akeeba Solo version (x.y.x) 3.6.1
 
gcurrey
Thursday, 21 November 2019 10:03 CST
This is the correct log.
 
gcurrey
Thursday, 21 November 2019 10:52 CST
Hi Geoff,

In the past we supported three families of database servers: MySQL (MySQL, Percona, MariaDB), PostgreSQL and MS SQL Server (MS SQL Server and Azure SQL Server). However, our usage statistics showed that the number of users for non-MySQL servers were very literally less than a handful.

At the same time non-MySQL databases do not have good support for exporting the DDL of their tables and views, much less for procedures, functions and triggers. We had to go to extreme lengths to provide a mostly accurate database dump. Because of that they also required a lot of very complicated maintenance which cost a disproportionate amount of development resources compared to their user base.

For this reason we decided to remove support for database servers not in the MySQL family in July 2019 with the release of Akeeba Solo and Backup for WordPress 3.6.0 and Akeeba Backup for Joomla 6.6.0. There are no plans to reintroduce support for them.

As you can see in Akeeba Solo there is no longer an option to set the Database Driver to anything but MySQL, MySQLi, PDO MySQL, None and SQLite (the latter two are basically the same since SQLite is in fact a file that's already being backed up). While nothing stops you from entering the connection information to a PostgreSQL database server there it will most definitely not work since PostgreSQL and MySQL are completely different database servers which use different connection protocols and different SQL dialects.

Therefore the message you are receiving is correct. Akeeba Solo only supports MySQL-family database servers and you're trying to use a PostgreSQL server. They can't talk to each other.


Nicholas K. Dionysopoulos

Lead Developer and Director



🇬🇷Greek: native

🇬🇧English: excellent

🇫🇷French: basic



Please keep in mind my timezone and cultural differences when reading my replies. Thank you!



nicholas
Saturday, 21 December 2019 17:17 CST
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.
system
This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.

Support Information

Working hours: Typically we work Monday to Friday, 9am to 7pm Cyprus timezone (EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets, but we cannot respond to them, outside of our working hours.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!

Cookies Notification - Action required

This website uses cookies to provide user authentication and improve your user experience. Please indicate whether you consent to our site placing these cookies on your device. You can change your preference later, from the controls which will be made available to you at the bottom of every page of our site.