pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





view thread (15+ messages)  latest in thread

Message-ID: <1354569.1672640342@sss.pgh.pa.us>
Permalink:  ../1354569.1672640342@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1354569.1672640342@sss.pgh.pa.us

 · 

reply

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