Tips and tricks on backing up and restoring your Evergreen Database.
Backup to directory format dump. This allows the dump to be done in parrallel for speed, and automatically compresses the output. The downside is that it may not be possible to restore to a different version of postgresql. If you need to move from one version of postgres to another, don’t use the directory format. pg_dump -U evergreen -j 4 -F d -f $BACKUPDIR/$DBNAME-$CURTIME $DBNAME
Restore into a new database
| #!/bin/bash | |
| # File : Compile-postgreSQL-10.5-Ubuntu-16.04.LTS.sh | |
| # OS : Ubuntu 16.04.5 LTS | |
| # LastUpdate : 11:55 2019.05.13 | |
| # Description : Compile PostgreSQL 10.5 on Ubuntu-16.04 | |
| ########################################### | |
| export LC_CTYPE=en_US.UTF-8 | |
| export LC_ALL=en_US.UTF-8 |
| #!/bin/bash | |
| # File : compile-mariadb-10.3.sh | |
| # OS : Ubuntu 16.04.6 LTS | |
| # LastUpdate : 16:55 2019.10.08 | |
| # Description : Compile MariaDB Server StandAlone / MariaDB Galera Cluster 10.3 | |
| ########################################### | |
| MARIADB_VERSION=10.3.18 | |
| MARIADB_HOME=/mariadb |
| #!/bin/bash | |
| # File : compile-postgreSQL-11.5-Ubuntu-16.04.LTS.sh | |
| # OS : Ubuntu 16.04.6 LTS | |
| # LastUpdate : 10:06 2019.10.07 | |
| # Description : Compile PostgreSQL 11.5 on Ubuntu | |
| ########################################### | |
| ##POSTGRESQL : /postgres/pgscript/postgres-stop.sh | /postgres/pgscript/postgres-restart.sh <<<<<RESTART>>>>> | |
| # | CONFIG FILE : /postgres/pgdata/{postgresql.conf,pg_hba.conf} | |
| # | CONNECT DBA : /postgres/pgscript/postgres-connect-dba.sh |
| #!/bin/bash | |
| # File : compile-python-3.6.5.sh | |
| # OS : Redhat/Debian | |
| # LastUpdate : 14:38 2019.11.04 | |
| # Description : Compile python-3.6.5 | |
| ########################################### | |
| # Determine OS platform | |
| echo -e "\n########## Determine OS platform ##########" | |
| if [ -f /etc/redhat-release ]; then | |
| # For yum-based systems (like CentOS) |
Once in a while, you may need to cleanup resources (containers, volumes, images, networks) ...
// see: https://github.com/chadoe/docker-cleanup-volumes
$ docker volume rm $(docker volume ls -qf dangling=true)
$ docker volume ls -qf dangling=true | xargs -r docker volume rm
Download as zip https://www.raspberrypi.org/downloads/raspbian/ and extract it
Download and install Etcher https://www.balena.io/etcher/
Plug the SD card in the computer, run Etcher and flash the .img on the SD card, remove the SD card, plug it into the RPi, boot
| acl httponly_cookie res.hdr(Set-Cookie),lower -m sub httponly | |
| rspirep ^(set-cookie:.*) \1;\ HttpOnly if !httponly_cookie |
| # | |
| # Name: nginx-tls.conf | |
| # Auth: Gavin Lloyd <[email protected]> | |
| # Desc: Nginx SSL/TLS configuration for "A+" Qualys SSL Labs rating | |
| # | |
| # Enables HTTP/2, PFS, HSTS and OCSP stapling. Configuration options not related | |
| # to SSL/TLS are not included here. | |
| # | |
| # Additional tips: | |
| # |
