# PostgreSQL Support

Generated on 19 Mar 2026

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 a "permission denied for schema public" error in PostgreSQL?](https://docs.digitalocean.com/support/how-do-i-fix-a-permission-denied-for-schema-public-error-in-postgresql/index.html.md): Update the user’s privileges to `CREATE`, `USAGE`, or `ALL` on the public schema.

[How do I fix the pgvector "could not open extension control file" error?](https://docs.digitalocean.com/support/how-do-i-fix-the-pgvector-could-not-open-extension-control-file-error/index.html.md): Use the command CREATE EXTENSION vector; instead of pgvector.

[How do I fix the pg_dumpall "permission denied for table pg_authid" error?](https://docs.digitalocean.com/support/how-do-i-fix-the-pg_dumpall-permission-denied-for-table-pg_authid-error/index.html.md): Add the –no-role-passwords flag to the pg\_dumpall command.

[How do I fix the pg_dump "aborting because of server version mismatch" error?](https://docs.digitalocean.com/support/how-do-i-fix-the-pg_dump-aborting-because-of-server-version-mismatch-error/index.html.md): Resolve the pg\_dump server version mismatch by upgrading pg\_dump, matching it to the server version, or using a third-party backup tool.

[How do I fix the "Authentication Failed" error when connecting to PostgreSQL?](https://docs.digitalocean.com/support/how-do-i-fix-the-authentication-failed-error-when-connecting-to-postgresql/index.html.md): Verify the database cluster, username, and password.

[How do I fix the "Connection Refused" error when connecting to my database?](https://docs.digitalocean.com/support/how-do-i-fix-the-connection-refused-error-when-connecting-to-my-database/index.html.md): Verify the connection string, ensure correct port usage, and add your local machine to the database cluster’s trusted sources.

[How do I fix the "Connection Timed Out" error when connecting to my database?](https://docs.digitalocean.com/support/how-do-i-fix-the-connection-timed-out-error-when-connecting-to-my-database/index.html.md): Add your machine to the database cluster’s list of trusted sources in the firewall settings.

[How do I fix the "Could Not Translate Hostname to Address" error when connecting to PostgreSQL?](https://docs.digitalocean.com/support/how-do-i-fix-the-could-not-translate-hostname-to-address-error-when-connecting-to-postgresql/index.html.md): Verify the hostname and check your local machine for DNS resolution issues.

[How do I fix the "Database Does Not Exist" error when connecting to PostgreSQL?](https://docs.digitalocean.com/support/how-do-i-fix-the-database-does-not-exist-error-when-connecting-to-postgresql/index.html.md): Verify the hostname and confirm the database exists in the specified cluster.

[How do I fix the "Invalid Parameters and Values" error when connecting to my database?](https://docs.digitalocean.com/support/how-do-i-fix-the-invalid-parameters-and-values-error-when-connecting-to-my-database/index.html.md): Verify the format and values in the connection string for typos or formatting errors.

[How do I fix the "No Such File or Directory" error when connecting to my database?](https://docs.digitalocean.com/support/how-do-i-fix-the-no-such-file-or-directory-error-when-connecting-to-my-database/index.html.md): Prepend your database client command to the connection string.

[Why is my cluster rebalancing/resizing?](https://docs.digitalocean.com/support/why-is-my-cluster-rebalancing/resizing/index.html.md): We are currently processing the cluster, most likely for maintenance. You can expect no downtime or performance issues.