PostgreSQL Vs other DB for Drupal 8

Per our analysis/discussion following are information about POSTgreSQL with respect to Drupal 8 Portal


1.Below link created on 2015 & updated until Aug-2019 lists the issues of PostgreSQL DB that should be fixed in terms of performance, security

https://www.drupal.org/node/2564307


2.In the below link, we see that Drupal 8 listed with Apigee Edge On Premise (or Private Cloud is also same as On premise) does not lists PostgresSQL under “# Install database


https://www.drupal.org/docs/8/modules/apigee-developer-portal-kickstart/use-kickstart-with-apigee-ed...


3. Lists MYSQL 5.5.3 as one of recommended DB


https://www.drupal.org/docs/8/system-requirements/database-server

Overall the above link hints about having issues with PostgrSQL with Drupal 8 .

We are trying to evaluate the DB for Drupal 8 (On premise) with Apigee 4.19.06 (On premise)

Would like to know, your experience with PostgreSQL or better to go with MYSQL/MariaDB for Drupal8 Portal

Based on above usage of PostgreSQL is discouraged with Drupal 8, any one had experienced similar judgment or experienced same ? please comment.

0 8 1,386
8 REPLIES 8

The reason we put MySQL in the Kickstart is because of the Remaining Drupal 8 PostgreSQL issues issue on Drupal.org. We do have automated tests running for Apigee Edge Drupal module, but you could still run into issues if you use contributed modules that are not yet ready for PostgreSQL.

That said, we would like to spend more time ensuring that you can use PostgreSQL since that database is installed by Edge private cloud installations, and it would be easier to maintain one type of database versus two different kinds.

You would be safer with MySQL, but if you could test out PostgreSQL with your install and make sure it works, with the fallback of migrating to MySQL if you ever run into issues installing a module or configuration that causes issues.

hi Chris,

Apigee Kickstart uses MariaDB, either MariaDB runs on active-passive (master, slave strategy)?Is there any proper guide of Apigee kickstart at apigee docs or the proper guide of apigee docs to move PostgreSQL to MariaDB and MYSQL?

This script should work, or try using the Drupal Migrate module.

Hi Chris,

Does Apigee Drupal 8 Dev Portal support AWS managed service for MySQL or MySQL needs to be installed on EC2 instance?

Many Thanks,

Jinesh Thakkar

It looks like AWS RDS uses standard MySQL versions, so you should not run into any issues using it instead of installing yourself: https://aws.amazon.com/rds/mysql/

Thx, appreciate it!

five nights at freddy's

Thank you Chris. Appreciate it

We use Drupal 8 with Postgres(standard ones) and it works fine.