# Backup & restore individual databases

**URL:** <https://forums.percona.com/t/backup-restore-individual-databases/32999>\
**Category:** Percona Operator for PostgreSQL\
**Created:** [September 8, 2024, 5:36pm UTC](https://forums.percona.com/t/backup-restore-individual-databases/32999 "2024-09-08T17:36:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fragment2](https://avatars.discourse-cdn.com/v4/letter/f/b5ac83/32.png) [@Fragment2](https://forums.percona.com/u/Fragment2)\
**Post date:** [September 8, 2024, 5:36pm UTC](https://forums.percona.com/t/backup-restore-individual-databases/32999/1 "2024-09-08T17:36:54Z")

</div>

Hey again 😃

With my cluster up and running and backups working using `PerconaPGBackup` I started looking into restores and database recovery. I might be overlooking but I can’t seem to find any documentation on how to target a single database? I paged through the reference for backup and restore, checked the options and searched the docs and forums.

Perhaps the backup and restore is only for full cluster recovery?

In that case, I probably need to use sidecars with scripts to backup individual databases, is that correct?

Is there any information for this that I might have missed?

Any tips are welcome 🙂

Thanks again!

---

<div class="post-metadata">

**Author:** ![Robert\_Bernier](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/robert_bernier/32/1367_2.png) [@Robert\_Bernier](https://forums.percona.com/u/Robert_Bernier)\
**Post date:** [September 9, 2024, 1:28pm UTC](https://forums.percona.com/t/backup-restore-individual-databases/32999/2 "2024-09-09T13:28:24Z")

</div>

Hi,

There are no high-level tools like pgbackrest that have the ability to restore individual databases, you’ll need to use utilities like pg\_dump, pg\_restore. You could even use logical replication but that means you’ll need to handle the details yourself.

Hope this helps.

---

<div class="post-metadata">

**Author:** ![Fragment2](https://avatars.discourse-cdn.com/v4/letter/f/b5ac83/32.png) [@Fragment2](https://forums.percona.com/u/Fragment2)\
**Post date:** [September 9, 2024, 1:34pm UTC](https://forums.percona.com/t/backup-restore-individual-databases/32999/3 "2024-09-09T13:34:15Z")

</div>

Yes, it does thank you.

I figured as much but I guess I’d ask to be sure.

Cheers!