Bumped by Community user
3 added 4 characters in body
source | link

Is it possible to restore a database instance using logical backup and wal files?

A senior SQL Server DBA asked me to implement abelow scenario in PostgreSQL

took the logical backup using pg_dumpall of the master then do failover after some time. Now restore database instance using the logical backup of primary + wal files of primary + wal files of secondary.

Is it possible to restore a database instance using logical backup and wal files?

A senior SQL Server DBA asked me to implement a scenario in PostgreSQL

took the logical backup using pg_dumpall of the master then do failover after some time. Now restore database instance using the logical backup of primary + wal files of primary + wal files of secondary.

Is it possible to restore a database instance using logical backup and wal files?

A senior SQL Server DBA asked me to implement below scenario in PostgreSQL

took the logical backup using pg_dumpall of the master then do failover after some time. Now restore database instance using the logical backup of primary + wal files of primary + wal files of secondary.

2 edited title
| link

Recovery Restore server instance using logical backup and wal files

1
source | link

Recovery server instance using logical backup and wal files

Is it possible to restore a database instance using logical backup and wal files?

A senior SQL Server DBA asked me to implement a scenario in PostgreSQL

took the logical backup using pg_dumpall of the master then do failover after some time. Now restore database instance using the logical backup of primary + wal files of primary + wal files of secondary.