Nrz's blog
en
fr
Devops
Harbor multi datacenter with replicated artifacts
Homes
Home assistant on NixOS with docker and Bluetooth
Ansible
Apache
BSD
Compile rust programs on FreeBSD with Bastille
Use ansible on remote FreeBSD jails
Let's Encrypt with an Nginx jail
Samba4 with ZFS
OpenBSD 5.5
OpenBSD 5.4
Home hostap
CARP, Pfsync, GRE, IPSEC
Captive portal
Interface management
OpenOSPF patch
Apache FreeBSD DragonFlyBSD cluster
OpenBSD 5.3
How to install OpenBSD
Migrate from 5.1 to 5.2
OpenBSD 5.2
Ports troubleshoot (tar)
OpenBSD 5.1
Contribute to ports
How to install DragonFlyBSD
OpenOSPFD patch (2)
Introduction
Compile a module
Compile the kernel
Dports management
Cloud
Scaleway
Elasticsearch
Git
Edit an old commit
Edit the first commit
Extract a subfolder as a new repository
Remove a submodule
Import a file from another branch
Change the default branch
Create an empty branch
Remove a file from Git without removing it from the disk
Gitlab
Remove old Gitlab CI job logs
Gnome
Java
Kubernetes
Accéder à un endpoint sans ressources protégé par RBAC
Find all volumes used by all Kubernetes pods
Trigger Kubernetes cronjob manually
Linux
Misc
Mattermost - cleanup old posts
Monitoring
Prometheus alert on node reboot
Find prometheus metrics without a specific label
Alertmanager - Discard a notification
OpenBGPd sensor
MySQL
Network
IPv4 vs IPv6 on old Cisco
News
Nix
Nix Store: Recover from corrupted file situation
OpenLDAP
Log cleanup
BDB version migration
OpenLDAP
Orchestrator
Puppet
Postfix
Native SPF check
Remove specific mails from the queue
Sender/recipient rewriting in Postfix
Blacklist (domain/address)
Mail relay and routing
PostgreSQL
Major PostgreSQL Upgrade Without Downtime
Generate queries to change the owner of tables and sequences
Reset a schema
Duplicate indices
Close connections
Schema cleanup
Security
Squid blacklists
Squid on OpenBSD
OpenSSL
Shell
SSH
SSH public key regeneration
Connection keepalive
Introduction
System
PostgreSQL 9.1 benchmark
Terraform
Terraform - recover from lost state
Tools
Vim
Built with
from
Grav
and
Hugo
Sharing UNIX knowledge
>
Tags
> Pg_stat_activity
Published : 2016-09-10
Pg_stat_activity
Section articles
2016-09-10 | Close connections