Skip to content

Instantly share code, notes, and snippets.

View imcookie's full-sized avatar

Nikita imcookie

2 followers · 2 following
View GitHub Profile
@imcookie
imcookie / docker-postgres-playground.yml
Last active November 9, 2018 21:02
docker-postgres-playground
version: "3"
services:
pghero:
environment:
- 'DATABASE_URL=postgres://postgres:pgpasswd@postgres:5432/demo'
ports:
- '8080:8080'
image: ankane/pghero
depends_on:
- postgres
@imcookie
imcookie / molecule-install.sh
Created February 11, 2019 22:53
!#/usr/bin/env python
sudo apt-get install virtualenv
virtualenv --no-site-packages .venv
source .venv/bin/activate
pip install molecule ansible docker-py
molecule init role -r role-name -d docker
@imcookie
imcookie / docker-install.sh
Last active February 1, 2020 15:55
#!/usr/bin/env bash
sudo add-apt-repository "deb [arch=amd64] https://download.docker.com/linux/ubuntu $(lsb_release -cs) stable"
sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 7EA0A9C3F273FCD8
sudo apt update
sudo apt-get install docker-ce docker-ce-cli containerd.io -y
sudo usermod -aG docker $USER
sudo pkill -u $USER #logout
@imcookie
imcookie / pagefiledelete
Created March 1, 2019 14:22
Swap file management must be set to manual first:
wmic.exe computersystem where name="ComputerName " set AutomaticManagedPagefile=False [Enter]
Then, we delete the swap file:
wmic.exe pagefileset where name="c:\\pagefile.sys" delete [Enter]
NOTE: Case sensitive AND the double backslashes are required.
@imcookie
imcookie / regex.zabbix
Created March 5, 2019 14:13
(LightWeight|ISATAP|WAN Miniport|Microsoft Kernel Debug|Teredo|Connection-QoS|Pseudo-Interface|Packet Scheduler|RAS Async Adapter)
@imcookie
imcookie / pg_show_locks.sql
Created May 2, 2019 20:53
В PostgreSQL версий ниже 9.6 нет функции pg_blocking_pids, но блокирующий процесс можно вычислить, используя запросы к таблице блокировок. Запрос покажет две строки: одна транзакция получила блокировку (granted), другая - нет и ожидает.
SELECT locktype, transactionid, pid, mode, granted
FROM pg_locks
WHERE transactionid IN (
SELECT transactionid FROM pg_locks WHERE pid = :blocked_pid AND NOT granted
@imcookie
imcookie / ansible_local_playbooks.md
Last active June 16, 2019 13:34 — forked from alces/ansible_local_playbooks.md
How to run an Ansible playbook locally
  • using Ansible command line:
ansible-playbook --connection=local --inventory 127.0.0.1, playbook.yml
  • using inventory:
127.0.0.1 ansible_connection=local
@imcookie
imcookie / win_hosts.cfg
Created November 4, 2019 14:10
[win]
win-web1.localdomain
[win:vars]
ansible_user = Administrator
ansible_password = password
ansible_connection = winrm
ansible_winrm_transport = basic
ansible_winrm_server_cert_validation = ignore
@imcookie
imcookie / wal-e.md
Created August 22, 2020 22:37 — forked from ruckus/gist:2293434
Basic setup of WAL-E for continuous archiving and recovery

WAL-E needs to be installed on all machines, masters and slaves.

How to install WAL-E

Only one machine, the master, writes WAL segments via continuous archiving. The configuration for the master postgresql.conf is:

archive_mode = on
archive_command = 'envdir /etc/wal-e.d/env wal-e wal-push %p'
archive_timeout = 60
@imcookie
imcookie / docker-install-proxy.sh
Last active September 3, 2020 19:02
# set -e errexit When set, the shell exits when a simple command in a command list exits non-zero (FALSE). This is not done in situations, where the exit code is already checked (if, while, until,||, &&)
# set -x xtrace Режим отладки. Перед выполнением команды печатает её со всеми уже развернутыми подстановками и вычислениями.
set -ex
export HTTP_PROXY="http://"
export HTTPS_PROXY="http://"
export NO_PROXY="localhost,127.0.0.1"
curl --proxy $HTTP_PROXY -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add -
sudo add-apt-repository "deb [arch=amd64] https://download.docker.com/linux/ubuntu $(lsb_release -cs) stable"
sudo apt update
sudo apt-get install docker-ce docker-ce-cli containerd.io