Automate database backups for knowii.net

[dsebastien]

Options

• upgrade Laravel forge subscription

• https://github.com/spatie/laravel-backup

• https://pgbackrest.org/

• https://packagist.org/packages/spatie/laravel-backup

  • documentation: https://spatie.be/docs/laravel-backup/v8/introduction

• [ ] define backup location

• [ ] schedule backups

• [ ] document process and locations

[dsebastien]

Output from trying to install using composer require spatie/laravel-backup:

  Problem 1
    - spatie/laravel-backup[0.0.1, 1.0.0, ..., 1.2.0, 2.0.0, ..., 2.9.1] require illuminate/support 5.* -> found illuminate/support[v5.0.0, ..., v5.8.36] but these were not loaded, likely because it conflicts with another require.
    - spatie/laravel-backup[2.9.2, ..., 2.10.0] require php ^5.4.0|^7.0 -> your php version (8.3.11) does not satisfy that requirement.
    - spatie/laravel-backup[3.0.0, ..., 3.11.0] require php ^5.5|^7.0 -> your php version (8.3.11) does not satisfy that requirement.
    - spatie/laravel-backup[4.0.0, ..., 4.19.2, 5.0.0, ..., 5.6.5] require php ^7.0 -> your php version (8.3.11) does not satisfy that requirement.
    - spatie/laravel-backup[5.6.6, ..., 5.12.1] require php ^7.1 -> your php version (8.3.11) does not satisfy that requirement.
    - spatie/laravel-backup[6.0.0, ..., 6.11.1] require php ^7.2 -> your php version (8.3.11) does not satisfy that requirement.
    - spatie/laravel-backup[6.11.2, ..., 6.12.0] require php ^7.3 -> your php version (8.3.11) does not satisfy that requirement.
    - spatie/laravel-backup[6.13.0, ..., 6.14.4] require illuminate/console ^6.0|^7.0|^8.0 -> found illuminate/console[v6.0.0, ..., v6.20.44, v7.0.0, ..., v7.30.6, v8.0.0, ..., v8.83.27] but these were not loaded, likely because it conflicts with another require.
    - spatie/laravel-backup[6.6.13, ..., 6.16.5, 7.3.0, ..., 7.8.0, 8.0.0, ..., 8.8.2, 9.0.0, ..., 9.0.4] require ext-zip ^1.14.0 -> it is missing from your system. Install or enable PHP's zip extension.
    - spatie/laravel-backup[7.0.0, ..., 7.2.1] require ext-zip * -> it is missing from your system. Install or enable PHP's zip extension.
    - Root composer.json requires spatie/laravel-backup * -> satisfiable by spatie/laravel-backup[0.0.1, 1.0.0, 1.1.0, 1.2.0, 2.0.0, ..., 2.10.0, 3.0.0, ..., 3.11.0, 4.0.0, ..., 4.19.2, 5.0.0, ..., 5.12.1, 6.0.0, ..., 6.16.5, 7.0.0, ..., 7.8.0, 8.0.0, ..., 8.8.2, 9.0.0, ..., 9.0.4].

[dsebastien]

Apparently need to enable PHP's zip extension

[dsebastien]

Needed to enable the extension in php.ini

Uncommented extension=zip in php cli php.ini file Located it using php ini

Edited it using sudo nano /etc/php/8.3/cli/php.ini

Installed the required packages using sudo apt install libzip-dev php-zip

[dsebastien]

Need to configure scheduling in production and document it: https://spatie.be/docs/laravel-backup/v8/installation-and-setup#content-scheduling

[dsebastien]

Need to setup monitoring in production and document it: https://spatie.be/docs/laravel-backup/v8/monitoring-the-health-of-all-backups/overview