Database Administration & Monitoring, PostgreSQL Updating Password in PostgreSQL from md5 to scram-sha-256 31.01.2022 by Open source Team Many installations have a history of many major PostgreSQL releases. With PostgreSQL 10 comes scram-sha-256 for hashing passwords, by installing from packages scram-sha-256 is the default setting for new installations since PostgreSQL 13. With this small blog I will(…)
Cloud, Database Administration & Monitoring, MariaDB, MySQL, Oracle What I really like about Percona PMM 14.01.2022 by Elisa Usai Percona Monitoring and Management tool (PMM) is an Open Source product which was developed to help DBAs and developers to monitor and manage MySQL, PostgreSQL and MongoDB performances. In this blog post, we will see that we(…)
Database management, Development & Performance, PostgreSQL PostgreSQL Flexible Server on Azure, Status 10.01.2022 by Open source Team This Blog is about the actual status of the development on Microsoft’s side for the Azure Flexible Server for PostgreSQL. The Flexible Server is announced “GA Ready” at November 30st, after shiftig the GA Raeady date several times. But(…)
Cloud, Database Administration & Monitoring, PostgreSQL PostgreSQL Flexible Server on Azure, scram-sha-256 workaround 03.11.2021 by Open source Team Microsofts old Single Server for PostgreSQL on Azure offers password encryption md5 only, normaly IT Governance responsible people getting nervous by that. On the new Flexible Server for PostgreSQL on AZure md5 is still the default setting, but a(…)
AWS, Database Administration & Monitoring, Kubernetes, NoSQL, Oracle See you on Polywork (an new LinkedIn?) 21.06.2021 by Open source Team By Franck Pachot . I have published 105 additional blog posts here since the 500th one https://www.dbi-services.com/blog/rollback-to-savepoint/ that I have written on my come back to dbi-services. On Oracle Database, of course, other databases as well,(…)
Oracle, PostgreSQL PostgreSQL on Oracle free tier ARM 25.05.2021 by Oracle Team By Franck Pachot . This follows the previous post about the Oracle Cloud ARM compute shape just announced on May 25th. The processor is ARM v8.2 with LSE (atomic instructions) and PostgreSQL can benefit from it (see(…)
AWS, PostgreSQL PostgreSQL on AWS Graviton2: CFLAGS 17.05.2021 by Open source Team By Franck Pachot . In a previous post I’ve compiled PostgreSQL with GCC 7 and GCC 11 with the default options and checked that the ARM v8.2 features were used. However it may not be so simple:(…)
PostgreSQL Delphix and upgrading the clones (Oracle) 05.05.2021 by Oracle Team By Franck Pachot . Delphix is a tool for easy cloning of databases. The idea is that all is automated: the user can create a clone, rewind or refresh it with one click. However, I was suprised that the(…)
PostgreSQL Pass a variable to a trigger in PostgreSQL 22.04.2021 by Open source Team By Franck Pachot . With Oracle there are many ways to set a state in the session: context variables, set with DBMS_SESSION.SET_CONTEXT and retrieved with SYS_CONTEXT, or package global variables, or global or private temporary tables with ON COMMIT(…)
Kubernetes, PostgreSQL K8s on Windows/VirtualBox 12.04.2021 by Open source Team By Franck Pachot . This is a little demo, easy to copy-paste, if you want to play with Kubernetes on your laptop. And, not a simple “Hello World” but a real database running here, able to scale up and(…)