From: | Rui DeSousa <rui(at)crazybean(dot)net> |
---|---|
To: | Lynn Carol Johnson <lcj34(at)cornell(dot)edu> |
Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Postgres dying after many failed logins |
Date: | 2021-11-08 17:33:27 |
Message-ID: | A5BC5082-07CE-485A-B684-4B3127CCB76A@crazybean.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> On Nov 8, 2021, at 7:45 AM, Lynn Carol Johnson <lcj34(at)cornell(dot)edu> wrote:
>
> 2021-11-05 14:35:09.197 UTC [1451469] LOG: received smart shutdown request
> 2021-11-05 14:35:09.222 UTC [1451660] postgres(at)breedbase FATAL: terminating connection due to administrator command
That does not look like PostgreSQL crashed but is being shutdown by RDS services due to a DOS attack.
Two things;
1. A firewall should be blocking the incoming rouge traffic to protect the given server; otherwise the system is open to a DOS attack.
2. Why is PostgreSQL accessible on the internet? Normally DB servers are at least 3 deep from the internet and only internal trusted nodes should be connecting to the database.
From | Date | Subject | |
---|---|---|---|
Next Message | Lynn Carol Johnson | 2021-11-08 18:40:08 | Re: Postgres dying after many failed logins |
Previous Message | Vijaykumar Jain | 2021-11-08 16:15:40 | Re: Postgres dying after many failed logins |