mubbashir10

PostgreSQL 13 Master-Standby Streaming Replication

PostgreSQL has various types of replication available and it could be a little bit confusing to figure out what has to be done to just configure a simple master-standby replicated database setup. Digging my way through documentation I decided to write my own little guide on how to setup simple replication in PostgreSQL 13.

How it works

Streaming replication works by streaming the contents of WAL (Write-Ahead Logging) file from one server to another. Each transaction is first written into the WAL file, so essentially every change on the primary server will be replicated on the standby server. Standby server could be used for read-only operations, but can't be written to. Ofcourse, transferring data over the network takes time and there is a small lag before data written to one server becomes available on the other. To guarrantee data consistency on both servers at the time of read operation we can enable synchronous replication mode. This way, datab

mubbashir10

const fetch = require('node-fetch')

// this should be your webhook URL (doc: https://api.slack.com/messaging/webhooks)
const integrationURL = ''

exports.handler = async (event) => {

  const message = event.Records[0].Sns.Message

  return await fetch(integrationURL, {

mubbashir10

export default [
  {
    "utc": "(UTC) Casablanca",
    "description": "Morocco Standard Time",
    "abbreviation": "MST"
  },

  {
    "utc": "(UTC) Coordinated Universal Time",
    "description": "Coordinated Universal Time",

mubbashir10

/*
To run this program you need jSoup in your classpath.
Author: Mubbashir10
URL: http://mubbashir10.com
*/

import java.util.*;
import java.io.IOException;
import org.jsoup.Jsoup;
import org.jsoup.nodes.Document;

mubbashir10

/*
About: A simple tutorial showing JDBC connection (to MYSQL Database)
Author: Mubbahsir10
URL: http://mubbashir10.com
*/

//packages/libraries
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;

mubbashir10

/*
About: A simple tutorial of maps (c++ STL)
Author: Mubbashir10
URL: http://mubbashir10.com
*/

//libraries
#include <iostream>
#include <string>
#include <map>

mubbashir10

/*
About: A simple tutorial of using vectors (c++ STL)
Author: Mubbashir10
URL: http://mubbashir10.com
*/

//libraries
#include <iostream>
#include <vector>

mubbashir10

#importing libraries
import os
import shutil

#define source dir
src_dir = "temp/"

#define destination dir
des_dir = "temp2"