3
How to take backup PosgreSQL using pg_dump with crontab in Linux?
source link: https://gist.github.com/linuxkathirvel/90771e9d658195fa59e0f0b921f7e22e
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
How to take backup PosgreSQL using pg_dump with crontab in Linux?
How to take backup PosgreSQL using pg_dump with crontab in Linux?
Find the pg_hba.conf file
sudo su - postgres
psql
SHOW hba_file;
Change the method to 'trust' and save the file
sudo vim /etc/postgresql/11/main/pg_hba.conf
local all postgres trust
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
Restart the PostgreSQL service after the above changes
sudo systemctl restart postgresql
Make shell script to take the backup. I gave the filename as /data/postgresql-backup.sh.
#!/bin/bash
BACKUP_DIR="/data/psql-db-backup/"
FILE_NAME=$BACKUP_DIR`date +%d-%m-%Y-%I-%M-%S-%p`.sql
pg_dump -U db_user db_name > $FILE_NAME
Make the script as executable
chmod a+x /data/postgresql-backup.sh
Crontab entry
sudo crontab -e
# Add below content in the crontab. It will take the backup for every 3-hours
# PostgreSQL backup
0 */3 * * * /data/postgresql-backup.sh
References
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK