PostgreSQL Interview Q&A Part-2 Before going into the article, please check our previous article on PostgreSQL Q&A Part-1 1. What are template0 & template1 databases? As the name suggests, these are template databases that come by default with the Installation. In a fresh installation, both… Read More
WAL Internals in PostgreSQL Write-Ahead Log (WAL) is a very important term in transaction processing. In PostgreSQL, it is also known as a transaction log. A log is a record of all the events or changes and WAL data is just a description of changes… Read More
Data Fragmentation in PostgreSQL PostgreSQL is a relational database management system with a client-server architecture. At the server-side, PostgreSQL’s processes and shared memory work together and build an instance, which handles the access to the data. Client programs connect to the instance and request read… Read More
Replication to GCP PostgreSQL Using Oracle GoldenGate Use Case: Real-time replication of transactional data from an on-premises database to GCP Managed PostgreSQL instance using GoldenGate. Architecture: Source Database (Source Database can be any GoldenGate supported databases) Oracle GoldenGate (OGG) 19c/18c/12c for extraction from Source DB… Read More
How to Download and Install the pgAdmin 4 In this article , we will see download and installation of pgAdmin4. STEP 1 : Download the pgAdmin 4 by using the below link. https://www.pgadmin.org/ Choose the Download Button. Choose the windows option. Select the option which… Read More
Installation of PostgreSQL 11.4 On Windows Platform In this article , we will see how to download and install PostgreSQL 11.4 on Windows platform. STEP 1 : As a first step we need to download the PostgreSQL by using the below link. https://www.postgresql.org/ Click on… Read More
