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.klaver@aklaver.com