Re: Postgres dying after many failed logins

Поиск
Список
Период
Сортировка
От Rui DeSousa
Тема Re: Postgres dying after many failed logins
Дата
Msg-id A5BC5082-07CE-485A-B684-4B3127CCB76A@crazybean.net
обсуждение исходный текст
Ответ на Postgres dying after many failed logins  (Lynn Carol Johnson <lcj34@cornell.edu>)
Ответы Re: Postgres dying after many failed logins  (Lynn Carol Johnson <lcj34@cornell.edu>)
Список pgsql-admin

On Nov 8, 2021, at 7:45 AM, Lynn Carol Johnson <lcj34@cornell.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@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.


В списке pgsql-admin по дате отправления:

Предыдущее
От: Vijaykumar Jain
Дата:
Сообщение: Re: Postgres dying after many failed logins
Следующее
От: Lynn Carol Johnson
Дата:
Сообщение: Re: Postgres dying after many failed logins