Greg Donald

Author, software maker, RC airplane enthusiast.

PostgreSQL Backup Script

March 28, 2021

#!/bin/sh DB_NAME=mydatabase DATE=`date +%Y%m%d%H%M%S` DIR=/backups/pgsql PG_DUMP=/usr/bin/pg_dump $PG_DUMP $DB_NAME | bzip2 > $DIR/$DB_NAME_$DATE.sql.bz2 find $DIR -mtime +7 -exec rm {} \;

Read More...

    Social

    −

    Other Stuff

    −

    Archives

    1. July 2026
    2. May 2026
    3. April 2026
    4. January 2026
    5. December 2025
    6. June 2025
    7. January 2025
    8. December 2024
    9. November 2024
    10. October 2024
    11. August 2024
    12. July 2024
    13. June 2024
    14. May 2024
    15. February 2024
    16. December 2023
    17. November 2023
    18. August 2023
    19. April 2023
    20. December 2022
    21. November 2022
    22. October 2022
    23. September 2021
    24. March 2021
    25. February 2021
    26. January 2021
    27. December 2020
    28. July 2020
    29. June 2020
    30. May 2020
    31. January 2020
    32. December 2019
    33. November 2019
    34. October 2019
    35. August 2019
    36. July 2019
    37. May 2019
    38. March 2019
    39. January 2019
    40. December 2018
    41. March 2018
    42. January 2018
    43. April 2017
    44. January 2017
    45. November 2016
    46. October 2016
    47. August 2016
    48. January 2016
    49. September 2015
    50. June 2015
    51. April 2015
    52. January 2015
    53. September 2014
    54. January 2014
    55. May 2012
    56. April 2012
    57. January 2012
    58. April 2011
    59. January 2010
    60. January 2006