Removing secondary Geo sites (PREMIUM SELF)

Secondary sites can be removed from the Geo cluster using the Geo administration page of the primary site. To remove a secondary site:

Go to Admin Area > Geo (/admin/geo/nodes).
Select the Remove button for the secondary site you want to remove.
Confirm by selecting Remove when the prompt appears.

Once removed from the Geo administration page, you must stop and uninstall the secondary site. For each node on your secondary Geo site:

Stop GitLab:
```
sudo gitlab-ctl stop
```

Uninstall GitLab:

# Stop gitlab and remove its supervision process
sudo gitlab-ctl uninstall

# Debian/Ubuntu
sudo dpkg --remove gitlab-ee

# Redhat/Centos
sudo rpm --erase gitlab-ee

Once GitLab has been uninstalled from each node on the secondary site, the replication slot must be dropped from the primary site's database as follows:

On the primary site's database node, start a PostgreSQL console session:
```
sudo gitlab-psql
```
NOTE: Using gitlab-rails dbconsole will not work, because managing replication slots requires superuser permissions.
Find the name of the relevant replication slot. This is the slot that is specified with --slot-name when running the replicate command: gitlab-ctl replicate-geo-database.
```
SELECT * FROM pg_replication_slots;
```

Remove the replication slot for the secondary site:

SELECT pg_drop_replication_slot('<name_of_slot>');