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

# Database Requirements

## Overview

G360 requires a PostgreSQL database to store and manage application data.

Your organization can use one of the supported database deployment options:

1. A managed PostgreSQL database
2. A PostgreSQL container deployed with G360

## Option 1: Managed PostgreSQL Database

A managed PostgreSQL service is the recommended option for production environments.

For example, organizations using AWS can use Amazon RDS.

The database must use:

* PostgreSQL 16 or later
* The `pg_trgm` extension

A managed database service can simplify:

* Backups
* Database recovery
* Storage management
* Database maintenance

### Recommended Database Configuration

For an initial production deployment, the recommended configuration includes:

* At least a `db.t4g.large` instance
* 100 GB of gp3 storage
* Storage autoscaling
* At least 7 days of backups
* Point-in-Time Recovery (PITR)

<Note>
  The database should only be accessible from authorized infrastructure, including the G360 environment.
</Note>

## Option 2: PostgreSQL Container

PostgreSQL can also run as a Docker container on the same server as G360.

This option may be suitable for:

* Pilot environments
* Smaller deployments
* Organizations that do not use a managed database service

However, your organization is responsible for managing:

* Database backups
* Restore testing
* Database upgrades
* Disk capacity

<Warning>
  Do not remove Docker volumes used by the G360 PostgreSQL database. Removing these volumes can permanently delete database data.
</Warning>

## Database Access

Before G360 is installed, the required database information must be available to the installation team.

Depending on your database configuration, this may include:

* Database hostname
* Port
* Database name
* Database username
* Database password

A dedicated database and database user should be used for G360.

## Choosing a Database Option

| Option               | Recommended For                                |
| -------------------- | ---------------------------------------------- |
| Managed PostgreSQL   | Production environments and larger deployments |
| PostgreSQL Container | Pilots and smaller deployments                 |

## Next Steps

After the database has been prepared, configure the required network and firewall access.

Continue to [Network Requirements](./network-requirements).