CODEWITHSUNDEEP
postgresqlsecuritycentoscpupostgis
Elkadiri Imad
Elkadiri Imad

Reputation: 73

Solution for user postgres launches process allocate 2405% of CPU

After install Postgresql-11 and POSTGIS on my server then I realize that the CPU is higher ~ 2405% of it.

My situation is similare to: user postgres launches process that takes all CPUs 100% usage

the solution proposed in the above post is that : Take the machine from the internet, wipe it clean and re-install the operating system.

My question is what Can I do to resolve this problem without re-install the operating system ?

Here's an htop output

Upvotes: 0

Views: 137

Answers (1)

jjanes
jjanes

Reputation: 44287

You never know what backdoor someone might have installed, hence the advice to reinstall. But pragmatically speaking, they are probably doing nothing more than mining cryptocurrency. Simply securing all your PostgreSQL accounts with strong passwords or inactivating/deleting them (including accounts the attackers might have created themselves) and rebooting the OS would then be enough to get them out and keep them out. But if the database server doesn't need to be exposed to the internet, don't expose it.

Upvotes: 1

Related Questions