backup_restore.md 45.6 KB
Newer Older
1
# Back up and restore GitLab **(CORE ONLY)**
M
Marin Jankovski 已提交
2

3
GitLab provides Rake tasks for backing up and restoring GitLab instances.
4

5 6
An application data backup creates an archive file that contains the database,
all repositories and all attachments.
7

8 9
You can only restore a backup to **exactly the same version and type (CE/EE)**
of GitLab on which it was created. The best way to migrate your repositories
10
from one server to another is through backup restore.
11

12 13 14 15 16
CAUTION: **Warning:**
GitLab will not backup items that are not stored on the
filesystem. If using [object storage](../administration/object_storage.md),
remember to enable backups with your object storage provider if desired.

17
## Requirements
18

19
In order to be able to backup and restore, you need one essential tool
20
installed on your system.
21

22 23 24
- **Rsync**: If you installed GitLab:
  - Using the Omnibus package, you're all set.
  - From source, make sure `rsync` is installed. For example:
25

26 27 28
    ```shell
    # Debian/Ubuntu
    sudo apt-get install rsync
29

30 31 32
    # RHEL/CentOS
    sudo yum install rsync
    ```
33

34
## Backup timestamp
35

36
NOTE: **Note:**
37
In GitLab 9.2 the timestamp format was changed from `EPOCH_YYYY_MM_DD` to
38 39
`EPOCH_YYYY_MM_DD_GitLab_version`, for example `1493107454_2018_04_25`
would become `1493107454_2018_04_25_10.6.4-ce`.
40 41 42 43 44 45 46 47

The backup archive will be saved in `backup_path`, which is specified in the
`config/gitlab.yml` file.
The filename will be `[TIMESTAMP]_gitlab_backup.tar`, where `TIMESTAMP`
identifies the time at which each backup was created, plus the GitLab version.
The timestamp is needed if you need to restore GitLab and multiple backups are
available.

48 49
For example, if the backup name is `1493107454_2018_04_25_10.6.4-ce_gitlab_backup.tar`,
then the timestamp is `1493107454_2018_04_25_10.6.4-ce`.
50

51
## Back up GitLab
52

53
GitLab provides a simple command line interface to back up your whole instance.
54 55 56 57 58 59 60 61 62 63 64 65 66 67
It backs up your:

- Database
- Attachments
- Git repositories data
- CI/CD job output logs
- CI/CD job artifacts
- LFS objects
- Container Registry images
- GitLab Pages content

CAUTION: **Warning:**
GitLab does not back up any configuration files, SSL certificates, or system files.
You are highly advised to [read about storing configuration files](#storing-configuration-files).
68

69
Use this command if you've installed GitLab with the Omnibus package:
70

71
```shell
72
sudo gitlab-backup create
73
```
74

75
NOTE: **Note:**
76 77
For GitLab 12.1 and earlier, use `gitlab-rake gitlab:backup:create`.

78
Use this if you've installed GitLab from source:
79

80
```shell
B
Ben Bodenmiller 已提交
81
sudo -u git -H bundle exec rake gitlab:backup:create RAILS_ENV=production
82
```
83

84
If you are running GitLab within a Docker container, you can run the backup from the host:
85

86
```shell
87
docker exec -t <container name> gitlab-backup create
88
```
89

90
NOTE: **Note:**
91 92
For GitLab 12.1 and earlier, use `gitlab-rake gitlab:backup:create`.

93
If you are using the [GitLab Helm chart](https://gitlab.com/gitlab-org/charts/gitlab) on a
94
Kubernetes cluster, you can run the backup task using `backup-utility` script on
95
the GitLab task runner pod via `kubectl`. Refer to [backing up a GitLab installation](https://gitlab.com/gitlab-org/charts/gitlab/blob/master/doc/backup-restore/backup.md#backing-up-a-gitlab-installation) for more details:
96

97
```shell
98
kubectl exec -it <gitlab task-runner pod> backup-utility
99 100
```

101 102 103
Similarly to the Kubernetes case, if you have scaled out your GitLab
cluster to use multiple application servers, you should pick a
designated node (that won't be auto-scaled away) for running the
104
backup Rake task. Because the backup Rake task is tightly coupled to
105 106 107
the main Rails application, this is typically a node on which you're
also running Unicorn/Puma and/or Sidekiq.

108 109
Example output:

110
```plaintext
111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136
Dumping database tables:
- Dumping table events... [DONE]
- Dumping table issues... [DONE]
- Dumping table keys... [DONE]
- Dumping table merge_requests... [DONE]
- Dumping table milestones... [DONE]
- Dumping table namespaces... [DONE]
- Dumping table notes... [DONE]
- Dumping table projects... [DONE]
- Dumping table protected_branches... [DONE]
- Dumping table schema_migrations... [DONE]
- Dumping table services... [DONE]
- Dumping table snippets... [DONE]
- Dumping table taggings... [DONE]
- Dumping table tags... [DONE]
- Dumping table users... [DONE]
- Dumping table users_projects... [DONE]
- Dumping table web_hooks... [DONE]
- Dumping table wikis... [DONE]
Dumping repositories:
- Dumping repository abcd... [DONE]
Creating backup archive: $TIMESTAMP_gitlab_backup.tar [DONE]
Deleting tmp directories...[DONE]
Deleting old backups... [SKIPPING]
```

137
### Storing configuration files
138

139
The [backup Rake task](#back-up-gitlab) GitLab provides
140 141
does **not** store your configuration files. The primary reason for this is that your
database contains encrypted information for two-factor authentication, the CI/CD
142
'secure variables', and so on. Storing encrypted information along with its key in the
143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164
same place defeats the purpose of using encryption in the first place.

CAUTION: **Warning:**
The secrets file is essential to preserve your database encryption key.

At the very **minimum**, you must backup:

For Omnibus:

- `/etc/gitlab/gitlab-secrets.json`
- `/etc/gitlab/gitlab.rb`

For installation from source:

- `/home/git/gitlab/config/secrets.yml`
- `/home/git/gitlab/config/gitlab.yml`

For [Docker installations](https://docs.gitlab.com/omnibus/docker/), you must
back up the volume where the configuration files are stored. If you have created
the GitLab container according to the documentation, it should be under
`/srv/gitlab/config`.

165
For [GitLab Helm chart Installations](https://gitlab.com/gitlab-org/charts/gitlab) on a
166
Kubernetes cluster, you must follow the [Backup the secrets](https://docs.gitlab.com/charts/backup-restore/backup.html#backup-the-secrets) instructions.
167

168 169 170 171 172 173 174 175 176
You may also want to back up any TLS keys and certificates, and your
[SSH host keys](https://superuser.com/questions/532040/copy-ssh-keys-from-one-server-to-another-server/532079#532079).

If you use Omnibus GitLab, see some additional information
[to backup your configuration](https://docs.gitlab.com/omnibus/settings/backups.html).

In the unlikely event that the secrets file is lost, see the
[troubleshooting section](#when-the-secrets-file-is-lost).

177
### Backup options
178 179 180

The command line tool GitLab provides to backup your instance can take more options.

181
#### Backup strategy option
182

183
> [Introduced](https://gitlab.com/gitlab-org/gitlab-foss/-/merge_requests/8728) in GitLab 8.17.
184 185 186 187 188 189 190 191 192 193

The default backup strategy is to essentially stream data from the respective
data locations to the backup using the Linux command `tar` and `gzip`. This works
fine in most cases, but can cause problems when data is rapidly changing.

When data changes while `tar` is reading it, the error `file changed as we read
it` may occur, and will cause the backup process to fail. To combat this, 8.17
introduces a new backup strategy called `copy`. The strategy copies data files
to a temporary location before calling `tar` and `gzip`, avoiding the error.

D
Dan Hahne 已提交
194
A side-effect is that the backup process will take up to an additional 1X disk
195 196 197 198 199
space. The process does its best to clean up the temporary files at each stage
so the problem doesn't compound, but it could be a considerable change for large
installations. This is why the `copy` strategy is not the default in 8.17.

To use the `copy` strategy instead of the default streaming strategy, specify
200 201
`STRATEGY=copy` in the Rake task command. For example:

202
```shell
203
sudo gitlab-backup create STRATEGY=copy
204
```
205

206
NOTE: **Note:**
207 208
For GitLab 12.1 and earlier, use `gitlab-rake gitlab:backup:create`.

209 210 211 212 213
#### Backup filename

CAUTION: **Warning:**
If you use a custom backup filename, you will not be able to
[limit the lifetime of the backups](#limit-backup-lifetime-for-local-files-prune-old-backups).
214 215 216

By default a backup file is created according to the specification in [the Backup timestamp](#backup-timestamp) section above. You can however override the `[TIMESTAMP]` part of the filename by setting the `BACKUP` environment variable. For example:

217
```shell
218
sudo gitlab-backup create BACKUP=dump
219 220
```

221
NOTE: **Note:**
222 223
For GitLab 12.1 and earlier, use `gitlab-rake gitlab:backup:create`.

224 225
The resulting file will then be `dump_gitlab_backup.tar`. This is useful for systems that make use of rsync and incremental backups, and will result in considerably faster transfer speeds.

226
#### Rsyncable
227

228 229 230
To make sure the generated archive is intelligently transferable by rsync, the `GZIP_RSYNCABLE=yes` option can be set. This will set the `--rsyncable` option to `gzip`. This is only useful in combination with setting [the Backup filename option](#backup-filename).

Note that the `--rsyncable` option in `gzip` is not guaranteed to be available on all distributions. To verify that it is available in your distribution you can run `gzip --help` or consult the man pages.
231

232
```shell
233
sudo gitlab-backup create BACKUP=dump GZIP_RSYNCABLE=yes
234
```
235

236
NOTE: **Note:**
237 238
For GitLab 12.1 and earlier, use `gitlab-rake gitlab:backup:create`.

239
#### Excluding specific directories from the backup
240

241
You can choose what should be exempt from the backup up by adding the environment variable `SKIP`.
242 243
The available options are:

244 245 246 247 248 249 250 251
- `db` (database)
- `uploads` (attachments)
- `repositories` (Git repositories data)
- `builds` (CI job output logs)
- `artifacts` (CI job artifacts)
- `lfs` (LFS objects)
- `registry` (Container Registry images)
- `pages` (Pages content)
252 253 254

Use a comma to specify several options at the same time:

255 256 257
All wikis will be backed up as part of the `repositories` group. Non-existent wikis
will be skipped during a backup.

258 259
For Omnibus GitLab packages:

260
```shell
261
sudo gitlab-backup create SKIP=db,uploads
262 263
```

264
NOTE: **Note:**
265 266
For GitLab 12.1 and earlier, use `gitlab-rake gitlab:backup:create`.

267
For installations from source:
268

269
```shell
270 271 272
sudo -u git -H bundle exec rake gitlab:backup:create SKIP=db,uploads RAILS_ENV=production
```

273
#### Skipping tar creation
274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297

The last part of creating a backup is generation of a `.tar` file containing
all the parts. In some cases (for example, if the backup is picked up by other
backup software) creating a `.tar` file might be wasted effort or even directly
harmful, so you can skip this step by adding `tar` to the `SKIP` environment
variable.

Adding `tar` to the `SKIP` variable leaves the files and directories containing the
backup in the directory used for the intermediate files. These files will be
overwritten when a new backup is created, so you should make sure they are copied
elsewhere, because you can only have one backup on the system.

For Omnibus GitLab packages:

```shell
sudo gitlab-backup create SKIP=tar
```

For installations from source:

```shell
sudo -u git -H bundle exec rake gitlab:backup:create SKIP=tar RAILS_ENV=production
```

298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315
#### Disabling prompts during restore

During a restore from backup, the restore script may ask for confirmation before
proceeding. If you wish to disable these prompts, you can set the `GITLAB_ASSUME_YES`
environment variable to `1`.

For Omnibus GitLab packages:

```shell
sudo GITLAB_ASSUME_YES=1 gitlab-backup restore
```

For installations from source:

```shell
sudo -u git -H GITLAB_ASSUME_YES=1 bundle exec rake gitlab:backup:restore RAILS_ENV=production
```

316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339
#### Back up Git repositories concurrently

> [Introduced](https://gitlab.com/gitlab-org/gitlab/-/merge_requests/37158) in GitLab 13.3.

Repositories can be backed up concurrently to help fully utilise CPU time. The following variables
are available to modify the default behavior of the Rake task:

- `GITLAB_BACKUP_MAX_CONCURRENCY` sets the maximum number of projects to backup at the same time.
  Defaults to 1.
- `GITLAB_BACKUP_MAX_STORAGE_CONCURRENCY` sets the maximum number of projects to backup at the same time on each storage. This allows the repository backups to be spread across storages.
  Defaults to 1.

For example, for Omnibus GitLab installations:

```shell
sudo gitlab-backup create GITLAB_BACKUP_MAX_CONCURRENCY=4 GITLAB_BACKUP_MAX_STORAGE_CONCURRENCY=1
```

For example, for installations from source:

```shell
sudo -u git -H bundle exec rake gitlab:backup:create GITLAB_BACKUP_MAX_CONCURRENCY=4 GITLAB_BACKUP_MAX_STORAGE_CONCURRENCY=1
```

340
#### Uploading backups to a remote (cloud) storage
341

342
Starting with GitLab 7.4 you can let the backup script upload the `.tar` file it creates.
343
It uses the [Fog library](http://fog.io/) to perform the upload.
344 345
In the example below we use Amazon S3 for storage, but Fog also lets you use
[other storage providers](http://fog.io/storage/). GitLab
346
[imports cloud drivers](https://gitlab.com/gitlab-org/gitlab/blob/30f5b9a5b711b46f1065baf755e413ceced5646b/Gemfile#L88)
347
for AWS, Google, OpenStack Swift, Rackspace, and Aliyun as well. A local driver is
348
[also available](#uploading-to-locally-mounted-shares).
349

350 351
[Read more about using object storage with GitLab](../administration/object_storage.md).

352
##### Using Amazon S3
353

354 355 356 357
For Omnibus GitLab packages:

1. Add the following to `/etc/gitlab/gitlab.rb`:

358 359 360 361 362 363 364 365 366 367 368
   ```ruby
   gitlab_rails['backup_upload_connection'] = {
     'provider' => 'AWS',
     'region' => 'eu-west-1',
     'aws_access_key_id' => 'AKIAKIAKI',
     'aws_secret_access_key' => 'secret123'
     # If using an IAM Profile, don't configure aws_access_key_id & aws_secret_access_key
     # 'use_iam_profile' => true
   }
   gitlab_rails['backup_upload_remote_directory'] = 'my.s3.bucket'
   ```
369

370
1. [Reconfigure GitLab](../administration/restart_gitlab.md#omnibus-gitlab-reconfigure) for the changes to take effect
371

372
##### Digital Ocean Spaces
373

374
This example can be used for a bucket in Amsterdam (AMS3).
375

376
1. Add the following to `/etc/gitlab/gitlab.rb`:
377

378 379 380 381 382 383 384 385 386 387
   ```ruby
   gitlab_rails['backup_upload_connection'] = {
     'provider' => 'AWS',
     'region' => 'ams3',
     'aws_access_key_id' => 'AKIAKIAKI',
     'aws_secret_access_key' => 'secret123',
     'endpoint'              => 'https://ams3.digitaloceanspaces.com'
   }
   gitlab_rails['backup_upload_remote_directory'] = 'my.s3.bucket'
   ```
388

389
1. [Reconfigure GitLab](../administration/restart_gitlab.md#omnibus-gitlab-reconfigure) for the changes to take effect
390

391
NOTE: **Note:**
392 393 394 395 396
If you see `400 Bad Request` by using Digital Ocean Spaces, the cause may be the
usage of backup encryption. Remove or comment the line that
contains `gitlab_rails['backup_encryption']` since Digital Ocean Spaces
doesn't support encryption.

397
##### Other S3 Providers
398 399 400 401 402 403

Not all S3 providers are fully-compatible with the Fog library. For example,
if you see `411 Length Required` errors after attempting to upload, you may
need to downgrade the `aws_signature_version` value from the default value to
2 [due to this issue](https://github.com/fog/fog-aws/issues/428).

404 405
For installations from source:

406 407
1. Edit `home/git/gitlab/config/gitlab.yml`:

408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425
   ```yaml
     backup:
       # snip
       upload:
         # Fog storage connection settings, see http://fog.io/storage/ .
         connection:
           provider: AWS
           region: eu-west-1
           aws_access_key_id: AKIAKIAKI
           aws_secret_access_key: 'secret123'
           # If using an IAM Profile, leave aws_access_key_id & aws_secret_access_key empty
           # ie. aws_access_key_id: ''
           # use_iam_profile: 'true'
         # The remote 'directory' to store your backups. For S3, this would be the bucket name.
         remote_directory: 'my.s3.bucket'
         # Turns on AWS Server-Side Encryption with Amazon S3-Managed Keys for backups, this is optional
         # encryption: 'AES256'
         # Turns on AWS Server-Side Encryption with Amazon Customer-Provided Encryption Keys for backups, this is optional
426
         #   This should be set to the encryption key for Amazon S3 to use to encrypt or decrypt your data.
427 428
         #   'encryption' must also be set in order for this to have any effect.
         #   To avoid storing the key on disk, the key can also be specified via the `GITLAB_BACKUP_ENCRYPTION_KEY` environment variable.
429
         # encryption_key: '<key>'
430 431 432
         # Specifies Amazon S3 storage class to use for backups, this is optional
         # storage_class: 'STANDARD'
   ```
433

434
1. [Restart GitLab](../administration/restart_gitlab.md#installations-from-source) for the changes to take effect
435 436 437

If you are uploading your backups to S3 you will probably want to create a new
IAM user with restricted access rights. To give the upload user access only for
438
uploading backups create the following IAM profile, replacing `my.s3.bucket`
439 440 441 442
with the name of your bucket:

```json
{
443
  "Version": "2012-10-17",
444 445
  "Statement": [
    {
446
      "Sid": "Stmt1412062044000",
447 448 449 450 451 452 453
      "Effect": "Allow",
      "Action": [
        "s3:AbortMultipartUpload",
        "s3:GetBucketAcl",
        "s3:GetBucketLocation",
        "s3:GetObject",
        "s3:GetObjectAcl",
454
        "s3:ListBucketMultipartUploads",
455 456 457 458 459 460
        "s3:PutObject",
        "s3:PutObjectAcl"
      ],
      "Resource": [
        "arn:aws:s3:::my.s3.bucket/*"
      ]
461
    },
462
    {
463
      "Sid": "Stmt1412062097000",
464 465
      "Effect": "Allow",
      "Action": [
466 467
        "s3:GetBucketLocation",
        "s3:ListAllMyBuckets"
468 469 470 471
      ],
      "Resource": [
        "*"
      ]
472
    },
473
    {
474
      "Sid": "Stmt1412062128000",
475 476 477 478 479 480 481 482 483 484 485 486
      "Effect": "Allow",
      "Action": [
        "s3:ListBucket"
      ],
      "Resource": [
        "arn:aws:s3:::my.s3.bucket"
      ]
    }
  ]
}
```

487
##### Using Google Cloud Storage
488 489 490 491

If you want to use Google Cloud Storage to save backups, you'll have to create
an access key from the Google console first:

492
1. Go to the storage settings page <https://console.cloud.google.com/storage/settings>
493 494 495
1. Select "Interoperability" and create an access key
1. Make note of the "Access Key" and "Secret" and replace them in the
   configurations below
496
1. In the buckets advanced settings ensure the Access Control option "Set object-level
497
   and bucket-level permissions" is selected
498 499 500 501 502 503
1. Make sure you already have a bucket created

For Omnibus GitLab packages:

1. Edit `/etc/gitlab/gitlab.rb`:

504 505 506 507
   ```ruby
   gitlab_rails['backup_upload_connection'] = {
     'provider' => 'Google',
     'google_storage_access_key_id' => 'Access Key',
508 509 510 511 512 513 514
     'google_storage_secret_access_key' => 'Secret',

     ## If you have CNAME buckets (foo.example.com), you might run into SSL issues
     ## when uploading backups ("hostname foo.example.com.storage.googleapis.com
     ## does not match the server certificate"). In that case, uncomnent the following
     ## setting. See: https://github.com/fog/fog/issues/2834
     #'path_style' => true
515 516 517
   }
   gitlab_rails['backup_upload_remote_directory'] = 'my.google.bucket'
   ```
518

519
1. [Reconfigure GitLab](../administration/restart_gitlab.md#omnibus-gitlab-reconfigure) for the changes to take effect
520 521 522 523 524

For installations from source:

1. Edit `home/git/gitlab/config/gitlab.yml`:

525 526 527 528 529 530 531 532 533
   ```yaml
     backup:
       upload:
         connection:
           provider: 'Google'
           google_storage_access_key_id: 'Access Key'
           google_storage_secret_access_key: 'Secret'
         remote_directory: 'my.google.bucket'
   ```
534

535
1. [Restart GitLab](../administration/restart_gitlab.md#installations-from-source) for the changes to take effect
536

537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574
##### Using Azure Blob storage

> [Introduced](https://gitlab.com/gitlab-org/gitlab/-/issues/25877) in GitLab 13.4.

For Omnibus GitLab packages:

1. Edit `/etc/gitlab/gitlab.rb`:

   ```ruby
   gitlab_rails['backup_upload_connection'] = {
    'provider' => 'AzureRM',
    'azure_storage_account_name' => '<AZURE STORAGE ACCOUNT NAME>',
    'azure_storage_access_key' => '<AZURE STORAGE ACCESS KEY>',
    'azure_storage_domain' => 'blob.core.windows.net', # Optional
   }
   gitlab_rails['backup_upload_remote_directory'] = '<AZURE BLOB CONTAINER>'
   ```

1. [Reconfigure GitLab](../administration/restart_gitlab.md#omnibus-gitlab-reconfigure) for the changes to take effect

For installations from source:

1. Edit `home/git/gitlab/config/gitlab.yml`:

   ```yaml
     backup:
       upload:
         connection:
           provider: 'AzureRM'
           azure_storage_account_name: '<AZURE STORAGE ACCOUNT NAME>'
           azure_storage_access_key: '<AZURE STORAGE ACCESS KEY>'
         remote_directory: '<AZURE BLOB CONTAINER>'
   ```

1. [Restart GitLab](../administration/restart_gitlab.md#installations-from-source) for the changes to take effect

See [the table of Azure parameters](../administration/object_storage.md#azure-blob-storage) for more details.

575
##### Specifying a custom directory for backups
576 577 578 579

Note: This option only works for remote storage. If you want to group your backups
you can pass a `DIRECTORY` environment variable:

580
```shell
581 582
sudo gitlab-backup create DIRECTORY=daily
sudo gitlab-backup create DIRECTORY=weekly
583 584
```

585
NOTE: **Note:**
586 587
For GitLab 12.1 and earlier, use `gitlab-rake gitlab:backup:create`.

588
#### Uploading to locally mounted shares
589

590
You may also send backups to a mounted share (for example, `NFS`,`CIFS`, or `SMB`) by
591
using the Fog [`Local`](https://github.com/fog/fog-local#usage) storage provider.
592 593
The directory pointed to by the `local_root` key **must** be owned by the `git`
user **when mounted** (mounting with the `uid=` of the `git` user for `CIFS` and
594
`SMB`) or the user that you are executing the backup tasks under (for Omnibus
595 596 597 598 599 600 601 602
packages, this is the `git` user).

The `backup_upload_remote_directory` **must** be set in addition to the
`local_root` key. This is the sub directory inside the mounted directory that
backups will be copied to, and will be created if it does not exist. If the
directory that you want to copy the tarballs to is the root of your mounted
directory, just use `.` instead.

603
NOTE: **Note:**
604
Since file system performance may affect GitLab's overall performance, we do not recommend using EFS for storage. See the [relevant documentation](../administration/nfs.md#avoid-using-awss-elastic-file-system-efs) for more details.
605

606
For Omnibus GitLab packages:
607

608 609
1. Edit `/etc/gitlab/gitlab.rb`:

610 611 612 613 614
   ```ruby
   gitlab_rails['backup_upload_connection'] = {
     :provider => 'Local',
     :local_root => '/mnt/backups'
   }
615

616 617 618 619
   # The directory inside the mounted folder to copy backups to
   # Use '.' to store them in the root directory
   gitlab_rails['backup_upload_remote_directory'] = 'gitlab_backups'
   ```
620

621
1. [Reconfigure GitLab](../administration/restart_gitlab.md#omnibus-gitlab-reconfigure) for the changes to take effect.
622

623 624
For installations from source:

625 626
1. Edit `home/git/gitlab/config/gitlab.yml`:

627 628 629 630 631 632 633 634 635 636 637
   ```yaml
   backup:
     upload:
       # Fog storage connection settings, see http://fog.io/storage/ .
       connection:
         provider: Local
         local_root: '/mnt/backups'
       # The directory inside the mounted folder to copy backups to
       # Use '.' to store them in the root directory
       remote_directory: 'gitlab_backups'
   ```
638

639
1. [Restart GitLab](../administration/restart_gitlab.md#installations-from-source) for the changes to take effect.
640

641
#### Backup archive permissions
642

643
The backup archives created by GitLab (`1393513186_2014_02_27_gitlab_backup.tar`)
644
will have owner/group `git`/`git` and 0600 permissions by default.
645 646 647
This is meant to avoid other system users reading GitLab's data.
If you need the backup archives to have different permissions you can use the 'archive_permissions' setting.

648
For Omnibus GitLab packages:
649

650
1. Edit `/etc/gitlab/gitlab.rb`:
651

652 653 654
   ```ruby
   gitlab_rails['backup_archive_permissions'] = 0644 # Makes the backup archives world-readable
   ```
655

656
1. [Reconfigure GitLab](../administration/restart_gitlab.md#omnibus-gitlab-reconfigure) for the changes to take effect.
657 658

For installations from source:
659

660
1. Edit `/home/git/gitlab/config/gitlab.yml`:
661

662 663 664 665
   ```yaml
   backup:
     archive_permissions: 0644 # Makes the backup archives world-readable
   ```
666

667
1. [Restart GitLab](../administration/restart_gitlab.md#installations-from-source) for the changes to take effect.
668

669
#### Configuring cron to make daily backups
670

671
CAUTION: **Warning:**
672 673 674
The following cron jobs do not [backup your GitLab configuration files](#storing-configuration-files)
or [SSH host keys](https://superuser.com/questions/532040/copy-ssh-keys-from-one-server-to-another-server/532079#532079).

675 676
You can schedule a cron job that backs up your repositories and GitLab metadata.

677 678
For Omnibus GitLab packages:

679
1. Edit the crontab for the `root` user:
680

681 682 683
   ```shell
   sudo su -
   crontab -e
684
   ```
685

686
1. There, add the following line to schedule the backup for everyday at 2 AM:
687

688 689 690
   ```plaintext
   0 2 * * * /opt/gitlab/bin/gitlab-backup create CRON=1
   ```
691

692
   NOTE: **Note:**
693
   For GitLab 12.1 and earlier, use `gitlab-rake gitlab:backup:create`.
694

695
For installations from source:
696

697
1. Edit the crontab for the `git` user:
698

699 700 701
   ```shell
   sudo -u git crontab -e
   ```
702

703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725
1. Add the following lines at the bottom:

   ```plaintext
   # Create a full backup of the GitLab repositories and SQL database every day at 2am
   0 2 * * * cd /home/git/gitlab && PATH=/usr/local/bin:/usr/bin:/bin bundle exec rake gitlab:backup:create RAILS_ENV=production CRON=1
   ```

NOTE: **Note:**
The `CRON=1` environment setting tells the backup script to suppress all progress output if there are no errors.
This is recommended to reduce cron spam.

### Limit backup lifetime for local files (prune old backups)

CAUTION: **Warning:**
This will not work if you have used a [custom filename](#backup-filename)
for your backups.

NOTE: **Note:**
This configuration option only manages local files. GitLab does not automatically
prune old files stored in a third-party [object storage](#uploading-backups-to-a-remote-cloud-storage)
because the user may not have permission to list and delete files. It is
recommended that you configure the appropriate retention policy for your object
storage (for example, [AWS S3](https://docs.aws.amazon.com/AmazonS3/latest/user-guide/create-lifecycle.html)).
726

727
You may want to set a limited lifetime for backups to prevent regular
728
backups using all your disk space. The next time the backup task is run, backups older than the `backup_keep_time` will be pruned.
729

730 731 732 733 734 735 736 737 738 739 740
For Omnibus GitLab packages:

1. Edit `/etc/gitlab/gitlab.rb`:

   ```ruby
   ## Limit backup lifetime to 7 days - 604800 seconds
   gitlab_rails['backup_keep_time'] = 604800
   ```

1. [Reconfigure GitLab](../administration/restart_gitlab.md#omnibus-gitlab-reconfigure) for the changes to take effect.

741 742
For installations from source:

743
1. Edit `/home/git/gitlab/config/gitlab.yml`:
744

745 746 747 748 749
   ```yaml
   backup:
     ## Limit backup lifetime to 7 days - 604800 seconds
     keep_time: 604800
   ```
750

751
1. [Restart GitLab](../administration/restart_gitlab.md#installations-from-source) for the changes to take effect.
752

753
## Restore GitLab
754

755
GitLab provides a simple command line interface to restore your whole installation,
756 757 758 759 760 761
and is flexible enough to fit your needs.

The [restore prerequisites section](#restore-prerequisites) includes crucial
information. Make sure to read and test the whole restore process at least once
before attempting to perform it in a production environment.

762
You can only restore a backup to **exactly the same version and type (CE/EE)** of
763
GitLab that you created it on, for example CE 9.1.0.
764

765
If your backup is a different version than the current installation, you will
766
need to [downgrade your GitLab installation](https://docs.gitlab.com/omnibus/update/README.html#downgrade)
767 768
before restoring the backup.

769
### Restore prerequisites
770 771 772

You need to have a working GitLab installation before you can perform
a restore. This is mainly because the system user performing the
773
restore actions (`git`) is usually not allowed to create or delete
774
the SQL database it needs to import data into (`gitlabhq_production`).
775 776 777
All existing data will be either erased (SQL) or moved to a separate
directory (repositories, uploads).

778 779 780
To restore a backup, you will also need to restore `/etc/gitlab/gitlab-secrets.json`
(for Omnibus packages) or `/home/git/gitlab/.secret` (for installations
from source). This file contains the database encryption key,
781
[CI/CD variables](../ci/variables/README.md#gitlab-cicd-environment-variables), and
782
variables used for [two-factor authentication](../user/profile/account/two_factor_authentication.md).
783 784 785 786
If you fail to restore this encryption key file along with the application data
backup, users with two-factor authentication enabled and GitLab Runners will
lose access to your GitLab server.

D
Davin Walker 已提交
787 788
You may also want to restore any TLS keys, certificates, or [SSH host keys](https://superuser.com/questions/532040/copy-ssh-keys-from-one-server-to-another-server/532079#532079).

789 790 791 792
Starting with GitLab 12.9 if an untarred backup (like the ones made with
`SKIP=tar`) is found, and no backup is chosen with `BACKUP=<timestamp>`, the
untarred backup is used.

793 794 795 796 797
Depending on your case, you might want to run the restore command with one or
more of the following options:

- `BACKUP=timestamp_of_backup` - Required if more than one backup exists.
  Read what the [backup timestamp is about](#backup-timestamp).
798
- `force=yes` - Does not ask if the authorized_keys file should get regenerated and assumes 'yes' for warning that database tables will be removed, enabling the "Write to authorized_keys file" setting, and updating LDAP providers.
799

800
If you are restoring into directories that are mount points, you will need to make
801 802 803 804
sure these directories are empty before attempting a restore. Otherwise GitLab
will attempt to move these directories before restoring the new data and this
would cause an error.

805
Read more on [configuring NFS mounts](../administration/nfs.md)
806

807
### Restore for installation from source
808

809
```shell
810 811 812
# Stop processes that are connected to the database
sudo service gitlab stop

D
Dmitriy Zaporozhets 已提交
813
bundle exec rake gitlab:backup:restore RAILS_ENV=production
814 815 816 817
```

Example output:

818
```plaintext
819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843
Unpacking backup... [DONE]
Restoring database tables:
-- create_table("events", {:force=>true})
   -> 0.2231s
[...]
- Loading fixture events...[DONE]
- Loading fixture issues...[DONE]
- Loading fixture keys...[SKIPPING]
- Loading fixture merge_requests...[DONE]
- Loading fixture milestones...[DONE]
- Loading fixture namespaces...[DONE]
- Loading fixture notes...[DONE]
- Loading fixture projects...[DONE]
- Loading fixture protected_branches...[SKIPPING]
- Loading fixture schema_migrations...[DONE]
- Loading fixture services...[SKIPPING]
- Loading fixture snippets...[SKIPPING]
- Loading fixture taggings...[SKIPPING]
- Loading fixture tags...[SKIPPING]
- Loading fixture users...[DONE]
- Loading fixture users_projects...[DONE]
- Loading fixture web_hooks...[SKIPPING]
- Loading fixture wikis...[SKIPPING]
Restoring repositories:
- Restoring repository abcd... [DONE]
844
- Object pool 1 ...
845 846
Deleting tmp directories...[DONE]
```
847

848 849 850 851 852 853 854 855
Next, restore `/home/git/gitlab/.secret` if necessary as mentioned above.

Restart GitLab:

```shell
sudo service gitlab restart
```

856
### Restore for Omnibus GitLab installations
V
Valery Sizov 已提交
857

858
This procedure assumes that:
V
Valery Sizov 已提交
859

860
- You have installed the **exact same version and type (CE/EE)** of GitLab
861
  Omnibus with which the backup was created.
862
- You have run `sudo gitlab-ctl reconfigure` at least once.
863
- GitLab is running. If not, start it using `sudo gitlab-ctl start`.
864 865 866

First make sure your backup tar file is in the backup directory described in the
`gitlab.rb` configuration `gitlab_rails['backup_path']`. The default is
867
`/var/opt/gitlab/backups`. It needs to be owned by the `git` user.
V
Valery Sizov 已提交
868 869

```shell
870
sudo cp 11493107454_2018_04_25_10.6.4-ce_gitlab_backup.tar /var/opt/gitlab/backups/
C
Craig Fisher 已提交
871
sudo chown git.git /var/opt/gitlab/backups/11493107454_2018_04_25_10.6.4-ce_gitlab_backup.tar
V
Valery Sizov 已提交
872 873
```

874
Stop the processes that are connected to the database. Leave the rest of GitLab
875
running:
V
Valery Sizov 已提交
876 877 878

```shell
sudo gitlab-ctl stop unicorn
879
sudo gitlab-ctl stop puma
V
Valery Sizov 已提交
880
sudo gitlab-ctl stop sidekiq
881 882 883
# Verify
sudo gitlab-ctl status
```
V
Valery Sizov 已提交
884

885 886 887 888
Next, restore the backup, specifying the timestamp of the backup you wish to
restore:

```shell
V
Valery Sizov 已提交
889
# This command will overwrite the contents of your GitLab database!
890
sudo gitlab-backup restore BACKUP=11493107454_2018_04_25_10.6.4-ce
891
```
V
Valery Sizov 已提交
892

893
NOTE: **Note:**
894 895 896 897
For GitLab 12.1 and earlier, use `gitlab-rake gitlab:backup:restore`.

CAUTION: **Warning:**
`gitlab-rake gitlab:backup:restore` does not set the right file system permissions on your Registry directory.
898
This is a [known issue](https://gitlab.com/gitlab-org/gitlab-foss/-/issues/62759). On GitLab 12.2 or newer, you can
899 900
use `gitlab-backup restore` to avoid this issue.

901 902
Next, restore `/etc/gitlab/gitlab-secrets.json` if necessary as mentioned above.

903
Reconfigure, restart and check GitLab:
V
Valery Sizov 已提交
904

905
```shell
906
sudo gitlab-ctl reconfigure
907
sudo gitlab-ctl restart
V
Valery Sizov 已提交
908 909 910 911
sudo gitlab-rake gitlab:check SANITIZE=true
```

If there is a GitLab version mismatch between your backup tar file and the installed
912
version of GitLab, the restore command will abort with an error. Install the
913
[correct GitLab version](https://packages.gitlab.com/gitlab/) and try again.
V
Valery Sizov 已提交
914

915
NOTE: **Note:**
916 917 918 919 920
There is currently a [known issue](https://gitlab.com/gitlab-org/omnibus-gitlab/-/issues/3470) for restore not working
with `pgbouncer`. In order to workaround the issue, the Rails node will need to bypass `pgbouncer` and connect
directly to the primary database node. This can be done by setting `gitlab_rails['db_host']` and `gitlab_rails['port']`
to connect to the primary database node and [reconfiguring GitLab](../administration/restart_gitlab.md#omnibus-gitlab-reconfigure).

921
### Restore for Docker image and GitLab Helm chart installations
922

923
For GitLab installations using the Docker image or the GitLab Helm chart on
924
a Kubernetes cluster, the restore task expects the restore directories to be empty.
925
However, with Docker and Kubernetes volume mounts, some system level directories
926 927
may be created at the volume roots, like `lost+found` directory found in Linux
operating systems. These directories are usually owned by `root`, which can
928
cause access permission errors since the restore Rake task runs as `git` user.
929 930 931 932 933 934
So, to restore a GitLab installation, users have to confirm the restore target
directories are empty.

For both these installation types, the backup tarball has to be available in the
backup location (default location is `/var/opt/gitlab/backups`).

935
For Docker installations, the restore task can be run from host:
936

937
```shell
938 939 940 941 942 943 944 945 946 947 948 949 950 951 952 953
# Stop the processes that are connected to the database
docker exec -it <name of container> gitlab-ctl stop unicorn
docker exec -it <name of container> gitlab-ctl stop puma
docker exec -it <name of container> gitlab-ctl stop sidekiq

# Verify that the processes are all down before continuing
docker exec -it <name of container> gitlab-ctl status

# Run the restore
docker exec -it <name of container> gitlab-backup restore BACKUP=11493107454_2018_04_25_10.6.4-ce

# Restart the GitLab container
docker restart <name of container>

# Check GitLab
docker exec -it <name of container> gitlab-rake gitlab:check SANITIZE=true
954 955
```

956
NOTE: **Note:**
957 958 959 960
For GitLab 12.1 and earlier, use `gitlab-rake gitlab:backup:restore`.

CAUTION: **Warning:**
`gitlab-rake gitlab:backup:restore` does not set the right file system permissions on your Registry directory.
961
This is a [known issue](https://gitlab.com/gitlab-org/gitlab-foss/-/issues/62759). On GitLab 12.2 or newer, you can
962 963
use `gitlab-backup restore` to avoid this issue.

964 965
The GitLab Helm chart uses a different process, documented in
[restoring a GitLab Helm chart installation](https://gitlab.com/gitlab-org/charts/gitlab/blob/master/doc/backup-restore/restore.md).
966

967 968 969 970 971 972 973 974 975 976 977 978 979 980 981 982 983 984
### Restoring only one or a few project(s) or group(s) from a backup

While the Rake task used to restore a GitLab instance doesn't support
restoring a single project or group, you can use a workaround by
restoring your backup to a separate, temporary GitLab instance, and
export your project or group from there:

1. [Install a new GitLab](../install/README.md) instance at the same version as
   the backed-up instance from which you want to restore.
1. [Restore the backup](#restore-gitlab) into this new instance and
   export your [project](../user/project/settings/import_export.md)
   or [group](../user/group/settings/import_export.md). Make sure to
   read the **Important Notes** on either export feature's documentation
   to understand what will be exported and what not.
1. Once the export is complete, go to the old instance and import it.
1. After importing only the project(s) or group(s) that you wanted is complete,
   you may delete the new, temporary GitLab instance.

985
NOTE: **Note:**
986 987 988
A feature request to provide direct restore of individual projects or groups
is being discussed in [issue #17517](https://gitlab.com/gitlab-org/gitlab/-/issues/17517).

J
Jacob Vosmaer 已提交
989 990 991 992 993
## Alternative backup strategies

If your GitLab server contains a lot of Git repository data you may find the GitLab backup script to be too slow.
In this case you can consider using filesystem snapshots as part of your backup strategy.

994
Example: Amazon EBS
J
Jacob Vosmaer 已提交
995

996
> A GitLab server using Omnibus GitLab hosted on Amazon AWS.
J
Jacob Vosmaer 已提交
997 998
> An EBS drive containing an ext4 filesystem is mounted at `/var/opt/gitlab`.
> In this case you could make an application backup by taking an EBS snapshot.
999
> The backup includes all repositories, uploads and PostgreSQL data.
J
Jacob Vosmaer 已提交
1000

1001
Example: LVM snapshots + rsync
J
Jacob Vosmaer 已提交
1002

1003
> A GitLab server using Omnibus GitLab, with an LVM logical volume mounted at `/var/opt/gitlab`.
1004
> Replicating the `/var/opt/gitlab` directory using rsync would not be reliable because too many files would change while rsync is running.
J
Jacob Vosmaer 已提交
1005
> Instead of rsync-ing `/var/opt/gitlab`, we create a temporary LVM snapshot, which we mount as a read-only filesystem at `/mnt/gitlab_backup`.
1006
> Now we can have a longer running rsync job which will create a consistent replica on the remote server.
1007
> The replica includes all repositories, uploads and PostgreSQL data.
J
Jacob Vosmaer 已提交
1008 1009 1010

If you are running GitLab on a virtualized server you can possibly also create VM snapshots of the entire GitLab server.
It is not uncommon however for a VM snapshot to require you to power down the server, so this approach is probably of limited practical use.
1011

1012 1013 1014 1015 1016 1017 1018 1019 1020
## Additional notes

This documentation is for GitLab Community and Enterprise Edition. We backup
GitLab.com and make sure your data is secure, but you can't use these methods
to export / backup your data yourself from GitLab.com.

Issues are stored in the database. They can't be stored in Git itself.

To migrate your repositories from one server to another with an up-to-date version of
1021 1022
GitLab, you can use the [import Rake task](import.md) to do a mass import of the
repository. Note that if you do an import Rake task, rather than a backup restore, you
1023 1024
will have all your repositories, but not any other data.

1025 1026
## Troubleshooting

1027 1028
The following are possible problems you might encounter with possible solutions.

1029
### Restoring database backup using Omnibus packages outputs warnings
1030

1031 1032
If you are using backup restore procedures you might encounter the following warnings:

1033
```plaintext
1034
psql:/var/opt/gitlab/backups/db/database.sql:22: ERROR:  must be owner of extension plpgsql
A
Anton Davydov 已提交
1035 1036
psql:/var/opt/gitlab/backups/db/database.sql:2931: WARNING:  no privileges could be revoked for "public" (two occurrences)
psql:/var/opt/gitlab/backups/db/database.sql:2933: WARNING:  no privileges were granted for "public" (two occurrences)
1037 1038 1039 1040
```

Be advised that, backup is successfully restored in spite of these warnings.

1041
The Rake task runs this as the `gitlab` user which does not have the superuser access to the database. When restore is initiated it will also run as `gitlab` user but it will also try to alter the objects it does not have access to.
1042 1043
Those objects have no influence on the database backup/restore but they give this annoying warning.

1044
For more information see similar questions on PostgreSQL issue tracker [here](https://www.postgresql.org/message-id/201110220712.30886.adrian.klaver@gmail.com) and [here](https://www.postgresql.org/message-id/2039.1177339749@sss.pgh.pa.us) as well as [stack overflow](https://stackoverflow.com/questions/4368789/error-must-be-owner-of-language-plpgsql).
1045

1046 1047
### When the secrets file is lost

1048 1049
If you have failed to [back up the secrets file](#storing-configuration-files), you'll
need to perform a number of steps to get GitLab working properly again.
1050

1051
The secrets file is responsible for storing the encryption key for several
1052 1053 1054 1055
columns containing sensitive information. If the key is lost, GitLab will be
unable to decrypt those columns. This will break a wide range of functionality,
including (but not restricted to):

1056 1057
- [CI/CD variables](../ci/variables/README.md)
- [Kubernetes / GCP integration](../user/project/clusters/index.md)
1058
- [Custom Pages domains](../user/project/pages/custom_domains_ssl_tls_certification/index.md)
1059
- [Project error tracking](../operations/error_tracking.md)
1060
- [Runner authentication](../ci/runners/README.md)
1061
- [Project mirroring](../user/project/repository/repository_mirroring.md)
1062
- [Web hooks](../user/project/integrations/webhooks.md)
1063

1064 1065 1066 1067 1068 1069 1070 1071 1072
In cases like CI/CD variables and Runner authentication, you might
experience some unexpected behavior such as:

- Stuck jobs.
- 500 errors.

In this case, you are required to reset all the tokens for CI/CD variables
and Runner Authentication, which is described in more detail below. After
resetting the tokens, you should be able to visit your project and the jobs
1073 1074 1075 1076 1077 1078 1079 1080 1081 1082
will have started running again. Use the information in the following sections at your own risk.

#### Check for undecryptable values

You can check whether you have undecryptable values in the database using
the [Secrets Doctor Rake task](../administration/raketasks/doctor.md).

#### Take a backup

You will need to directly modify GitLab data to work around your lost secrets file.
1083 1084

CAUTION: **Warning:**
1085 1086 1087 1088 1089 1090 1091
Make sure you've taken a backup beforehand, particularly a full database backup.

#### Disable user two-factor authentication (2FA)

Users with 2FA enabled will not be able to log into GitLab. In that case,
you need to [disable 2FA for everyone](../security/two_factor_authentication.md#disabling-2fa-for-everyone)
and then users will have to reactivate 2FA from scratch.
1092

1093 1094
#### Reset CI/CD variables

1095
1. Enter the DB console:
1096

1097
   For Omnibus GitLab packages:
1098

1099
   ```shell
1100 1101
   sudo gitlab-rails dbconsole
   ```
1102

1103
   For installations from source:
1104

1105
   ```shell
1106
   sudo -u git -H bundle exec rails dbconsole -e production
1107
   ```
1108

1109
1. Check the `ci_group_variables` and `ci_variables` tables:
1110

1111 1112 1113 1114
   ```sql
   SELECT * FROM public."ci_group_variables";
   SELECT * FROM public."ci_variables";
   ```
1115

1116
   Those are the variables that you need to delete.
1117

1118
1. Drop the table:
1119

1120 1121 1122 1123
   ```sql
   DELETE FROM ci_group_variables;
   DELETE FROM ci_variables;
   ```
1124 1125 1126 1127

1. You may need to reconfigure or restart GitLab for the changes to take
   effect.

1128 1129
#### Reset Runner registration tokens

1130
1. Enter the DB console:
1131

1132
   For Omnibus GitLab packages:
1133

1134
   ```shell
1135 1136
   sudo gitlab-rails dbconsole
   ```
1137

1138
   For installations from source:
1139

1140
   ```shell
1141
   sudo -u git -H bundle exec rails dbconsole -e production
1142
   ```
1143 1144 1145

1. Clear all the tokens for projects, groups, and the whole instance:

1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159
   CAUTION: **Caution:**
   The last UPDATE operation will stop the runners being able to pick up
   new jobs. You must register new runners.

   ```sql
   -- Clear project tokens
   UPDATE projects SET runners_token = null, runners_token_encrypted = null;
   -- Clear group tokens
   UPDATE namespaces SET runners_token = null, runners_token_encrypted = null;
   -- Clear instance tokens
   UPDATE application_settings SET runners_registration_token_encrypted = null;
   -- Clear runner tokens
   UPDATE ci_runners SET token = null, token_encrypted = null;
   ```
1160

1161 1162 1163 1164 1165 1166
#### Reset pending pipeline jobs

1. Enter the DB console:

   For Omnibus GitLab packages:

1167
   ```shell
1168 1169 1170 1171 1172
   sudo gitlab-rails dbconsole
   ```

   For installations from source:

1173
   ```shell
1174
   sudo -u git -H bundle exec rails dbconsole -e production
1175 1176 1177 1178 1179 1180 1181 1182 1183
   ```

1. Clear all the tokens for pending jobs:

   ```sql
   -- Clear build tokens
   UPDATE ci_builds SET token = null, token_encrypted = null;
   ```

1184 1185 1186 1187
A similar strategy can be employed for the remaining features - by removing the
data that cannot be decrypted, GitLab can be brought back into working order,
and the lost data can be manually replaced.

1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216
#### Fix project integrations

If you've lost your secrets, the
[projects' integrations settings pages](../user/project/integrations/index.md)
are probably generating 500 errors.

The fix is to truncate the `web_hooks` table:

1. Enter the DB console:

   For Omnibus GitLab packages:

   ```shell
   sudo gitlab-rails dbconsole
   ```

   For installations from source:

   ```shell
   sudo -u git -H bundle exec rails dbconsole -e production
   ```

1. Truncate the table

   ```sql
   -- truncate web_hooks table
   TRUNCATE web_hooks CASCADE;
   ```

1217 1218
### Container Registry push failures after restoring from a backup

1219
If you use the [Container Registry](../user/packages/container_registry/index.md), you
1220 1221 1222 1223 1224
may see pushes to the registry fail after restoring your backup on an Omnibus
GitLab instance after restoring the registry data.

These failures will mention permission issues in the registry logs, like:

1225
```plaintext
1226 1227 1228 1229 1230 1231 1232 1233 1234
level=error
msg="response completed with error"
err.code=unknown
err.detail="filesystem: mkdir /var/opt/gitlab/gitlab-rails/shared/registry/docker/registry/v2/repositories/...: permission denied"
err.message="unknown error"
```

This is caused by the restore being run as the unprivileged user `git` which was
unable to assign the correct ownership to the registry files during the restore
1235
([issue 62759](https://gitlab.com/gitlab-org/gitlab-foss/-/issues/62759 "Incorrect permissions on registry filesystem after restore")).
1236 1237 1238

To get your registry working again:

1239
```shell
1240 1241 1242 1243 1244
sudo chown -R registry:registry /var/opt/gitlab/gitlab-rails/shared/registry/docker
```

NOTE: **Note:**
If you have changed the default filesystem location for the registry, you will
1245
want to run the `chown` against your custom location instead of
1246 1247
`/var/opt/gitlab/gitlab-rails/shared/registry/docker`.

1248 1249
### Backup fails to complete with Gzip error

1250
While running the backup, you may receive a Gzip error:
1251

1252
```shell
1253
sudo /opt/gitlab/bin/gitlab-backup create
1254
...
1255 1256 1257 1258 1259 1260 1261 1262 1263
Dumping ...
...
gzip: stdout: Input/output error

Backup failed
```

If this happens, check the following:

1264
1. Confirm there is sufficient disk space for the Gzip operation.
1265
1. If NFS is being used, check if the mount option `timeout` is set. The default is `600`, and changing this to smaller values have resulted in this error.