Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours

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.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com