On Microsoft Windows, cron jobs are known as Scheduled Tasks. They can be added through the Windows Task Scheduler user interface, by using PowerShell or…
View More How to add a cron job on Windows Scheduled tasks and cron jobs on Windows
Month: August 2023
MySQL Master/Slave Replication in Windows
This guide will walk you through creating MySQL replication on existing live MySQL servers on Windows. While some downtime is required, we try to keep…
View More MySQL Master/Slave Replication in Windows
How to install Oracle Database 19c on CentOS 8
Environment Specification: We have provisioned a minimally installed CentOS 8 virtual machine with following specifications. CPU – 3.4 Ghz (2 cores) Memory – 8 GB Storage – 80 GB Operating…
View More How to install Oracle Database 19c on CentOS 8
Oracle Memory Management
Memory management involves maintaining optimal sizes for the Oracle instance memory structures as demands on the database change. Initialization parameter settings determine how SGA and…
View More Oracle Memory Management
Oracle RMAN vs Export?
RMAN and export both backup tables, and they both support flashback database, but there are some important differences: Data Pump Export (expdp)Β – The export utility…
View More Oracle RMAN vs Export?
PostgreSQL Backup Strategies for Enterprise-Grade Environments
Understanding the PostgreSQL Backup Process There are three different PostgreSQL backup methods, including SQL dump, which generates a file with SQL commands that recreates the…
View More PostgreSQL Backup Strategies for Enterprise-Grade Environments
How to Recover Postgres from Out of Disk Status
The ultimate goal for any unplanned database interruption is to reduce data loss. Backups: The Most Important Thing The most important thing that you can…
View More How to Recover Postgres from Out of Disk Status
Upgrade Amazon RDS to major and minor versions of PostgreSQL
Open-source PostgreSQL occasionally releases new minor and major versions that include fixes for frequently encountered bugs, security issues, and data corruption problems. Generally, Amazon RDS aims to support new…
View More Upgrade Amazon RDS to major and minor versions of PostgreSQL
Asynchronous IO for file System using FILESYSTEMIO_OPTIONS
We noticed that on one of our servers oracle trc files accumulated too much. it started piling up after we increased /dev/shm and sga. In trace…
View More Asynchronous IO for file System using FILESYSTEMIO_OPTIONS
Scheduling maintenance with the PostgreSQL pg_cron extension
You can use the PostgreSQL pg_cron extension to schedule maintenance commands within a PostgreSQL database. For more information about the extension, see What is pg_cron? in the pg_cron documentation.…
View More Scheduling maintenance with the PostgreSQL pg_cron extension