Re: [CentOS] LVM and Backups

2018-09-21 Thread Gordon Messmer
On 9/18/18 11:55 PM, Alessandro Baggi wrote: I don't know why I considered pg_dump better then filesystem backup. At this moment I prefer pg_dump because in this mode I can restore data on different version of postgresql. With filesystem dump I can restore only for a specific version. Is right?

Re: [CentOS] LVM and Backups

2018-09-18 Thread Alessandro Baggi
Il 18/09/2018 17:14, Gordon Messmer ha scritto: On 9/17/18 11:38 PM, Alessandro Baggi wrote: Il 17/09/2018 22:12, Gordon Messmer ha scritto: That doesn't look right.  It should look more like 1) stop or freeze all of the services (httpd and database), 2) make the snapshot, 3) start or thaw all

Re: [CentOS] LVM and Backups

2018-09-18 Thread Gordon Messmer
On 9/17/18 11:38 PM, Alessandro Baggi wrote: Il 17/09/2018 22:12, Gordon Messmer ha scritto: That doesn't look right.  It should look more like 1) stop or freeze all of the services (httpd and database), 2) make the snapshot, 3) start or thaw all of the services, 4) mount the snapshot, 5) back

Re: [CentOS] LVM and Backups

2018-09-17 Thread Alessandro Baggi
Il 17/09/2018 22:12, Gordon Messmer ha scritto: On 9/17/18 7:50 AM, Alessandro Baggi wrote: Running a backup I follow this steps: 1) Stop httpd 2) Create lvm snapshot on the dataset 3) Backup database 4) restart httpd (to avoid more downtime) 5) mount the snapshot and execute backup 6) umount a

Re: [CentOS] LVM and Backups

2018-09-17 Thread Gordon Messmer
On 9/17/18 7:50 AM, Alessandro Baggi wrote: Running a backup I follow this steps: 1) Stop httpd 2) Create lvm snapshot on the dataset 3) Backup database 4) restart httpd (to avoid more downtime) 5) mount the snapshot and execute backup 6) umount and remove the snapshot I think that this could

[CentOS] LVM and Backups

2018-09-17 Thread Alessandro Baggi
Hey there, I'm testing LVM snapshot to make backups and I've some questions about snapshot lvm. In my test case I have httpd, postgresql db and a dataset on a VM. Running a backup I follow this steps: 1) Stop httpd 2) Create lvm snapshot on the dataset 3) Backup database 4) restart httpd (to