Skip to content

Instantly share code, notes, and snippets.

View sharms's full-sized avatar

Steve Harms sharms

View GitHub Profile
@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active November 14, 2024 09:13
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
@mcritchlow
mcritchlow / install.md
Last active February 18, 2023 08:45
Installing Zoom on Solus OS
@OdinsPlasmaRifle
OdinsPlasmaRifle / arch_linux_installation.md
Last active September 27, 2024 16:46
LVM on LUKS Arch installation with systemd-boot
@styblope
styblope / docker-api-port.md
Last active November 15, 2024 23:06
Enable TCP port 2375 for external connection to Docker

Enable TCP port 2375 for external connection to Docker

See this issue.
Docker best practise to Control and configure Docker with systemd.

  1. Create daemon.json file in /etc/docker:

     {"hosts": ["tcp://0.0.0.0:2375", "unix:///var/run/docker.sock"]}
    
#!/bin/bash
set -e
BOSH_DEPLOYMENT_PATH="../../bosh-deployment"
# clean up
(cd "$BOSH_DEPLOYMENT_PATH" && git pull)
rm -rf state.json
for uuid in $(VBoxManage list vms|grep -E ^\"sc- | awk '{print $2}' | sed 's/{//' | sed 's/}//'); do
@ibihim
ibihim / arch_install.sh
Last active March 26, 2023 16:27
Arch install in progress
# Installation on Lenovo X1 5th Generation
# Installation guide: https://wiki.archlinux.org/index.php/Installation_Guide
# Encryption: https://wiki.archlinux.org/index.php/Dm-crypt/Device_encryption#Cryptsetup_usage
# LVM: https://wiki.archlinux.org/index.php/LVM
# Set large font, if necessary
setfont latarcyrheb-sun32
# Connect to Internet
@kynrai
kynrai / Arch-i3.md
Last active September 25, 2021 12:59
Custom Arch i3-gaps setup on RBS 2019

Arch (i3-gaps) on Rzer Blade 13 2019 MX 150

Prerequisites

  • Disbale secure boot (F12/Del on boot, BIOS)
  • Create UEFI boot disk

Boot from USB

  1. Set UK layout loadkeys uk
@PillTime
PillTime / archlinux.md
Last active November 6, 2024 15:47
Installing Arch Linux
I might make a big revision someday to review everything, fix anything that needs fixing, and explain the reason for each step. Maybe.

Installing Arch Linux

Small notes before we start:

  • Some computers won't work out of the box because of bugs left by the manufacturers.
Example My laptop spams tty1 with the following errors when the network card starts being used:
@fjpalacios
fjpalacios / arch-i3gaps-install.md
Last active October 27, 2024 22:41
Arch + i3-gaps Install Guide

Arch + i3-gaps Install Guide

First set up your keyboard layout. For example, in Spanish:

   # loadkeys es

For a list of all acceptable keymaps:

   # localectl list-keymaps