Removing secondary Geo sites

DETAILS: Tier: Premium, Ultimate Offering: Self-managed

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

On the left sidebar, at the bottom, select Admin.
Select Geo > Nodes.
For the secondary site you want to remove, select Remove.
Confirm by selecting Remove when the prompt appears.

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

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

Uninstall GitLab:

NOTE: If GitLab data has to be cleaned from the instance as well, see how to uninstall the Linux package and all its data.

# 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

When 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 does 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>');