pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rob Sargent <robjsargent@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours
Date: Sun, 1 Jan 2023 14:50:54 -0700
Message-ID: <45f03cf0-b93f-f7e2-617c-6381c80ebe2f@gmail.com> (raw)
In-Reply-To: <5cff562f-abf7-b191-c4f6-24409715309e@aklaver.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>

On 1/1/23 14:48, Adrian Klaver wrote:
> On 1/1/23 13:11, Antonis Christodoulou wrote:
>> Hello Adrian,
>>
>> No it’s not open, but the database itself has very simple credentials 
>> (I am just starting with PostgreSQL). What’s weird about the logs?
>
> Not the logs the ps output. I would expect to see something like:
>
> ps -ef | grep postgres
> postgres  395382       1  0  2022 ?        00:03:31 
> /usr/lib/postgresql/14/bin/postgres -D /var/lib/postgresql/14/main -c 
> config_file=/etc/postgresql/14/main/postgresql.conf
> postgres  395384  395382  0  2022 ?        00:00:01 postgres: 14/main: 
> checkpointer
> postgres  395385  395382  0  2022 ?        00:00:26 postgres: 14/main: 
> background writer
> postgres  395386  395382  0  2022 ?        00:00:26 postgres: 14/main: 
> walwriter
> postgres  395387  395382  0  2022 ?        00:01:45 postgres: 14/main: 
> autovacuum launcher
> postgres  395388  395382  0  2022 ?        00:00:05 postgres: 14/main: 
> archiver last was 0000000100000003000000B9.00000028.backup
> postgres  395389  395382  0  2022 ?        00:01:37 postgres: 14/main: 
> stats collector
> postgres  395390  395382  0  2022 ?        00:02:24 postgres: 14/main: 
> pg_cron launcher
> postgres  395391  395382  0  2022 ?        00:00:01 postgres: 14/main: 
> logical replication launcher
>
> This:
>
> 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
>
> just does not look right.
>
>
At the very least disconnect that machine from the internet.  Completely.

view thread (15+ messages)  latest in thread

Message-ID: <45f03cf0-b93f-f7e2-617c-6381c80ebe2f@gmail.com>
Permalink:  ../45f03cf0-b93f-f7e2-617c-6381c80ebe2f@gmail.com/
Also on:    postgresql.org/message-id/45f03cf0-b93f-f7e2-617c-6381c80ebe2f@gmail.com

 · 

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: robjsargent@gmail.com
  Subject: Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours
  In-Reply-To: <45f03cf0-b93f-f7e2-617c-6381c80ebe2f@gmail.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>

* 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