PostgreSQL Upgrade from version 9.5 to version 12
In this article, we are going to learn how to upgrade PostgreSQL from version 9.6 to version 12. Enhancements to administrative functionality in version 12, including: REINDEX CONCURRENTLY can rebuild an index without blocking writes to its table pg_checksums can enable/disable page checksums (used for …
Passwordless authentication using MySQL Config Editor and Multi Host SQL Backups
In this article, we are going to learn how to setup passwordless authentication for multiple MySQL servers for example MySQL Hosted on Premise Cloud Database services like AWS and others On Self Managed Server (Dedicated, VMs or Cloud Servers) About MySQL Configuration Utility The mysql_config_editor …