From: Tom Lane <tgl@sss.pgh.pa.us>
To: Antonis Christodoulou <christan305@hotmail.com>
Cc: Rob Sargent <robjsargent@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours
Date: Mon, 02 Jan 2023 01:19:02 -0500
Message-ID: <1354569.1672640342@sss.pgh.pa.us> (raw)
In-Reply-To: <VI1P193MB051005C8BE974502A0D4A315E1F79@VI1P193MB0510.EURP193.PROD.OUTLOOK.COM>
References: <VI1P193MB0510BD2D5A8FCE7B2A1BE073E1F69@VI1P193MB0510.EURP193.PROD.OUTLOOK.COM>
<25d1ff9d-62dd-3124-d6f6-55615ed90d85@aklaver.com>
<PR3P193MB05084A74EA9F0EB86CCF1C90E1F69@PR3P193MB0508.EURP193.PROD.OUTLOOK.COM>
<5cff562f-abf7-b191-c4f6-24409715309e@aklaver.com>
<45f03cf0-b93f-f7e2-617c-6381c80ebe2f@gmail.com>
<VI1P193MB051005C8BE974502A0D4A315E1F79@VI1P193MB0510.EURP193.PROD.OUTLOOK.COM>
Antonis Christodoulou <christan305@hotmail.com> <VI1P193MB051005C8BE974502A0D4A315E1F79@VI1P193MB0510.EURP193.PROD.OUTLOOK.COM> writes:
> This is a machine in the cloud, I can’t disconnect it.
In that case, you need to be taking nonzero security precautions.
> And yes the ps looks like this precisely when I do a fresh restart. I kill all postgres processes and restart:
> Then this is the output of me ps:
That looks fine ... but this doesn't:
>>> postgres 3342383 1 0 2022 ? 00:00:00 FzXlkULu
>>> postgres 3344758 1 99 2022 ? 3-14:39:11 OElid7Dp
>>> postgres 3419125 1 18 13:57 ? 01:17:03 tracepath
Somebody is hacking into your system and commandeering it to run
something resource-intensive, possibly a bitcoin miner. Whatever
it is, it's trying to obscure its process name which is hardly
a sign of good intentions.
I'd counsel taking a hard look at your pg_hba.conf to be sure
it's not allowing non-credentialed logins from anywhere. And
for pete's sake don't use a guessable password.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: tgl@sss.pgh.pa.us, christan305@hotmail.com, robjsargent@gmail.com
Subject: Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours
In-Reply-To: <1354569.1672640342@sss.pgh.pa.us>
References: <VI1P193MB0510BD2D5A8FCE7B2A1BE073E1F69@VI1P193MB0510.EURP193.PROD.OUTLOOK.COM> <25d1ff9d-62dd-3124-d6f6-55615ed90d85@aklaver.com> <PR3P193MB05084A74EA9F0EB86CCF1C90E1F69@PR3P193MB0508.EURP193.PROD.OUTLOOK.COM> <5cff562f-abf7-b191-c4f6-24409715309e@aklaver.com> <45f03cf0-b93f-f7e2-617c-6381c80ebe2f@gmail.com> <VI1P193MB051005C8BE974502A0D4A315E1F79@VI1P193MB0510.EURP193.PROD.OUTLOOK.COM> <1354569.1672640342@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox