# What it Takes to Recover a 100 TB Postgres Database in AWS RDS

DevFeed: [What it Takes to Recover a 100 TB Postgres Database in AWS RDS](<https://devfeed.tech/articles/what-it-takes-to-recover-a-100-tb-postgres-database-in-aws-rds-5765.md>)

Original publisher: [Read original article](<https://neon.com/blog/recover-large-postgres-databases>)

Author: Carlota Soto

Published: 2025-02-04T01:22:52Z

Content type: article

Language: en

Sources: [Blog -- Neon Docs](<https://devfeed.tech/sources/blog-neon-docs.md>)

Topics: [Database](<https://devfeed.tech/topics/database.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Disaster Recovery](<https://devfeed.tech/topics/disaster-recovery.md>), [Availability](<https://devfeed.tech/topics/availability.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>)

Tags: [amazon-s3](<https://devfeed.tech/tags/amazon-s3.md>), [availability](<https://devfeed.tech/tags/availability.md>), [aws](<https://devfeed.tech/tags/aws.md>), [backup](<https://devfeed.tech/tags/backup.md>), [database](<https://devfeed.tech/tags/database.md>), [disaster-recovery](<https://devfeed.tech/tags/disaster-recovery.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [product](<https://devfeed.tech/tags/product.md>), [production](<https://devfeed.tech/tags/production.md>), [replication](<https://devfeed.tech/tags/replication.md>)

## AI overview

This article examines how AWS RDS handles recovery for a 100 TB Postgres database. It distinguishes logical failures, which require point-in-time recovery using snapshots and WAL replay, from infrastructure or Availability Zone failures, which require high availability through redundant instances. It explains that snapshot restoration and WAL replay can take hours at this scale, while Multi-AZ standbys support automatic failover but do not protect against replicated data corruption.

## Source excerpt

Imagine your AWS RDS Postgres database scales to 100 TB. Now, sh*t disaster happens--your production instance experiences a critical failure. How would RDS handle different failure modes? And how long would it take to restore full production capability? Production failure modes Pr...