Skip to content

Instantly share code, notes, and snippets.

View gerbsen's full-sized avatar

gerbsen

7 followers · 4 following
View GitHub Profile
@gerbsen
gerbsen / postgres_queries_and_commands.sql
Created February 17, 2024 10:57 — forked from rgreenjr/postgres_queries_and_commands.sql
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%'
@gerbsen
gerbsen / docker-cleanup-resources.md
Created November 22, 2017 08:55 — forked from bastman/docker-cleanup-resources.md
docker cleanup guide: containers, images, volumes, networks

Docker - How to cleanup (unused) resources

Once in a while, you may need to cleanup resources (containers, volumes, images, networks) ...

delete volumes

// 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

@gerbsen
gerbsen / lag_europa_24_06_2017.md
Last active July 19, 2017 08:50

0. Teilnehmer

Holger Haugk, Marcel Bäck, Werner Tomas, Sven Grams, Jakob Lindenthal, Marija Dragica, Gisela Kallebach, Daniel Gerber

1. Auswertung Treffen ENS

@gerbsen
gerbsen / rocket.chat.naming.md
Last active June 21, 2017 14:39

Vorschlag für Namesgebung

Generelle Regeln:

  • nur Kleinschreibung
  • Leerzeichen mit Unterstrichen oder Bindestrichen

| Channel Name | Bedeutung |

@gerbsen
gerbsen / lag_europa_treffen_25022017.md
Last active February 27, 2017 20:58

LAG Europa und Internationales 25.02.2017

Vorstellungsrunde:

  • Marcel
  • Sven Krams
  • Peter (chairmain usti region)
  • Jirji (was chairman of usti region for 4 years)
  • adam suchez (vice chairman of green party usti region)
  • Nino
@gerbsen
gerbsen / europe_end_of_solidarity.md
Last active February 12, 2017 18:21

Title of panel

  • The End of solidarity? The return of the national though in Europe.
  • Das Ende der Gemeinsamkeit? Die Rückkehr des nationalen Gedankens in Europa.

Type of discussion

  • Expert panel
  • Sunday, 12.02.2017,
  • Schauspiel Leipzig,
  • Moderation Dr. Jens Bisky, Feuilleton SZ
@gerbsen
gerbsen / prerender start script
Created October 22, 2015 08:27
cat /etc/init.d/prerender
#!/bin/bash
### BEGIN INIT INFO
# Provides: prerender
# Required-Start: networking
# Required-Stop: networking
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Short-Description: Run prerender collector as daemon
# Description: Run prerender collector as daemon
@gerbsen
gerbsen / prerender.install.log
Created October 22, 2015 08:25
/install.sh
» Prerender-daemon installer v1.1.1 by Luciano Mammino
» http://loige.com
» https://github.com/lmammino/prerender-daemon
Installing prerender-daemon
npm http GET https://registry.npmjs.org/prerender
npm http 200 https://registry.npmjs.org/prerender
npm http GET https://registry.npmjs.org/lodash
@gerbsen
gerbsen / db_to_csv.sql
Last active October 20, 2015 10:40
http://stackoverflow.com/a/20056883
# http://stackoverflow.com/a/20056883
CREATE OR REPLACE FUNCTION db_to_csv(path TEXT) RETURNS void AS $$
declare
tables RECORD;
statement TEXT;
begin
FOR tables IN
SELECT (table_schema || '.' || table_name) AS schema_table
FROM information_schema.tables t INNER JOIN information_schema.schemata s
@gerbsen
gerbsen / ssh_agent_start.fish
Last active January 26, 2024 08:13 — forked from schaary/ssh_agent_start.fish
Auto-launching ssh-agent in fish shell
# content has to be in .config/fish/config.fish
# if it does not exist, create the file
setenv SSH_ENV $HOME/.ssh/environment
function start_agent
echo "Initializing new SSH agent ..."
ssh-agent -c | sed 's/^echo/#echo/' > $SSH_ENV
echo "succeeded"
chmod 600 $SSH_ENV
. $SSH_ENV > /dev/null