PostgreSQL

PostgreSQL: Out of Memory with large result sets

The PostgreSQL driver buffer all rows in the result set before handing it over to DbVisualizer. This may lead to out of memory situations. Check the Set q...

Thu, 4 Mar, 2021 at 8:08 AM

PostgreSQL: The hostname xxx could not be verified by hostnameverifier PgjdbcHostnameVerifier

The PostgreSQL JDBC driver was updated in DbVisualizer 11.0 and the new version works different when setting sslfactory = org.postgresql.ssl.NonValidatingFa...

Thu, 21 May, 2020 at 7:01 PM

PostgreSQL: Connecting to an SSL-enabled PostgreSQL server

PostgreSQL has native support for using SSL connections to encrypt client/server communications for increased security. This solution describes how to conne...

Mon, 30 Oct, 2023 at 3:40 PM

Using a password file (.pgPass)

PostgreSQL and some related databases can store connection passwords in a file, commonly referred to as a .pgpass file. To use a password file: In yo...

Mon, 13 May, 2024 at 6:09 AM

PostgreSQL: Single Sign On (SSO) using Kerberos on Windows

If you are on Windows and want to use Kerberos (from Active Directory) to log in to a PostgreSQL database, you need to configure the DbVisualizer connection...

Tue, 21 May, 2024 at 10:11 PM

How can we help you today?

PostgreSQL