> ## Documentation Index
> Fetch the complete documentation index at: https://developers.chatwoot.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to upgrade to Chatwoot v4?

> Complete guide for upgrading to Chatwoot v4 with PostgreSQL pgvector support

Chatwoot v4 requires PostgreSQL with `pgvector` support. You need to ensure that the version of PostgreSQL you are running supports `pgvector` before upgrading.

## Type of Deployment

### Linux

* If you are using managed PostgreSQL, refer to the **Managed PostgreSQL** section below.
* If you are using self-hosted PostgreSQL, read along.

### Docker

* If you are using managed PostgreSQL, refer to the **Managed PostgreSQL** section below.
* If you are using self-hosted PostgreSQL, read along.

### Kubernetes (Helm)

* If you are using managed PostgreSQL, refer to the **Managed PostgreSQL** section below.
* If you are using self-hosted PostgreSQL, read along.

### Heroku

* No action is needed if you are using Heroku PostgreSQL.
* If you are using another managed PostgreSQL, refer to the **Managed PostgreSQL** section below.

## PostgreSQL

The PostgreSQL section is divided into parts based on how you are running PostgreSQL:

1. **Managed PostgreSQL** from cloud vendors like AWS, GCP, Azure, Heroku, etc.
2. **Self-hosted PostgreSQL** on Linux, Docker, or Kubernetes via Helm charts.

### Managed PostgreSQL

#### AWS RDS

No action is needed if you are on the latest version of RDS.\
[Learn more](https://aws.amazon.com/about-aws/whats-new/2023/10/amazon-rds-postgresql-pgvector-hnsw-indexing/)

#### Google Cloud (Cloud SQL)

No action is needed.\
[Learn more](https://cloud.google.com/blog/products/databases/using-pgvector-llms-and-langchain-with-google-cloud-databases)

#### Heroku PostgreSQL

The `pgvector` extension is supported. No action is needed.\
[Learn more](https://devcenter.heroku.com/articles/pgvector-heroku-postgres)

#### Azure PostgreSQL

To enable `pgvector` on your Azure Database for PostgreSQL flexible server instance:

1. Add `pgvector` to your allowlist as described in the PostgreSQL extensions documentation.
2. Verify if it is correctly added by running:
   ```sql theme={null}
   SHOW azure.extensions;
   ```

[Learn more](https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-use-pgvector#enable-extension)

***

## Self-hosted PostgreSQL

### Linux VM

#### Existing Installation

Install the `pgvector` extension for your version of PostgreSQL and run the upgrade:

```bash theme={null}
# Find your PostgreSQL version
psql --version

# If its version 16, use the following command
# Replace "16" with your PostgreSQL version
sudo apt install postgresql-16-pgvector
```

### Docker Container

#### Existing Installation

1. Replace the PostgreSQL image with the pgvector image. The pgvector image is a drop-in replacement and works with your existing data:

   ```bash theme={null}
   docker compose down

   # Edit and replace the PostgreSQL image in docker-compose.yaml
   vi docker-compose.yaml

   # Replace PostgreSQL image tag
   # Example: replace
   # image: postgres:12
   # with
   # image: pgvector/pgvector:pg12

   # Ensure the pg tag number matches your PostgreSQL version
   docker compose pull

   # Verify the updated setup
   docker compose up -d
   ```

2. After verifying that the existing installation works with the pgvector image, proceed with the regular upgrade steps.
   [Learn more](https://www.chatwoot.com/docs/self-hosted/deployment/upgrade#docker)

### Kubernetes (Helm Chart)

If you use the built-in PostgreSQL via the official Helm chart, follow the steps below. The Bitnami-packaged PostgreSQL used in the Helm chart does not support the pgvector extension. To address this, we have built a custom Postgres image with `pgvector` support.

<Note>
  This is only applicable if you are using the built-in Postgres with helm charts. Refer to the managed docs section if you are using AWS RDS or something similar.
</Note>

1. Create a `values.v4-upgrade.yaml` file with the following contents:

   ```yaml theme={null}
   image:
     repository: chatwoot/chatwoot
     tag: v4.0.1
     pullPolicy: IfNotPresent

   postgresql:
     image:
       registry: ghcr.io
       repository: chatwoot/pgvector
   ```

2. Run `helm upgrade` with this custom values.yaml file.