Backup & restore individual databases

PostgreSQL Percona Operator for PostgreSQL
1

Hey again :smiley:

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 :slight_smile:

Thanks again!

2

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.

1 Like
3

Yes, it does thank you.

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

Cheers!