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

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours
Дата
Msg-id 20230103055829.bl3ltzft5o6uzl7u@jrouhaud
обсуждение исходный текст
Ответ на Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours  (Antonis Christodoulou <christan305@hotmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: Exact same output - pg_stat_statements
Следующее
От: "Zwettler Markus (OIZ)"
Дата:
Сообщение: postgres restore & needed history files