Unable to restore db backup on local machine

[beingvishalt]

I am using CNPG 1.26 with Barman Plugin 0.11.0 on ak8s.

I taken the backup of one of DB cluster on azure blob storage.

I am able to restore db backup on same ak8s cluster .

Is there any way to restore that backup on local machine by downloading that backupfiles from blob storage.

And if possible which file required only backup.info and base folder files that is zip file or wal files also required?

@dosu please help

[dosubot]

Yes, you can restore a Barman Cloud backup on a local machine using the Barman CLI tools directly. Here's what you need:

Required Files:

• Base backup (tarball in the base/ folder) — required
• WAL files (in the wals/ folder) — required, even for a full restore without PITR. There is no supported way to restore from a base backup alone
• backup.info — contains metadata (BackupID, WAL ranges, LSN info)

Local Restoration Steps:

1. Install Barman CLI tools and ensure you have Azure credentials configured

2. List available backups:

   barman-cloud-backup-list --cloud-provider azure-blob-storage \
     https://<storage-account>.blob.core.windows.net/<container> <server-name>

3. Restore the base backup:

   barman-cloud-restore --cloud-provider azure-blob-storage \
     https://<storage-account>.blob.core.windows.net/<container> \
     <server-name> <backup-id> /path/to/pgdata

4. Configure WAL recovery — create recovery.signal and add to postgresql.conf:

   restore_command = 'barman-cloud-wal-restore --cloud-provider azure-blob-storage https://<storage-account>.blob.core.windows.net/<container> <server-name> %f %p'
   recovery_target_action = promote
   

5. Start PostgreSQL — it will replay WALs and promote automatically

You can also use the CNPG PostgreSQL container image which has the Barman tools pre-installed:

docker run --rm -it -v $(pwd)/credentials:/var/lib/postgresql/.azure/credentials \
  ghcr.io/cloudnative-pg/postgresql:18.0 bash

Note: Local restoration outside Kubernetes is not officially supported but is technically possible using these standard Barman tools.

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}

   

[beingvishalt]

I don’t have credentials or access to direct blob storage . I will get the downloaded all files base as well as wal files. So can we restore it on local

@dosu

[dosubot]

Yes, you can restore locally from downloaded files, but you'll need to do it manually using standard PostgreSQL recovery — not through the Barman Cloud tools (which expect object storage access).

Manual Restore Process:

1. Extract the base backup tarball to a local directory (this will be your PGDATA):

   mkdir /path/to/pgdata
   tar -xvf base/<backup-tarball>.tar -C /path/to/pgdata

2. Create a WAL archive directory and copy all your downloaded WAL files there:

   mkdir /path/to/wal_archive
   cp /downloaded/wals/* /path/to/wal_archive/

3. Configure PostgreSQL for recovery — create a recovery.signal file in PGDATA and add to postgresql.conf:

   restore_command = 'cp /path/to/wal_archive/%f %p'
   recovery_target_action = promote
   

4. Fix permissions (PostgreSQL requires specific ownership):

   chown -R postgres:postgres /path/to/pgdata
   chmod 700 /path/to/pgdata

5. Start PostgreSQL:

   pg_ctl -D /path/to/pgdata start

PostgreSQL will replay the WAL files and then promote itself to a primary.

Important: Make sure you have all necessary WAL files — PostgreSQL recovery will fail if any required WAL segment is missing. The backup needs WALs from BeginWal to EndWal at minimum for a consistent restore.

This is a standard PostgreSQL restore procedure and works independently of CloudNativePG/Barman.

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}