Skip to content

Instantly share code, notes, and snippets.

Hari 1:

  1. Infrastructure
  2. Install and Setup PostgreSQL on All Nodes
  3. Configure Replication
  4. Configuring Primary Server
  5. Configuring Standby Server
  6. Testing Replication
  7. Installing PGPOOL2
  8. Preparing PostgreSQL for pgpool-II
@akhdaniel
akhdaniel / Install nodejs 12 with PPA.md
Last active July 20, 2021 23:03
Install nodejs 12 with PPA

Install nodejs 12

cd ~
curl -sL https://deb.nodesource.com/setup_12.x -o nodesource_setup.sh
sudo bash nodesource_setup.sh
sudo apt install nodejs

You may also need development tools to build native addons:

@akhdaniel
akhdaniel / Github CICD.md
Last active May 20, 2022 03:29
Github CI/CD Setup

Overview

How to create a pipeline which checks your app's code quality -frequently, automatically, in the cloud - using GitHub Actions. Such as to lint, test and build your app hosted on GitHub.

Objectives

  • How to make a basic deploy pipeline for your code can setup quick, easily and for free.
  • It can run in the cloud whenever someone pushes to your repo. It will warn you when something fails. So in case you forgot to run tests locally or you edited in GitHub UI, you're covered.
  • GitHub supports a pipeline service called GitHub Actions, covered in this post.
@akhdaniel
akhdaniel / Ethereum docker-compose.yaml
Last active May 25, 2021 03:51 — forked from alinetskyi/docker-compose.yaml
Ethereum node deployment file
version: '3.6'
services:
geth:
image: ethereum/client-go:stable
restart: always
command: |
--rpc
--rpcaddr=0.0.0.0
--rpcport=8545
# sebelum execute:
# useradd -g users -s `which bash` -m app
# usermod -aG sudo app
# echo "enter app password for sudo"
# passwd app
# su - app
# execute: curl https://gist.githubusercontent.com/akhdaniel/e7b989dc21907a535e11fa2f1c7bde52/raw/be000c190c779a89ee770505e3fde9aec0560ff4/install-opendax.txt | bash
echo "INSTALLING DOCKER..."
@akhdaniel
akhdaniel / Cara Live Debug Odoo Docker dengan VS Code.md
Last active April 17, 2025 04:24
Cara Live Debug Odoo Docker dengan VS Code

1 Setup Container

Install modul python debugpy di dalam container. Bisa dengan cara:

  1. rebuild image: dengan nambah entry RUN pip3 install debugpy
  2. execute di dalam contaner: pip3 install debugpy dan commit image

2 Edit odoo bin di dalam container

@akhdaniel
akhdaniel / opendax install.md
Last active February 2, 2025 16:02
opendax step by step install

1 Requiement VM

Minimum VM requirements for OpenDAX:

  • 8GB of RAM (12GB recommended)
  • 4 cores vCPU (6 cores recommended)
  • 300GB disk space (SSD recommended)
@akhdaniel
akhdaniel / Setup PGPool + PostgreSQL 12.md
Last active March 3, 2024 21:49
Setup PGPool + PostgreSQL 12

A. Infrastructure

FQDN IP Purpose 1 Purpose 2
IT-RDBMS01.itenlight.com 10.1.10.150 Primary PostgreSQL instance Active pgpool-II instance
IT-RDBMS02.itenlight.com 10.1.10.155 Standby PostgreSQL instance Standby pgpool-II instance

Virtual IP that will be used is 10.1.10.159.

@akhdaniel
akhdaniel / PostgreSQL Clustering CITUS.md
Last active December 26, 2024 14:11
PostgreSQL Clustering CITUS

Install Steps on Worker:

curl https://install.citusdata.com/community/deb.sh | sudo bash

sudo apt-get -y install postgresql-13-citus-10.0

sudo pg_conftool 13 main set shared_preload_libraries citus

Install

apt-get install postgresql postgresql-contrib

Create DB

su - postgres
psql