[{"_1":2,"_153":-5,"_154":-5},"loaderData",{"_3":4,"_13":14,"_21":22,"_132":133},"root",{"_5":-5,"_6":-7,"_7":8,"_9":-7,"_10":11,"_12":-7},"currentUser","primaryEmail","siteVerification","6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI","toast","enableDev",false,"incidentStatus","routes/_layout",{"_15":-5,"_16":17,"_18":17,"_19":11,"_20":11},"username","isAskGordonEnabled",true,"isUsingNewTemplate","showMinimalLanding","showHoneypotTrap","routes/_layout.r.$namespace.$reponame",{"_23":24,"_25":-5,"_26":11,"_27":11,"_28":29,"_30":31,"_32":-5,"_33":11,"_34":35,"_84":-5,"_85":86,"_125":-5,"_126":11,"_127":17,"_128":11,"_129":-5,"_130":131},"canonicalUrl","https://hub.docker.com/r/ilaverlin/pg-az-backup/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","ilaverlin","reponame","pg-az-backup","cloudBuildSource","isAutobuildsAvailable","repo",{"_36":37,"_38":39,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":51,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":29,"_69":70,"_75":11,"_76":77,"_81":29,"_82":83},"categories",[],"content_types",[40],"image","date_registered","2020-03-11T15:49:15.564681Z","description","Backup Postgres database to Azure BLOB storage and restore that database from the BLOB.","is_private","last_updated","2022-11-11T15:21:41.697327Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[52],"application/vnd.docker.container.image.v1+json","name","pull_count",5951,"repository_type","star_count",0,"status",1,"status_description","active","source","collaborator_count","full_description","# PG-AZ-Backup\n\n[![Build Status](https://img.shields.io/docker/cloud/build/ilaverlin/pg-az-backup)](https://hub.docker.com/repository/docker/ilaverlin/pg-backup) ![Image Size](https://img.shields.io/docker/image-size/ilaverlin/pg-az-backup/latest)\n\nThe tool in the form of a Docker container to easily backup specified Postgres database to Azure BLOB storage and restore that database from the BLOB. Periodic backup is also supported.\n\n## Usage\nBefore upload the backup to the azure container you'll need to [Create an Azure Storage account](https://docs.microsoft.com/en-us/azure/storage/common/storage-account-create?tabs=azure-portal) and get [SAS token](https://docs.microsoft.com/en-us/azure/storage/common/storage-sas-overview).\n\n#### Backup database\n```\ndocker run \\\n -e POSTGRES_HOST= \\\n -e POSTGRES_USER= \\\n -e POSTGRES_PASSWORD= \\\n -e POSTGRES_DATABASE= \\\n -e AZURE_STORAGE_ACCOUNT= \\\n -e AZURE_SAS= \\\n -e AZURE_CONTAINER_NAME= \\\n --rm \\\n ilaverlin/pg-az-backup\n```\nAlso, you may pass additional backup parameters by setting an environment variable `POSTGRES_EXTRA_OPTS`. \n\n#### Automatic periodic backup\nTo schedule a periodic backup you'll need to pass `SCHEDULE` environment variable that should contain cron job schedule syntax, e. g. `-e SCHEDULE=\"@daily\"` or `-e SCHEDULE = \"0 0 * * 0\"` (weekly).
\nDo not forget to add `-d` switch to **docker run** command to keep the container running. \n```\ndocker run \\\n -e POSTGRES_HOST= \\\n -e POSTGRES_USER= \\\n -e POSTGRES_PASSWORD= \\\n -e POSTGRES_DATABASE= \\\n -e AZURE_STORAGE_ACCOUNT= \\\n -e AZURE_SAS= \\\n -e AZURE_CONTAINER_NAME= \\\n -e SCHEDULE= \\\n -d --name pg-scheduled-backup \\\n ilaverlin/pg-az-backup\n```\n#### Restore database\nTo restore database you'll need to set environment variable `RESTORE` to 'yes' e. g. `-e RESTORE=\"yes\"`.
\nIf the target database contains data, you might want to specify `DROP_PUBLIC=\"yes\"`, that will drop the public schema. In case of an empty target database you can omit this variable.
\nBy default the last backup will be restored. If you need to restore specified backup you can set `AZURE_BLOB_NAME` environment variable with backp file name e.g. `-e AZURE_BLOB_NAME=\"_2020-03-11T14:08:28Z.sql.gz\"`.\n```\ndocker run \\\n -e POSTGRES_HOST= \\\n -e POSTGRES_USER= \\\n -e POSTGRES_PASSWORD= \\\n -e POSTGRES_DATABASE= \\\n -e AZURE_STORAGE_ACCOUNT= \\\n -e AZURE_SAS= \\\n -e AZURE_CONTAINER_NAME= \\\n -e RESTORE=yes \\\n -e DROP_PUBLIC=yes \\\n --rm \\\n ilaverlin/pg-az-backup\n```\n","has_starred","hub_user","immutable_tags_settings",{"_71":11,"_72":73},"enabled","rules",[74],".*","is_automated","permissions",{"_78":17,"_79":11,"_80":11},"read","write","admin","user","storage_size",274180883,"orgData","recentTags",[87],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":96,"_97":98,"_46":114,"_115":90,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":62,"_124":17},"content_type","creator",7767025,"digest","sha256:73978af7a6afd9d568f3eb2f8b6118180a0834f4567ea507ef382d87596ba4b1","full_size",91110804,"id",90201862,"images",[99],{"_100":101,"_91":92,"_102":103,"_104":105,"_106":107,"_108":109,"_110":103,"_111":-5,"_112":94,"_59":62,"_113":-5},"architecture","amd64","features","","last_pulled","2026-09-19T03:01:39.743957466Z","last_pushed","2022-11-11T15:21:42Z","os","linux","os_features","os_version","size","variant","2022-11-11T15:21:41.573245Z","last_updater","last_updater_username","media_type","latest","repository",8631355,"tag_last_pulled","tag_last_pushed","tag_status","v2","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"routes/_layout.r.$namespace.$reponame.tags",{"_34":134,"_141":142,"_130":151,"_152":11},{"_36":135,"_38":136,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":137,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":29,"_69":138,"_75":11,"_76":140,"_81":29,"_82":83},[],[40],[52],{"_71":11,"_72":139},[74],{"_78":17,"_79":11,"_80":11},"tags",{"_143":60,"_144":-5,"_145":-5,"_146":147},"count","next","previous","results",[148],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":96,"_97":149,"_46":114,"_115":90,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":62,"_124":17},[150],{"_100":101,"_91":92,"_102":103,"_104":105,"_106":107,"_108":109,"_110":103,"_111":-5,"_112":94,"_59":62,"_113":-5},[],"canDeleteTags","actionData","errors"]

ilaverlin/pg-az-backup

Tags for ilaverlin/pg-az-backup