{"id":6006,"date":"2026-08-18T07:00:00","date_gmt":"2026-08-18T04:00:00","guid":{"rendered":"https:\/\/www.dataplatform.gr\/?p=6006"},"modified":"2026-08-18T12:35:32","modified_gmt":"2026-08-18T09:35:32","slug":"pos-kanoyme-backup-vasi-dedomenon-postgresql-choris-t","status":"publish","type":"post","link":"https:\/\/www.dataplatform.gr\/en\/%cf%80%cf%8e%cf%82-%ce%ba%ce%ac%ce%bd%ce%bf%cf1-tp3t85%ce%bc%ce%b5-backup-%ce%b2%ce%ac%cf%83%ce%b7-%ce1-tp3tb4%ce%b5%ce%b4%ce%bf%ce%bc%ce%ad%ce%bd%cf%891tp-3tce%bd-postgresql-%cf%87%cf%89%cf%81%ce%af\/","title":{"rendered":"How to Backup a PostgreSQL Database Without Using 3rd Party Tools"},"content":{"rendered":"

\u03a3\u03b5 \u03b1\u03c5\u03c4\u03cc \u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b8\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03b2\u03ae\u03bc\u03b1 \u03b2\u03ae\u03bc\u03b1 \u03c0\u03c9\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 backup \u03c7\u03c9\u03c1\u03af\u03c2 \u03c4\u03b7\u03bd \u03c7\u03c1\u03ae\u03c3\u03b7 3rd party tools full backup \u03ba\u03b1\u03b9 log backup \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 PITR <\/strong>(Point in Time Recovery) \u03b1\u03bd \u03c7\u03c1\u03b5\u03b9\u03b1\u03c3\u03c4\u03b5\u03af \u03c3\u03c4\u03bf \u03bc\u03ad\u03bb\u03bb\u03bf\u03bd. \u03a4\u03ad\u03bb\u03bf\u03c2 \u03b8\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03c0\u03c9\u03c2 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03b1\u03c5\u03c4\u03bf\u03bc\u03b1\u03c4\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b7\u03bd \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 \u03ba\u03b1\u03b9 \u03c4\u03b7\u03bd \u03c3\u03c5\u03bd\u03c4\u03ae\u03c1\u03b7\u03c3\u03b7 \u03c4\u03bf\u03c5\u03c2 \u03bc\u03ad\u03c3\u03c9 cronjobs.<\/p>\n\n\n\n

\u0398\u03b1 \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03b3\u03bd\u03c9\u03c1\u03af\u03b6\u03bf\u03c5\u03bc\u03b5 \u03bf\u03c4\u03b9 \u03c4\u03b1 \u03b1\u03bd\u03c4\u03af\u03c3\u03c4\u03bf\u03b9\u03c7\u03b1 transaction \/ archive logs \u03c3\u03c4\u03b7 PostgreSQL \u03bf\u03bd\u03bf\u03bc\u03ac\u03b6\u03bf\u03bd\u03c4\u03b1\u03b9 WAL (Write Ahead Logs).<\/p>\n\n\n\n

The footsteps<\/h2>\n\n\n\n

\u03a0\u03c1\u03ce\u03c4\u03b1 \u03b8\u03b1 \u03c6\u03c4\u03b9\u03ac\u03be\u03bf\u03c5\u03bc\u03b5 \u03c4\u03bf\u03c5\u03c2 \u03c6\u03b1\u03ba\u03ad\u03bb\u03bf\u03c5\u03c2 \u03c0\u03bf\u03c5 \u03b8\u03b1 \u03c0\u03b5\u03c1\u03b9\u03ad\u03c7\u03bf\u03c5\u03bd \u03c4\u03b1 backup \u03ba\u03b1\u03b9 \u03b8\u03b1 \u03b4\u03ce\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b1 \u03b4\u03b9\u03ba\u03b1\u03b9\u03ce\u03bc\u03b1\u03c4\u03b1 \u03c0\u03bf\u03c5 \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03ad\u03c7\u03bf\u03c5\u03bd:<\/p>\n\n\n\n

sudo mkdir -p \/var\/lib\/postgresql\/backup\/full\nsudo mkdir -p \/var\/lib\/postgresql\/backup\/archived_wal\n\nsudo chown -R postgres:postgres \/var\/lib\/postgresql\/backup\nsudo chmod -R 700 \/var\/lib\/postgresql\/backup<\/pre>\n\n\n\n
\u03a3\u03c4\u03b7 \u03c3\u03c5\u03bd\u03ad\u03c7\u03b5\u03b9\u03b1 \u03b1\u03bd \u03b8\u03ad\u03bb\u03bf\u03c5\u03bc\u03b5 \u03bd\u03b1 \u03ad\u03c7\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b7 \u03b4\u03c5\u03bd\u03b1\u03c4\u03cc\u03c4\u03b7\u03c4\u03b1 Point in Time Recovery \u03b8\u03b1 \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bc\u03b5 \u03c4\u03bf\u03bd \u03c7\u03c1\u03ae\u03c3\u03c4\u03b7 postgres <\/strong>\u03bd\u03b1 \u03b5\u03bd\u03b5\u03c1\u03b3\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c4\u03bf archiving  \u03ba\u03b1\u03b9 \u03bd\u03b1 \u03b4\u03b7\u03bb\u03ce\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b7\u03bd \u03c4\u03bf\u03c0\u03bf\u03b8\u03b5\u03c3\u03af\u03b1 \u03c4\u03bf\u03c5\u03c2:<\/p>\n\n\n\n
su postgres<\/pre>\n\n\n\n
vi \/var\/lib\/pgsql\/11\/data\/postgresql.conf<\/pre>\n\n\n\n
# - Archiving -\n\narchive_mode = on               # enables archiving; off, on, or always\n\narchive_command = 'cp %p \/var\/lib\/postgresql\/backup\/archived_wal\/%f'<\/code><\/pre>\n\n\n\n
\u038c\u03c0\u03c9\u03c2 \u03b5\u03c0\u03af\u03c3\u03b7\u03c2 \u03c4\u03bf wal_level<\/code>:<\/p>\n\n\n\n
wal_level = replica<\/code><\/pre>\n\n\n\n
\u03a3\u03b5 \u03b1\u03c5\u03c4\u03cc \u03c4\u03bf \u03c3\u03b7\u03bc\u03b5\u03af\u03bf \u03b8\u03b1 \u03c7\u03c1\u03b5\u03b9\u03b1\u03c3\u03c4\u03b5\u03af restart \u03c4\u03bf\u03c5 service:<\/p>\n\n\n\n
sudo systemctl restart postgresql-11<\/pre>\n\n\n\n
\u03a6\u03c4\u03b9\u03ac\u03c7\u03bd\u03bf\u03c5\u03bc\u03b5 \u03ad\u03bd\u03b1 executable file \u03c4\u03bf \u03bf\u03c0\u03bf\u03af\u03bf \u03b8\u03b1 \u03c0\u03b5\u03c1\u03b9\u03ad\u03c7\u03b5\u03b9 \u03c4\u03bf script:<\/p>\n\n\n\n
vi \/usr\/local\/bin\/pg_full_backup.sh<\/pre>\n\n\n\n
\u03a3\u03c4\u03bf script \u03b4\u03b7\u03bb\u03ce\u03bd\u03bf\u03c5\u03bc\u03b5 \u03c4\u03bf\u03bd \u03c6\u03ac\u03ba\u03b5\u03bb\u03bf \u03c0\u03bf\u03c5 \u03c6\u03c4\u03b9\u03ac\u03be\u03b1\u03bc\u03b5 \u03c0\u03c1\u03b9\u03bd \u03b3\u03b9\u03b1 \u03c4\u03b1 full backups \u03ba\u03b1\u03b9 \u03b7 \u03b5\u03bd\u03c4\u03bf\u03bb\u03ae pg_basebackup <\/strong>\u03c4\u03c1\u03ad\u03c7\u03b5\u03b9 \u03c4\u03b7\u03bd \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 \u03b5\u03be\u03ac\u03b3\u03bf\u03bd\u03c4\u03b1\u03c2 \u03c4\u03b1 \u03b1\u03c1\u03c7\u03b5\u03af\u03b1 \u03c3\u03b5 \u03ad\u03bd\u03b1 \u03c3\u03c5\u03bc\u03c0\u03b9\u03b5\u03c3\u03bc\u03ad\u03bd\u03bf \u03b1\u03c1\u03c7\u03b5\u03af\u03bf. \u03a3\u03b1\u03bd \u03b4\u03b5\u03cd\u03c4\u03b5\u03c1\u03bf \u03b2\u03ae\u03bc\u03b1 \u03c4\u03c1\u03ad\u03c7\u03b5\u03b9 \u03b7 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 \u03c4\u03bf\u03c5 maintenance \u03c0\u03bf\u03c5 \u03ba\u03c1\u03b1\u03c4\u03ac\u03b5\u03b9 \u03c4\u03b1 \u03b1\u03c1\u03c7\u03b5\u03af\u03b1 \u03bc\u03cc\u03bd\u03bf \u03b3\u03b9\u03b1 30 \u03b7\u03bc\u03ad\u03c1\u03b5\u03c2:<\/p>\n\n\n\n
#!\/bin\/bash\nBACKUP_DIR=\"\/var\/lib\/postgresql\/backup\/full\"\nTIMESTAMP=$(date +%Y%m%d_%H%M%S)\nDEST=\"$BACKUP_DIR\/full_$TIMESTAMP\"\n\n#full backup\npg_basebackup -D \"$DEST\" -F t -z -P -X fetch\n\n#30 days retention\nfind \"$BACKUP_DIR\" -mindepth 1 -maxdepth 1 -type d -mtime +30 -exec rm -rf {} +<\/code><\/pre>\n\n\n\n
\u0391\u03c6\u03bf\u03cd \u03c4\u03bf \u03c6\u03c4\u03b9\u03ac\u03be\u03bf\u03c5\u03bc\u03b5 \u03b4\u03af\u03bd\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b1 \u03c3\u03c9\u03c3\u03c4\u03ac \u03b4\u03b9\u03ba\u03b1\u03b9\u03ce\u03bc\u03b1\u03c4\u03b1:<\/p>\n\n\n\n
sudo chown postgres:postgres \/usr\/local\/bin\/pg_full_backup.sh\nsudo chmod +x \/usr\/local\/bin\/pg_full_backup.sh<\/pre>\n\n\n\n
\u0391\u03bd\u03c4\u03af\u03c3\u03c4\u03bf\u03b9\u03c7\u03b1 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03c6\u03c4\u03b9\u03ac\u03be\u03bf\u03c5\u03bc\u03b5 executable \u03b3\u03b9\u03b1 \u03c4\u03bf maintenance \u03c4\u03c9\u03bd WAL:<\/p>\n\n\n\n
vi \/usr\/local\/bin\/clean_wal.sh<\/pre>\n\n\n\n
#!\/bin\/bash\n\nWAL_DIR=\"\/var\/lib\/postgresql\/archived_wal\"\n\n#retention 30 days\nfind \"$WAL_DIR\" -type f -mtime +30 -exec rm -f {} \\;<\/code><\/pre>\n\n\n\n
sudo chown postgres:postgres \/usr\/local\/bin\/clean_wal.sh\nsudo chmod +x \/usr\/local\/bin\/clean_wal.sh<\/pre>\n\n\n\n
\u0393\u03b9\u03b1 \u03bd\u03b1 \u03c4\u03b1 \u03c0\u03c1\u03bf\u03c3\u03b8\u03ad\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c3\u03c4\u03bf scheduler \u03c4\u03bf\u03c5 cronjob \u03c4\u03c1\u03ad\u03c7\u03bf\u03c5\u03bc\u03b5 \u03c4\u03bf \u03c0\u03b1\u03c1\u03b1\u03ba\u03ac\u03c4\u03c9:<\/p>\n\n\n\n
sudo -u postgres crontab -e<\/pre>\n\n\n\n
\u039c\u03b5 \u03c4\u03b9\u03c2 \u03c0\u03b1\u03c1\u03b1\u03ba\u03ac\u03c4\u03c9 \u03b3\u03c1\u03b1\u03bc\u03bc\u03ad\u03c2 \u03bf\u03c5\u03c3\u03b9\u03b1\u03c3\u03c4\u03b9\u03ba\u03ac \u03b8\u03b1 \u03b5\u03ba\u03c4\u03b5\u03bb\u03b5\u03c3\u03c4\u03bf\u03cd\u03bd \u03ba\u03ac\u03b8\u03b5 \u03bc\u03b5\u03c1\u03b1 \u03c3\u03c4\u03b9\u03c2 22:00 \u03ba\u03b1\u03b9 23:00 \u03b1\u03bd\u03c4\u03af\u03c3\u03c4\u03bf\u03b9\u03c7\u03b1:<\/p>\n\n\n\n
0 23 * * * \/usr\/local\/bin\/pg_full_backup.sh >\/dev\/null 2>&1\n0 22 * * * \/usr\/local\/bin\/clean_wal.sh >\/dev\/null 2>&1<\/code><\/pre>\n\n\n\n
<\/p>\n\n\n\n
Differential \/ Incremental backup?<\/h2>\n\n\n\n
\u0388\u03c9\u03c2 \u03c4\u03b7\u03bd PostgreSQL 17 \u03b4\u03b5\u03bd \u03c5\u03c0\u03ae\u03c1\u03c7\u03b5 \u03c4\u03c1\u03cc\u03c0\u03bf\u03c2 \u03b3\u03b9\u03b1 block level backup \u03bf\u03c0\u03cc\u03c4\u03b5 \u03b7 \u03bc\u03cc\u03bd\u03b7 native \u03bb\u03cd\u03c3\u03b7 \u03ae\u03c4\u03b1\u03bd \u03c4\u03bf full backup \u03ba\u03b1\u03b9 \u03ad\u03c0\u03b5\u03b9\u03c4\u03b1 \u03b7 \u03c7\u03c1\u03ae\u03c3\u03b7 \u03c4\u03c9\u03bd WAL, \u03c3\u03c4\u03b9\u03c2 \u03c0\u03b1\u03bb\u03b1\u03af\u03bf\u03c4\u03b5\u03c1\u03b5\u03c2 \u03b5\u03ba\u03b4\u03cc\u03c3\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03bc\u03c0\u03bf\u03c1\u03b5\u03af\u03c2 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03b9\u03c2 \u03c4\u03ad\u03c4\u03bf\u03b9\u03bf\u03c5 \u03c4\u03cd\u03c0\u03bf\u03c5 backup \u03b8\u03b1 \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03b9\u03c2 \u03c7\u03c1\u03ae\u03c3\u03b7 3rd party tools \u03cc\u03c0\u03c9\u03c2 \u03c4\u03c9\u03bd pgBackRest<\/strong> and Bartender<\/strong>.<\/p>\n\n\n\n
<\/p>\n\n\n\n
Sources:<\/h2>\n\n\n\n