PostgreSQL Support Articles

Update the user’s privileges to CREATE, USAGE, or ALL on the public schema.

Use the command CREATE EXTENSION vector; instead of pgvector.

Add the –no-role-passwords flag to the pg_dumpall command.

Resolve the pg_dump server version mismatch by upgrading pg_dump, matching it to the server version, or using a third-party backup tool.

Verify the database cluster, username, and password.

Verify the connection string, ensure correct port usage, and add your local machine to the database cluster’s trusted sources.

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

Verify the hostname and check your local machine for DNS resolution issues.

Verify the hostname and confirm the database exists in the specified cluster.

Verify the format and values in the connection string for typos or formatting errors.

Prepend your database client command to the connection string.

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