m-thirumal/installation_guide

PostgreSQL, PgModeler, TLS, Docker, Let's Encrypt, Nginx, Pgadmin4, Redis, AWS

Installation Guide

Visit https://m-thirumal.github.io/installation_guide/ for HTML view

Build PgModeler from source code

1. Guide for Ubuntu
2. Guide for Mac

Install PostgreSQL

• Install PostgreSQL

• UnInstall

• WAL Archive & PITR

Cassandra

1. Cassandra Installation

Janus Graph database

1. Install and configuration of database
2. Gremlin Console
3. Management API
4. Indexing
5. Drop Graph/database

Install PgAdmin4

1. PgAdmin using Apache2
2. PgAdmin4 using Docker
3. Update PgAdmin4 docker image

Open Project

1. Installation and configuration

VMware ESXi

1. Start VM's automatically during the boot

Docker

1. Installation
2. Commands
3. Build Image
4. Context
5. Persistent Data & Volume
6. Docker UI
7. Network
8. Docker Spring Boot

FortiClient VPN

1. Install Forticlient VPN on Ubuntu 20.04
2. IPsec VPN in Ubuntu

Fortigate

1. IPsec Setup for Linux/Ubuntu
2. Network Load balancing

Java

1.Installation

Python

1.Installation 2.Installation

Jenkins

1. Install Jenkin
2. Intall jenkin on docker
3. Troubleshoot

Redis

• Install

  • Install from Source on ubuntu - Shell file
  • Install from source on Mac
  • Docker docker pull redis

• Redis Clients

• Enable Remote Access

• Troubleshoot

• Uninstall

• Redis Server shell file

AWS - Website hosting

1. Host static website using S3
2. Add TLS for AWS S3 hosted static website using Let's Encrypt
3. S3
   1. Commands
   2. Set up Local Programmatic user in Ubuntu/Mac Os
   3. Cross Account S3 bucket object Copy

TLS

1. Generate Free TLS/SSL using Let's Encrypt

Nginx

1. Install & Virtual host Niginx
2. Reverse Proxy using symblink
3. Add TLS For Nginx Hosted Site
4. Redirect IP address access to domain name

Git

1. SSH Clone

12 Factor App

PgModeler Output

PgAdmin4 Output

Nginx output

Spring boot

1. Create JAR

Forticlient

Maven

1. Upgrade Maven

Wordpress

• Installation
• Export/Import
• Troubleshoot

installation_guide's Issues

"deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" does not work with PostgreSQL13

When trying to install postgreSQL 13 on Linux Mint 19.3:
VERSION_CODENAME=tricia
UBUNTU_CODENAME=bionic

This code:

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ lsb_release -cs-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

Generates this line in the file pgdg.list

deb http://apt.postgresql.org/pub/repos/apt tricia-pgdg main

Attempting to install, I get this error:

sudo apt install postgresql-13 postgresql-contrib-13
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package postgresql-13
E: Unable to locate package postgresql-contrib-13

Using the UBUNTU_CODENAME, instead of the VERSION_CODENAME works. Therefor the code above likely needs to be something like this:

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

Optionally, you could edit the pgdg.list file and add the appropriate UBUNTU_CODENAME value.

Dave Keeshin