| Server IP : 82.148.16.210 / Your IP : 216.73.216.19 Web Server : nginx/1.29.5 System : Linux mail.sarafai.ru 6.1.0-43-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.162-1 (2026-02-08) x86_64 User : root ( 0) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /proc/thread-self/root/usr/share/doc/postgresql-common/ |
Upload File : |
systemd unit files for PostgreSQL on Debian/Ubuntu -------------------------------------------------- Each cluster is run as a separate service, called postgresql@version-cluster. pg_ctlcluster is invoked with --skip-systemctl-redirect. Logging still goes to /var/log/postgresql. There is a parent service called postgresql.service, that starts/stops/restarts/ reloads all individual services that are configured as "auto" in /etc/postgresql/*/*/start.conf. The link between start.conf and postgresql.service is established by postgresql-generator, which creates symlinks in /run/systemd/generator/postgresql.service.wants/. Backup ------ Two backup mechanisms are being offered as systemd services: basebackups capable of point in time recovery (PITR, the preferred method), and SQL-level dumps. pg_basebackup@version-cluster.service pg_basebackup@version-cluster.timer Weekly basebackup in /var/backups/postgresql/version/cluster. By default, 3 copies are being kept. To enable, run systemctl enable --now pg_basebackup@version-cluster.timer systemctl start pg_basebackup@version-cluster.service pg_receivewal@version-cluster.service WAL archival to be used with pg_basebackup@.service for PITR. To enable, run systemctl enable --now pg_basebackup@version-cluster.timer pg_receivewal@version-cluster.service systemctl start pg_basebackup@version-cluster.service pg_dump@version-cluster.service pg_dump@version-cluster.timer Weekly SQL dump in /var/backups/postgresql/version/cluster. By default, 3 copies are being kept. To enable, run systemctl enable --now pg_dump@version-cluster.timer systemctl start pg_dump@version-cluster.service The mechanisms provided are meant to be used with low to medium size databases. For larger databases, or databases with high write volume, we advise to use a full-size backup solution such as pgbackrest or barman. -- Christoph Berg <myon@debian.org> Mon, 08 Mar 2021 13:45:26 +0100