[CentOS] LVM and Backups

[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 of the services, 4) mount the snapshot, 5) back up 
>>> the data, 6) remove the snapshot.
>>
>> About database setup I perform backups via pg_dump so how the snapshot 
>> affects pgsql database? What your suggestion I must perform database 
>> backup copying only filesystem file and not pgsql.sql database dump?
> 
> 
> If you want a plain-text dump of the DB, you can do that before the LVM 
> snapshot sequence: 1) pg_dump, 2) stop or freeze all of the services 
> (httpd and database), 3) make the snapshot, 4) start or thaw all of the 
> services, 5) mount the snapshot, 6) back up the data, 7) remove the 
> snapshot.
> 
> Typically, the reason you want to use snapshots for the backup is that 
> you don't need to do pg_dump to get a consistent DB backup, though. 
> pg_dump style backups are extremely slow to restore.  If you freeze the 
> DB, make a snapshot, and thaw, you can make a safe, consistent backup of 
> the DB files directly, and restore in minimal time.
> 
> 
>>> Are you using bacula's built-in snapshot support, or are you rolling 
>>> your own?
>>
>> No I'm using pre/post job script where I have lvm commands to create 
>> and destroy snapshot volume.
>>
> 
> I really recommend using a ready-made process rather than rolling your 
> own.  Bacula has snapshot support.  Alternately, my project can manage 
> snapshots and handle freezing / thawing PostgreSQL services.  I think 
> it's a better option than Bacula's, but either is better than 
> reinventing this wheel.
> 
> https://bitbucket.org/gordonmessmer/dragonsdawn-snapshot
> 
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org
> https://lists.centos.org/mailman/listinfo/centos

Thank you for the suggestion.

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?

I will give a try.

Thank you again for suggestions.