Report this

What is the reason for this report?

Postgresql: terminating connection due to administrator command

Posted on July 3, 2025

Hi guys, I’m trying to create materialized view for my table with ~5 million records. For some reason however I get the following error: “terminating connection due to administrator command”.

AI pointed me in the direction of a possible failover or maintenance scenario which wasn’t recorded in the DO Dashboard log-overview.

I already tried multiple times today, but the query fails and I’m not able to debug the cause.



This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.