Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours - Mailing list pgsql-general

From Julien Rouhaud
Subject Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours
Date
Msg-id 20230103055829.bl3ltzft5o6uzl7u@jrouhaud
Whole thread Raw
In response to Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours  (Antonis Christodoulou <christan305@hotmail.com>)
List pgsql-general
On Mon, Jan 02, 2023 at 08:53:32AM +0200, Antonis Christodoulou wrote:
> And for the record, Ahmet, here’s a weird cron job:
>
> christan@vultr:~$ sudo crontab -l -u postgres
> 13 * * * * /var/lib/postgresql/.systemd-private-x8C8W8llVk0Rzccy9N0ggCOI2VBAc.sh > /dev/null 2>&1 &
>
> Had no idea somebody can add something like this externally...

Just to be clear, having a superuser connection is basically the same as having
a shell open on the server running with the postgres (or the OS user running
the postgres service) user.  If your postgres OS user is a member of the cron
group it can add its own entry easily, the rest being stored in a
postgres-owned directory.



pgsql-general by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: Exact same output - pg_stat_statements
Next
From: "Zwettler Markus (OIZ)"
Date:
Subject: postgres restore & needed history files