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, Rust, Software Development

Rust – Connect to PostgreSQL

This post is about how to connect to PostgreSQL from Rust.

Read More...

Docker, PostgreSQL, Software Development

docker-compose.yml for PostgreSQL

This post provides a basic docker-compose.yml to create a PostgreSQL container with initial user account with password.

Read More...

MySQL, PostgreSQL, Software Development

Convert MySQL INSERT IGNORE to PostgreSQL

Convert MySQL Insert Ignore to PostgreSQL.

Read More...

PostgreSQL, Software Development

PostgreSQL – Log in as different user to pgAdmin 4 Web user interface

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

Read More...

PostgreSQL, Software Development

PostgreSQL – Create superusers

PostgreSQL represents users as roles. There are roles that can log in called login roles. There are roles contain other roles. There are roles that both can log in and contain other roles.

Read More...

PostgreSQL

PostgreSQL – Terminate active connections

SQL statement to terminate active connections

Read More...

PostgreSQL

PostgreSQL – List settings defined in postgresql.conf and overriden by postgresql.auto.conf

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

Read More...

PostgreSQL

PostgreSQL – List locations of configuration files

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...