| Server IP : 10.10.92.66 / Your IP : 104.23.197.230 Web Server : Apache/2.4.52 (Ubuntu) System : Linux jurnalpolinema 5.15.0-177-generic #187-Ubuntu SMP Sat Apr 11 22:54:33 UTC 2026 x86_64 User : jurnal ( 1001) 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 : OFF | Sudo : ON | Pkexec : ON 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. [email protected] [email protected] Weekly basebackup in /var/backups/postgresql/version/cluster. By default, 3 copies are being kept. To enable, run systemctl enable --now [email protected] systemctl start [email protected] [email protected] WAL archival to be used with [email protected] for PITR. To enable, run systemctl enable --now [email protected] [email protected] systemctl start [email protected] [email protected] [email protected] Weekly SQL dump in /var/backups/postgresql/version/cluster. By default, 3 copies are being kept. To enable, run systemctl enable --now [email protected] systemctl start [email protected] 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 <[email protected]> Mon, 08 Mar 2021 13:45:26 +0100