Postgres Pro
Downloads
Home   >   mailing lists

Will Barman support restore of single database? - Mailing list pgsql-general

From Andreas Joseph Krogh
Subject Will Barman support restore of single database?
Date
Msg-id VisenaEmail.66.6caea3a2481dc9bd.17ea1361482@tc7-visena
Whole thread Raw
List pgsql-general
Tree view

Hi, pgBackRest supports restoring only specified database: https://pgbackrest.org/command.html#command-restore

11.1.3
Include Database Option (--db-include)
Restore only specified databases.

This feature allows only selected databases to be restored. Databases not specifically included will be restored as sparse, zeroed files to save space but still allow PostgreSQL to perform recovery. After recovery, the databases that were not included will not be accessible but can be removed with the drop database command.
 

NOTE:
built-in databases (template0, template1, and postgres) are always restored unless specifically excluded.

The --db-include option can be passed multiple times to specify more than one database to include.

See Restore Selected Databases for additional information and caveats.

Are there any plans to add support for this to Barman?

--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
Attachment

pgsql-general by date:

Previous
From: Umair Shahid
Date:
Subject: Re: PostgreSQL Management and monitoring tool
Next
From: Mladen Gogala
Date:
Subject: pg_try_advisory_lock is waiting?