Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

View sebastianwebber's full-sized avatar
🏠
Working from home

Sebastian Webber sebastianwebber

🏠
Working from home
82 followers · 15 following
View GitHub Profile
@sebastianwebber
sebastianwebber / pgsql-ssl.md
Last active June 24, 2021 14:38
Habilitar SSL no PostgreSQL

Habilitar SSL no PostgreSQL

Execute os procedimentos abaixo para habilitar SSL no seu servidor PostgreSQL.

  1. Crie um diretório para armazenar as configurações (opcional)
mkdir certificados
cd certificados
@sebastianwebber
sebastianwebber / pg_cleanup_oldmorethan_30days.sh
Created August 5, 2016 02:16
#!/bin/bash
ARCHIVEDIR='/var/lib/pgsql/wal_archive'
LAST_BACKUP=$(ls -lto ${ARCHIVEDIR})
FILE_LIST=$(pg_archivecleanup -n "${ARCHIVEDIR}" "${LAST_BACKUP}")
## TEST FIRST
pg_archivecleanup -n "${ARCHIVEDIR}" "${LAST_BACKUP}" | find -type f -mmin +30 | xargs ls -lh
@sebastianwebber
sebastianwebber / keybase.md
Created May 12, 2020 15:41
keybase proof

Keybase proof

I hereby claim:

  • I am sebastianwebber on github.
  • I am sebawebber (https://keybase.io/sebawebber) on keybase.
  • I have a public key ASAVnC1vicYp9QJrHT8KelRyeM740ej76ZUqnzdOXWYJmgo

To claim this, I am signing this object:

@sebastianwebber
sebastianwebber / generate_series.sql
Last active July 28, 2019 00:12
SQL Server generate_series
-- http://blog.jooq.org/2013/11/19/how-to-create-a-range-from-1-to-10-in-sql/
IF EXISTS (SELECT *
FROM dbo.sysobjects
WHERE id = object_id (N'[dbo].[generate_series]')
AND OBJECTPROPERTY(id, N'IsTableFunction') = 1)
DROP FUNCTION [dbo].[generate_series]
GO
CREATE FUNCTION [dbo].[generate_series] ( @p_start INT, @p_end INT)
@sebastianwebber
sebastianwebber / crontab_contents.sh
Created July 15, 2019 17:32
list crontabs from all gcp servers
#!/bin/bash
server_list=$(gcloud compute instances list --format='get(networkInterfaces[0].networkIP)' --filter="status=running")
for server in ${server_list[@]}; do
echo "server: $server"
ssh $server 'sudo cat /var/spool/cron/* /etc/crontab'
echo "-----------"
done
@sebastianwebber
sebastianwebber / README.md
Last active April 6, 2019 01:30
Zabbix 3 Install on CEntOS 7 with PostgreSQL 9.5

Zabbix 3 Install on CEntOS 7 with PostgreSQL 9.5

Repo installation

Zabbix repo

yum install http://repo.zabbix.com/zabbix/3.0/rhel/7/x86_64/zabbix-release-3.0-1.el7.noarch.rpm
@sebastianwebber
sebastianwebber / find-history.sh
Created February 28, 2019 02:24
find YOUR git history amoung lots of git repositories
## include on your .zshrc (or similar)
#### tested on OSX
function findGitHistory() {
targetDir="${1}"
targetMonth="${2}"
targetYear="${3}"
targetUser=$(git config --get user.name)
@sebastianwebber
sebastianwebber / README.md
Last active February 19, 2019 02:36
go animal race

Race

small experiment on our go meetup.

tty-min

@sebastianwebber
sebastianwebber / ftpd.mtail
Last active January 4, 2019 20:48
mtail prog to parse vsftpd logs in xferlog format
hidden text FILENAME
counter log_ftp_files_processed_count by username, remote_host, transfer_type, direction
counter log_ftp_files_deleted_count by username, remote_host, transfer_type
counter log_ftp_files_incomplete_transfers_count by username, remote_host, transfer_type
FILENAME = getfilename()
## example file
### Fri Jan 4 12:55:27 2019 1 1.2.3.4 224 /path/to/file.CSV b _ o r user_name ftp 0 * c
@sebastianwebber
sebastianwebber / main.go
Created November 7, 2018 16:36
exemplo interface e testes #golang
package main
import (
"fmt"
)
type contrato interface {
Insert() string
}