SQL statements to list settings defined in postgresql.conf and overriden by postgresql.auto.conf.
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, we don’t deploy a PgAdmin container alongside a PostgreSQL container
Migrate from MySQL to PostgreSQL Using Pgloader Docker Container
This post shows how to migrate a database from MySQL to a PostgreSQL instance running on Windows using the pgloader (running as a Docker container) to perform the migration from MySQL to PostgreSQL. From within the container, we use docker.for.win.localhost
docker-compose.yml for PostgreSQL
This post provides a basic docker-compose.yml to create a PostgreSQL container with initial user account with password.
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 post shows how to terminate active connections using some SQL
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 codes are abstracted away from us. Meanwhile, some may still
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 time, we use this type of user to run DDL
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 content of this post to use a newer version of
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 it as soon as possible. One reason is you cannot
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.