grammy-jiang

PostgreSQL dump and restore within Docker

Dump a database in PostgreSQL with pg_dump inside a docker container

docker run \
  -it --rm -v <volume>:/tmp/pg_dump postgres:latest \
  pg_dump \
  --host=<host> --port=<port> \
  --username=<username> --password \
 --dbname= -f /tmp/pg_dump/.sql

grammy-jiang

Update all docker images and remove dangling ones

Update all images with the 'latest' label

docker images --format "{{.Repository}}:{{.Tag}}" | grep ':latest' | xargs -L1 docker pull

Remove the dangling images

docker rmi $(docker images --quiet --filter "dangling=true")

grammy-jiang

MongoDB dump and restore within Docker

MongoDB dump

prompt the user for password

foo@bar:~$ docker run --interactive --tty --rm --network=<network> --volume=<volume>:/tmp \
  mongo:latest \
  mongodump \

grammy-jiang

1. start MSSql with docker-compose

version: "3"
services:
  mssql:
    container_name: dc-mssql
    environment:
      ACCEPT_EULA: Y
      SA_PASSWORD: P@ssw0rd

grammy-jiang

Major Tools

foo@bar:~$ sudo -- sh -c "timedatectl set-timezone Australia/Sydney && date" && \
sudo -- sh -c "apt-get update && apt-get upgrade -y && apt-get dist-upgrade -y && apt-get autoremove -y" && \
sudo -- sh -c "apt-get install -y vim-nox && wget --output-document=/etc/vim/vimrc.local https://git.io/JvpS2" && \
sudo -- sh -c "apt-get install -y curl direnv exa git lnav mosh tig tree vifm watchman" && \
sudo -- sh -c "apt-get install -y python3-pip python3-testresources python3-pywatchman"

grammy-jiang

" =============================================================================
" Github URL
" https://gist.githubusercontent.com/grammy-jiang/ae2218062be5f493e24492ad6b62b3a2/raw
" Shorten URL
" https://git.io/JvpS2
" =============================================================================

set nocompatible

" Vim5 and later versions support syntax highlighting. Uncommenting the next

grammy-jiang

# control if we start knockd at init or not
# 1 = start
# anything else = don't start
# PLEASE EDIT /etc/knockd.conf BEFORE ENABLING
START_KNOCKD=1

# command line options
KNOCKD_OPTS="--interface eth0"

grammy-jiang

[options]
    UseSyslog

[opencloseSSH]
    sequence        = 7000,8000,9000
    seq_timeout     = 5
    tcpflags        = syn
    start_command   = /usr/bin/firewall-cmd --zone=public --add-service=ssh
    cmd_timeout     = 10
    stop_command    = /usr/bin/firewall-cmd --zone=public --remove-service=ssh

grammy-jiang

<?xml version="1.0" encoding="utf-8"?>
<zone>
  <short>Public</short>
  <description>For use in public areas. You do not trust the other computers on networks to not harm your computer. Only selected incoming connections are accepted.</description>
  <interface name="eth0"/>
  <service name="dhcpv6-client"/>
  <service name="mosh"/>
</zone>

grammy-jiang

# firewalld config file

# default zone
# The default zone used if an empty zone string is used.
# Default: public
DefaultZone=public

# Minimal mark
# Marks up to this minimum are free for use for example in the direct 
# interface. If more free marks are needed, increase the minimum