There are multiple methods to connect to Postgres based on how your instance is set up. Below is an example of a local configuration using a prebuilt Docker image provided by the pgvector team.
Create a file named `docker-compose.yml` with the content below:
```yaml
# Run this command to start the database:
# docker-compose up --build
version: "3"
services:
db:
hostname: 127.0.0.1
image: pgvector/pgvector:pg16
ports:
- 5432:5432
restart: always
environment:
- POSTGRES_DB=api
- POSTGRES_USER=myuser
- POSTGRES_PASSWORD=ChangeMe
volumes:
- ./init.sql:/docker-entrypoint-initdb.d/init.sql
```
`docker compose up` to start the Postgres container.
Create new credential with the configured user and password:
Fill in the node's field with values configured in `docker-compose.yml`. For example:
* Host: **localhost**
* Database: **api**
* Port: **5432**
Voila! You have now successfully setup Postgres Vector ready to be used.
### Troubleshooting
If both Flowise and Postgres are running on Docker, you might see the error: **AggregateError**.
Try to change the Host value from `localhost` to `host.docker.internal`
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.flowiseai.com/integrations/langchain/vector-stores/postgres.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.