Dmitry RomanoffPostgreSQL. “Fatal error: failed to delete Postgres user.”You are trying to delete a PostgreSQL database user and encounter the following error:Jul 19Jul 19
Dmitry RomanoffPostgres. How to move old historical records from your main table to a separate table?I often encounter databases containing tables with old historical data. Such tables become heavy, occupy a lot of disk space, their indexes…Jul 18Jul 18
Dmitry RomanoffProactive PostgreSQL Database(s) Performance ScannerA critical situation in the system. CPU has reached one hundred percent. There is an urgent need to find a solution.Jul 13Jul 13
Dmitry RomanoffAWS Aurora Global DatabaseAurora Global Database is an option supported on AWS Aurora MySQL and PostgreSQL engines enabling two primary use cases.Jul 13Jul 13
Dmitry RomanoffOptimizing MySQL Database Performance: Identifying and Managing Long QueriesOptimizing MySQL Database Performance: Identifying and Managing Long QueriesMay 17May 17
Dmitry RomanoffPython. Flipping Calendars.In the modern digital era, calendars have become indispensable tools that help us organize our lives, manage time, and stay abreast of…May 17May 17
Dmitry RomanoffinDevOps.devPython. Exploring MySQL Table Sizes.This Python code is useful for monitoring the sizes of tables in a MySQL database. It connects to the database and prints out the tables…May 161May 161
Dmitry RomanoffPython. Automating creation backups of MySQL database.This script automates creating backups of MySQL databases, restoring them, and managing database and user creation on the destination MySQL…May 13May 13
Dmitry RomanoffPython code that inserts a large number of records into a MySQL table.This Python code creates a MySQL table named my_table with columns name, age, and city.May 13May 13
Dmitry RomanoffPython code that simulates talk between frogs using threads.We can use Python’s threading module to simulate the conversation between frogs using threads.May 13May 13