Blog Post

Azure Database Support Blog
2 MIN READ

Azure PostgreSQL Lesson Learned#7: Database Missing After Planned Maintenance

angesalsaa's avatar
angesalsaa
Icon for Microsoft rankMicrosoft
Nov 18, 2025

A customer reported an issue when attempting to connect to a specific user database after a maintenance window: FATAL: database 'xyz' does not exist DETAIL: The database subdirectory 'pg_tblspc/.../PG_..../...' is missing. This error typically occurs when the database was created under a temporary tablespace, which is not backed up during maintenance or server restarts.

Co‑authored with HaiderZ-MSFT​ Overview If you’re running Azure Database for PostgreSQL Flexible Server, you might encounter a scenario where your database disappears after planned maintenance. ...
Updated Nov 19, 2025
Version 2.0
Rizwan_Siddiqui's avatar
Rizwan_Siddiqui
Copper Contributor
Nov 19, 2025

Learnt something really important today and it's shows how important is to focus on such detail while configuring or customising the db. Thank you. Keep posting.

  • angesalsaa's avatar
    angesalsaa
    Icon for Microsoft rankMicrosoft
    Nov 19, 2025

    Thank you for sharing your thoughts! Absolutely, this is essential for your database reliability and continuity. Glad the post was helpful! We’ll keep sharing more insights to help avoid hidden pitfalls.