Skip to content

Instantly share code, notes, and snippets.

View yurykovshov's full-sized avatar

Yury yurykovshov

  • Cologne, Germany
View GitHub Profile
@yurykovshov
yurykovshov / simple_postgres.md
Last active November 17, 2024 11:53
Simple Postgres Database with connection pool and backups

Simple Postgres Database deployment with PgBouncer connection pool and backups to S3 storage

Motivation and Goal

Main motivation here is to have a cheap and simple Postgres Database server with backups, but without the failover. And in order to get cheap (in terms of memory) connections - use the PgBouncer. Why without the failover? Because in my case I didn't need a 100% stable cluster, but I needed a cheap and simple solution, which in case of disaster could be recovered in some X hours. If you are looking for a failover cluster - there is nice automation here: https://github.com/vitabaks/postgresql_cluster

Prerequisites

@robertpainsi
robertpainsi / commit-message-guidelines.md
Last active December 3, 2025 19:19
Commit message guidelines

Commit Message Guidelines

Short (72 chars or less) summary

More detailed explanatory text. Wrap it to 72 characters. The blank
line separating the summary from the body is critical (unless you omit
the body entirely).

Write your commit message in the imperative: "Fix bug" and not "Fixed
bug" or "Fixes bug." This convention matches up with commit messages