About the virtual machines and network details, see this blog post
Run on both servers:
yum install postgresql95-server postgresql95-contrib pgpool-II-95
sebastianwebber
/ pg-notify-parallel.go
Last active
March 11, 2024 15:45
postgres listen/notifiy with golang and `go-pg`
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package main | |
| import ( | |
| "log" | |
| "time" | |
| "github.com/go-pg/pg" | |
| ) | |
| const maxWorkers = 5 |
sebastianwebber
/ README.md
Last active
February 28, 2024 20:03
PGPool II and PostgreSQL 9.5 on Centos 7
sebastianwebber
/ README.md
Last active
February 19, 2024 11:44
Compilation of the Uber Facts on PostgreSQL to MySQL Migration
- ~50GB MySQL Application
- Main motivation: PostGis
- Migration made with a custom tool(xml2pgcopy) and mysqldump on 45min
. /etc/os-release
sudo sh -c "echo 'deb http://download.opensuse.org/repositories/devel:/kubic:/libcontainers:/stable/xUbuntu_${VERSION_ID}/ /' > /etc/apt/sources.list.d/devel:kubic:libcontainers:stable.list"
wget -nv https://download.opensuse.org/repositories/devel:kubic:libcontainers:stable/xUbuntu_${VERSION_ID}/Release.key -O Release.key
sudo apt-key add - < Release.key
sudo apt-get update -qq
sudo apt-get -qq -y install buildah
``
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- tested in PostgreSQL 8.4.4 | |
| DROP VIEW IF EXISTS vw_all_table_locks CASCADE; | |
| CREATE VIEW vw_all_table_locks AS | |
| SELECT | |
| pg_namespace.nspname as schemaname, | |
| pg_class.relname as tablename, | |
| pg_locks.mode as lock_type, | |
| age(now(),pg_stat_activity.query_start) AS time_running | |
| FROM pg_class | |
| JOIN pg_locks on pg_locks.relation = pg_class.oid |
sebastianwebber
/ benchmarks.sh
Last active
March 17, 2023 14:33
Run benchmarks on postgres with pgbench
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash -ex | |
| export PGBIN=/usr/pgsql-9.3/bin | |
| export PGUSER=postgres | |
| export PGDATABASE=bench | |
| export DATADIR=/dados/pgbench | |
| export CLUSTER_LOG=/tmp/benchmark.log | |
| export TOTAL_CPUS=$(grep 'cpu cores' /proc/cpuinfo | uniq | awk '{print $NF}') |
sebastianwebber
/ README.md
Last active
July 14, 2022 04:20
enable arm support for docker in fedora 36 on x86_64 machines
From: https://www.stereolabs.com/docs/docker/building-arm-container-on-x86/
-
Install the necessary packages:
sudo dnf install qemu qemu-user-binfmt qemu-user-static
-
Run qemu setup:
sebastianwebber
/ create-ec2-instance-playbook.yml
Last active
May 13, 2022 11:37
Create a EC2 instance with ansible-playbook
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --- | |
| - hosts: localhost | |
| connection: local | |
| vars: | |
| gather_facts: False | |
| vars: | |
| keypair: "my-keypair-name" | |
| instance_type: m4.large | |
| security_group: | |
| - "vpc-group-1" |
sebastianwebber
/ docker-compose.yml
Last active
October 10, 2021 11:49
basic docker-compose for grafana and prometheus
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| version: '3.1' | |
| volumes: | |
| prometheus_data: {} | |
| grafana_data: {} | |
| services: | |
| prometheus: | |
| image: prom/prometheus | |
| volumes: |
NewerOlder