PostgreSQL

List Settings In postgresql.conf and postgresql.auto.conf

SQL statements to list settings defined in postgresql.conf and overriden by postgresql.auto.conf.

Read More...

PostgreSQL

PostgreSQL Terminate Active Connections

Sometimes we need to terminate active connections to a database forcefully. Doing such requires two things, determining which active connections to target and running the command to terminate them. This

Read More...

Java, PostgreSQL, Software Development

How to connect Java to PostgreSQL using JDBC

This is a simple post that shows how to connect Java to PostgreSQL using JDBC. Although most Java developers do not use this technique anymore, frameworks still do, and the

Read More...

PostgreSQL, Software Development

PostgreSQL – Create superusers If You Don’t Have Them

During the initial phase of our application development, we need superusers for our database, especially when we are starting with greenfield projects and no prior databases exist. Most of the

Read More...

PostgreSQL, Rust, Software Development

Rust – Connect to PostgreSQL Database Using Crate

Is this your sudden foray into Rust? Although not totally for beginners, this post shows how to connect to a PostgreSQL database from Rust. Note that we have updated the

Read More...

MySQL, PostgreSQL

Convert MySQL INSERT IGNORE to PostgreSQL

This post shows an example of the MySQL INSERT IGNORE statement in the PostgreSQL version. There are good reasons why you should use PostgreSQL at the onset or migrate to

Read More...

PostgreSQL, Software Development

Log In As Different User To pgAdmin 4 Web UI

This post shows how to log in as another user to pgAdmin 4 accessible via a web browser.

Read More...

Docker, PostgreSQL, Software Development

docker-compose.yml For PgAdmin And PostgreSQL

In this post, we’ll set up PgAdmin and PostgreSQL containers with docker-compose.yml for local development. We’ll also configure PgAdmin to access the PostgreSQL database under the same bridge network. Typically,

Read More...

PostgreSQL

List PostgreSQL Configuration Files Using SQL Select

SQL statement to list all locations of configuration files.

Read More...

Docker, PostgreSQL, Software Development

Using pgloader in docker container for host’s databases

This post demonstrates how to migrate from MySQL to PostgreSQL instance running in Windows using pgloader running in a Docker container.

Read More...