Postgresql - Automatic Backup (.sql, .custom) with Cronjob in Centos 7

Channel:
Ambar Hasbiyatmoko
Subscribers:
4,970
Published on ● Video Link: https://www.youtube.com/watch?v=i4XeOYmc3Ic


Duration: 15:12
12,732 views
40

In this video i will show you how to backup postgresql database automatically with cronjob in Centos 7.

step :
1) install pgadmin3
2) create .sh script
3) define .sh in /etc/crontab
4) disable selinux
5) restart your Centos 7
6) .sql will be created.

see this video for details



Other Videos By Ambar Hasbiyatmoko


2017-12-24[Solved] wordpress can't update plugins - need to access your web server. Please enter your FTP.
2017-12-15How to solve - Unable to create runtime.BootstrapApplication in Android Studio
2017-12-09Fix Android Studio - Failed to resolve com.google.android.gms:play services maps:11
2017-12-03How to install moodle 3.4 on Ubuntu 16.04
2017-12-02How to install apache, php, mysql & phpmyadmin on Ubuntu 16.04
2017-11-27Laravel 5.4 - How to upload file with laravel [part 6]
2017-11-26Sending mail from own domain with PHPMailer 5.2
2017-11-06Laravel 5.4 - How to using validation in laravel [part 5]
2017-10-28Laravel 5.4 Tutorial - How to using bootstrap v4 beta in laravel framework [part 4]
2017-10-26Laravel 5.4 error - The stream or file 'laravel.log' could not be .... Permission denied
2017-10-05Postgresql - Automatic Backup (.sql, .custom) with Cronjob in Centos 7
2017-09-23How to solve Ruby 2.4 : Failed to load libmysql.dll
2017-09-21How to solve : select2 jquery not work after clone
2017-09-21How to Install golang (go1.9) on Ubuntu 16.04
2017-09-03How to solve postgresql ERROR: cannot cast type time without timezone to date
2017-08-27Solve Apache (a2ensite) - ERROR: Site squirrelmail does not exist!
2017-08-26Solve ubuntu error - E: Package 'dovecot' has no installation candidate
2017-08-26Solve ubuntu error - dpkg was interrupted, you must manually run 'sudo dpkg --configure -a'
2017-08-19Mysql error - this is incompatible with sql_mode=only_full_group_by
2017-08-17Codeigniter(PHP) Error - mysqli: Headers and client library minor version mismatch.
2017-08-13Ubuntu server error - RTNETLINK answers: File exists, Failed to bring up enp0s8


Tags:
postgresql
backup
automatic
database
linux
centos 7
terminal
script
selinux
sql
pgadmin3
cronjob
crontab