Skip to content

Instantly share code, notes, and snippets.

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

Oleksandr Kirpachov kirpachov

🏠
Working from home
7 followers · 23 following
View GitHub Profile
@kirpachov
kirpachov / Copy locally production database.md
Last active May 9, 2025 17:12
Scripts to setup postgresql with pitr on s3 + disaster recovery

Production database must be a postgresql configured with wal-g and s3.

Copy locally a production database

In questo esempio specifico riproduciamo il database di lime3 (q.opinioni.net) in locale.

0. Generic requirements configuration

  • local postgresql installation
  • wal-g configured. Verify wal-g configuration with wal-g backup-list
  • aws iam user with s3 read permissions