hemant15gr

hemant15gr / backup-postgres

Created June 6, 2022 06:46 — forked from axs-mvd/backup-postgres

	#!/bin/bash

	###############################################################################
	# This script creates a dump of a list of databases, so it should run with
	# a user that has access to all databases, postgres for example.
	###############################################################################

	CURRENT_DATE=$(date +"%Y%m%d-%H:%M")
	BACKUPS_DIRECTORY=/var/lib/pgsql/data/backups/$CURRENT_DATE

hemant15gr / postgres-backup.sh

Created June 6, 2022 06:45 — forked from 4410287/postgres-backup.sh

Shell script for daily postgres database backup with basic archiving.

	#!/bin/bash

	# Written 2018-11-15 by 4410287
	# This script will create a backup file of a postgres database and compress it. It is capable of access a local or remote server to pull the backup. After creating a new backup, it will delete backups that are older than 15 days, with the exception of backups created the first of every month. It is recommended to create a seperate database user specifically for backup purposes, and to set the permissions of this script to prevent access to the login details. Backup scripts for different databases should be run in seperate folders or they will overwrite each other.

	HOSTNAME=
	USERNAME=
	PASSWORD=
	DATABASE=

hemant15gr / Coverage Badges

Created June 1, 2022 05:58

Coverage Badges