Running PostgreSQL in Docker and recommending several connection tools

1 Introduction

  PostgreSQL is a free software object-relational database management system (ORDBMS) with a very complete set of features. It is an object-relational database management system based on POSTGRES version 4.2 developed by the Department of Computer Science at the University of California. Many of the leading concepts of POSTGRES appeared in commercial Web databases only later. PostgreSQL supports most of the SQL standard and provides many other modern features, such as complex queries, foreign keys, triggers, views, transaction integrity, multi-version concurrency control, etc. Likewise, PostgreSQL can be extended in many ways, such as by adding new data types, functions, operators, aggregate functions, indexing methods, procedural languages, and so on. In addition, because of the flexibility of the license, anyone can use, modify, and distribute PostgreSQL for any purpose free of charge.

PostgreSQL is an excellent open source relational database that is being adopted by more and more projects. Starting with Docker is very convenient in development and testing environments, and one command is enough. Don’t worry about situations where you need multiple environments. At the same time, some clients are introduced.

2 Docker startup

First, pull the image. Here, select version 10. For more versions, see [Postgres Docker].

docker pull postgres:10

Start an instance with the following command:

docker run -itd \
    --name pkslow-postgres \
    -e POSTGRES_DB=pkslow \
    -e POSTGRES_USER=pkslow \
    -e POSTGRES_PASSWORD=pkslow \
    -e PGDATA=/var/lib/postgresql/data/pgdata \
    -v /custom/mount:/var/lib/postgresql/data \
    -p 5432:5432 \
    postgres:10

3 Client Connection

There are many excellent clients, here are a few free ones.

DBeaver supports multiple databases, such as PostgreSQL/MySQL/DB2/Oracle, etc., supports Mac/Win/Linux, and also supports Chinese, which is quite comprehensive.

pgAdmin is a web-based client tool.

PSequel is a PostgreSQL client tool for Mac.

Postico is also a client tool for Mac.

4 Conclusion

With so many clients, I ended up with DBeaver, or using IDEA or DataGrip to connect. In addition, SQLPro is good, but it is charged and very expensive.

This is the end of this article about running PostgreSQL in Docker and recommending several connection tools. For more information about starting PostgreSQL with Docker, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!