PostgreSQL received fast shutdown request by azure_superuser

Question

Hi,

yesterday we've noticed a data loss with one of our postgresql for azure databases. In the server logs we were able to track it down to the following:

2021-03-10 19:24:38 UTC-60491cf6.1e380-LOG: connection received: host=127.0.0.1 port=33713 pid=123776
2021-03-10 19:24:39 UTC-60491cf6.1e380-LOG: connection authorized: user=azure_superuserdatabase=postgres SSL enabled (protocol=TLSv1.2, cipher=ECDHE-RSA-AES256-GCM-SHA384, compression=off)
2021-03-10 19:24:40 UTC-6000b022.24-LOG: received fast shutdown request
2021-03-10 19:24:40 UTC-6000b022.24-LOG: aborting any active transactions
2021-03-10 19:24:40 UTC-60491ceb.1e320-FATAL: terminating connection due to administrator command
[and so on]

is this expected behavior?

Thanks in advance
Christian

Answer 1

@RuttorfChristian-9443

This could have happened cause of the planned maintenance for the underlying resources for the Azure Database for Postgresql. Here is the document that explains the same.

You need to contact support to find if that exactly happened as they have telemetry to find that. Also the best approach to prevent this is below:

1) Retry Logic

2) Planned restart notification set up

Hope this helps.

Regards
Navtej S