PostgreSQL Support

PostgreSQL is an open source, object-relational database built for extensibility, data integrity, and speed. Its concurrency support makes it fully ACID-compliant, and it supports dynamic loading and catalog-driven operations to let users customize its data types, functions, and more.

How do I fix my pgvector error "could not open extension control file?"

Run the command “CREATE EXTENSION vector;”

How do I fix the `pg_dumpall` error `permission denied for table pg_authid`?

Include the --no-role-passwords flag in the command.

How do I fix this pg_dump error, "pg_dump: error: aborting because of server version mismatch"?

You can fix this pg_dump error by either upgrading pg_dump, matching the correct pg_dump for your server version, or using a third-party backup tool.

When connecting to my database I get a Connection Refused error

Verify your connection string and add your local machine to the database cluster’s trusted sources.

When connecting to my database I get a Connection Timed Out error

Add your machine to the database cluster’s list of trusted sources.

When connecting to my database I get a No Such File or Directory error

Prepend your connection string with your database client.

When connecting to my database I get an Invalid Parameters and Values error

Check for typos and formatting errors in the connection string.

When connecting to PostgreSQL I get a Could Not Translate Hostname to Address error

Verify that the hostname is correct and whether your local machine has DNS resolution problems.

When connecting to PostgreSQL I get a Database Does Not Exist error

Verify that the hostname is correct and that you’ve created the database.

When connecting to PostgreSQL I get an Authentication Failed error

Check your cluster and username/password combination.

Why is my cluster rebalancing/resizing?

We are currently processing the cluster, most likely for maintenance. You can expect no downtime or performance issues.