A) Set up the environment

export $NEW_DEPLOYMENT=<red or black>
export $PROJECT_PREFIX=managed
export $CUSTOMER=<customer slug>

B) Retrieve the Encrypted Payload

CE will provide the location of the encrypted payload. Using the GPG key in 1Password, decrypt the payload.

gpg --decrypt name.tar.gz.asc -o name.tar.gz

C) Upload the payload to the managed instance

Use gcloud scp to copy decrypted tarball. Replace name.tar.gz with the name of the tarball.

gcloud compute scp --project "$PROJECT_PREFIX-$CUSTOMER" --tunnel-through-iap name.tar.gz root@default-$NEW_DEPLOYMENT-instance:~/name.tar.gz

D) Start a SSH session into the managed instance

Use gcloud ssh to get as shell into the managed instance

gcloud compute ssh --project "$PROJECT_PREFIX-$CUSTOMER" --tunnel-through-iap $NEW_DEPLOYMENT/docker-compose/docker-compose.yaml root@default-$NEW_DEPLOYMENT-instance:/deployment/docker-compose/docker-compose.yaml

E) Stop all containers

Stop all containers, we don’t want state being modified during the data loading

cd /deployment/docker-compose
docker-compose down

F) Unpack the payload

untar the tarball

tar -xzvf name.tar.gz.asc

G) Stage the backup

mv pgsql_dump.sql /tmp/pgsql_dump.sql

H) Mount the database backup into the database container

Edit docker-compose.yaml to mount the PostgresSQL dump into the container add the following line to the volumes: stanza for pgsql.

volumes:
  - /tmp/pgsql_dump:/tmp/pgsql_dump

I) Start the database container

10. docker-compose -d up <container_name>

Choose the appropriate value for <container_name>

• pgsql is the frontend database container
• codeintel-db is the Code Intel database container

J) Shell into the database container

docker exec -it pgsql /bin/sh

K) Drop Existing Database

When Sourcegraph first starts, either the frontend or migrator will run initial database migrations. Since we are loading database dumps that contain CREATE DATABASE instructions, we need to undo the initial creation.

# Start a connection to postgres
pgsql -U sg

// connect to the postgres database, cannot delete the schema that is currently selected
\c postgres

// delete the existing database
DROP DATABASE sg;

// create an empty schema
CREATE DATABASE sg;

// quit the pgsql session
\q

L) Load the database dump

psql -U sg sg < /tmp/pgsql_dump.sql

Once the database dump is loaded successfully, exit the database container shell session.

exit

M) Repeat Steps 3F to 3K for the CodeIntel DB (if provided)

Some customers may only provide the “pgsql” or frontend database dump. If the customer provides a Code Intel database dump, repeat the procedure from steps 3F to 3K, replacing

N) Edit the Site-Config JSON file from the customer data payload

Edit the Site Configuration JSON file provided by the customer.

• Set the externalUrl to the new value matching the convention <slug>.sourcegraph.com
• Configure the alerts similarly to Step 27 in the Creating a managed instance procedure.

O) Start Sourcegraph

docker-compse up -d

• Verify all containers are running.
• Examine frontend logs, checking for critical errors.