VisibleThread RAG (VTRAG) requires PostgreSQL 16 with the vector extension. When deploying in AWS, use Amazon RDS for PostgreSQL, and configure it to allow the required extensions.

System Requirements

• Database: Amazon RDS PostgreSQL 16
• Extensions: vector (pgvector), uuid-ossp

Overview of Steps

• Prepare RDS PostgreSQL 16 instance.
• Update Parameter Group to support required extensions.
• Create your database and extensions.
• Deploy VT Rag and configure the service to use RDS: How to Deploy VisibleThread RAG (VTRAG)

Step 1: Create RDS PostgreSQL 16 Instance

Provision a PostgreSQL 16 instance through the AWS Console or CloudFormation CLI. Ensure storage and compute meet VTRAG specs.

Step 2: Edit RDS Parameter Group

To allow vector and uuid-ossp, update your DB parameter group:

• Set the following parameters:
  • rds.allowed_extensions = vector,uuid-ossp
  • rds.allowed_delegated_extensions = vector

Apply changes.

Troubleshooting

If you hit permission or extension errors:

• Double-check both parameter group entries.
• Make sure the delegated role is correctly assigned.
• Consult RDS logs for extension errors and AWS documentation for extension delegation.aws.amazon+1​

Security Considerations

• Secure RDS with VPC/private subnetting.
• Use TLS for DB and LLM service connections.
• Rotate DB credentials and monitor for unauthorized extension usage.

For further assistance and production recommendations, contact VisibleThread Support (support@visiblethread.com) or consult AWS RDS documentation on extension management.