Restor RDS from Snapshot, no data

I apologize for the confusion you're experiencing. Typically, when you restore an RDS snapshot, it should include all the data that was present in the database at the time the snapshot was taken. The fact that your restored database is empty is unusual and suggests there might be an issue with the snapshot or the restoration process.

Here are a few things to check and try:

1. Verify the snapshot: Make sure you're restoring the correct snapshot. Check the timestamp and other details to confirm it's the one you created yesterday.

2. Check the original database: Confirm that the original database had data when the snapshot was taken. If the original database was empty, the snapshot would also be empty.

3. Restore process: When restoring an Aurora PostgreSQL Serverless cluster from a snapshot, ensure you're following the correct steps:

   • Sign in to the AWS Management Console and open the Amazon RDS console
   • Choose "Snapshots" from the navigation pane
   • Select the correct DB cluster snapshot
   • Choose "Restore Snapshot" from the Actions menu
   • On the "Restore DB Cluster" page, select "Serverless" for "Capacity type"
   • Enter a name for your restored DB cluster
   • Modify the capacity settings if needed
   • Choose "Restore DB Cluster"

4. Check permissions: Ensure that your IAM user or role has the necessary permissions to restore the snapshot with all its data.

5. Verify connectivity: After restoration, make sure you're connecting to the correct endpoint of the newly restored database.

6. Check for post-restoration scripts: Some deployments might include scripts that run after restoration and could potentially clear data. Review your deployment process to ensure this isn't happening.

If after checking these points you still don't see your data, I recommend contacting AWS Support. They can help investigate why the restored database is empty and assist in recovering your data. They have access to more detailed logs and can provide specific guidance based on your account and database configuration.

Remember, RDS snapshots are designed to capture the entire state of the database, including all data, at the time the snapshot is taken. If the process worked correctly, all your data should be present after restoration.
Sources
Restoring an Aurora Serverless v1 DB cluster - Amazon Aurora