DBA Tips

Blog for Oracle/Postgres Database Administrators

Pages

  • Home
  • AI
  • Postgres
  • Oracle
  • MSSQL
  • Backup
  • About

Backup PostgreSQL with Barman

The traditional Barman backup via rsync/SSH is supporting options:
- incremental backup, 
- parallel backup,
- WAL compression, network compression during backup,
- deduplication,
- using tablespaces

01. Software Installation & Configuration
  • 01.01. Database PostgreSQL Server Installation & Configuration
  • 01.02. Barman Installation & Configuration
02. Backup & Restore
  • 02.01. Base Backup
  • 02.02. Restore database
  • 02.03. Tablespaces
  • 02.04. Syntax for retention_policy
03. Tests
  • 03.01. Parallels
  • 03.02. Compression
  • 03.03. Deduplication
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Home
Subscribe to: Comments (Atom)

Search This Blog

Recent projects

  • Oracle
    • Creating copies of databases based on ACFS snapshots
    • Enable Fast-Start-Failover Data Guard Broker (in Zero Data Loss Mode) with OBSERVER
    • Two ways to recover data in an Oracle database table containing corruption blocks
  • Postgres
    • PostgreSQL14 HA with Patroni 2.1, Etcd, Haproxy, Keepalived (EL8)
    • Backup PostgreSQL with Barman
    • Connecting PostgreSQL to an Oracle database (oracle_fdw)
    • How to migrate data from Oracle to PostgreSQL using Ora2pg
    • Creating a replication schemas Postgres-> [Postgres &Oracle] using Oracle GoldenGate
    • Migration of Oracle database to Postgres with minimum downtime using Oracle GoldenGate
  • MSSQL
    • Copy SQL Logins by assigning roles and permissions
  • Backup
    • Netbackup tips

About Me

My photo
Roman Grishchenko
Blog for Oracle/Postgres Database Administrators
View my complete profile
Sunower. Powered by Blogger.