| Server IP : 85.214.239.14 / Your IP : 18.119.235.107 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 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 : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /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