In a previous article we saw how to take full and log (WAL) backups without using 3rd party tools. In this article we will now see how we can restore the database with Point in Time Restore (PITR). The… read more
How to Backup a PostgreSQL Database Without Using 3rd Party Tools
In this article we will see step by step how to do a backup without using 3rd party tools full backup and log backup so that we can do PITR (Point in Time Recovery) if needed in the future. Finally we will see… read more
How memory works in PostgreSQL and what parameters do we configure?
In a previous article we have analyzed the architecture of Oracle Database (SGA/PGA). This time we will look at the memory architecture of PostgreSQL and the key parameters for optimal performance. The memory model of PostgreSQL differs significantly from that of… read more
What are WALs in PostgreSQL and how do we configure them?
In this article we will look at the mechanism that connects memory to disk and ensures that we will not lose data if the database goes down (e.g. due to power failure): Write-Ahead Logs (WAL) and Checkpoints. When we execute… read more
What is MVCC and Vacuum in PostgreSQL database and how do we avoid Bloat?
In this article we will see how PostgreSQL manages concurrent access through MVCC, what Bloat is, what Data Churn is, what Vacuum is, and how to properly configure it with Autovacuum. What is… read more
How to send email from Oracle Database when an RDBMS_SCHEDULER Job fails
In this article we will see how we can install an email alert mechanism so that when a Job fails, the Oracle database sends us an email directly via SMTP Relay server. But we will also see in general how we can… read more
How to transfer CLOB text fields from Oracle Database to SQL Server without problems
If at some point we transfer many records with CLOB (large text) fields from Oracle Database to SQL Server with a database link that uses an odbc driver, there is a high probability that we will transfer the data incorrectly. More specifically, we will… read more
How to restore an Oracle Database that is in archive-log mode with RMAN Restore
In a previous article we saw how to backup an Oracle database with RMAN, in this article we will see a simple case of recovering data with RMAN Restore. There are many subcases with different steps each… read more
How can we connect SQL Server to another SQL Server using Linked Server?
SQL Server allows us to connect to and execute queries on remote Database Instances that do not necessarily have to be in the same RDBMS. In this article we will see specifically how it is done from an instance of SQL… read more
