Interactive authentication required error and database shut down

PostgreSQL
1

We have installed latest version of Postgres 16.1 in Azure VM. IT is working fine for some time. Later getting error as

MicrosoftTeams-image (2)
MicrosoftTeams-image (2)1854Ă—309 120 KB

postgres the database system is shutting down 
interactive authentication required
1 Like
2

Hi @Ponmani
The error messages from your PostgreSQL on Azure VM suggest there could be permission issues or unexpected shutdown commands. The “interactive authentication required” message happens because a non-admin user (probably postgres user) is trying to issue a systemd command or a privileged command. Postgres users by default should not do that.

You should check the PostgreSQL user permissions and confirm that the system hasn’t been compromised, as /tmp/kinsing is often associated with a known malware.

Let us know if this is what has happened or if you have found another signal in your logs.