在我的服务器上(ubuntu by nginx,docker和Django by gunicorn)
该网站运行良好,但数据库有时突然下降,我失去了我的数据,这件事多次重复
当我回到/var/log/postgresql/postgresql-14-main. log
"2023-10-28 12:12:17.689 UTC [3752923] postgres@postgres DETAIL: Connection matched pg_hba.conf line 102: "host all all 0.0.0.0/0 >
2023-10-28 12:12:21.050 UTC [3753069] postgres@template0 FATAL: database "template0" is not currently accepting connections
2023-10-28 12:12:43.319 UTC [3706001] postgres@aeraeg_db FATAL: terminating connection due to administrator command
2023-10-28 12:12:44.912 UTC [3753497] postgres@postgres ERROR: cannot drop the currently open database
2023-10-28 12:12:44.912 UTC [3753497] postgres@postgres STATEMENT: DROP DATABASE postgres;
2023-10-28 12:12:45.541 UTC [3244077] LOG: could not parse file name "pg_logical/snapshots/memory"
2023-10-28 12:12:45.541 UTC [3244077] LOG: could not parse file name "pg_logical/snapshots/prememory"
2023-10-28 12:12:46.226 UTC [3244077] LOG: could not parse file name "pg_logical/snapshots/memory"
2023-10-28 12:12:46.226 UTC [3244077] LOG: could not parse file name "pg_logical/snapshots/prememory"
2023-10-28 12:12:48.206 UTC [3244077] LOG: could not parse file name "pg_logical/snapshots/memory"
2023-10-28 12:12:48.206 UTC [3244077] LOG: could not parse file name "pg_logical/snapshots/prememory"
2023-10-28 12:12:48.556 UTC [3244077] LOG: could not parse file name "pg_logical/snapshots/memory"
2023-10-28 12:12:48.556 UTC [3244077] LOG: could not parse file name "pg_logical/snapshots/prememory"
2023-10-28 12:14:11.702 UTC [3755239] postgres@aeraeg_db FATAL: database "aeraeg_db" does not exist"
字符串
如何保护我的数据库不被删除
1条答案
按热度按时间bkkx9g8r1#
以backups、harden your security和keep it up to date为例。