How to install and persist the postgresql database in docker

Skip the Docker installation steps

1. Pull the postgresql image

docker pull postgresql

2. Create a local volume. The data volume can be shared and reused between containers. By default, it will always exist even if the container is deleted ( docker volume inspect pgdata can view the local location of the data volume)

docker volume create pgdata

3. Start the container

docker run --name postgres2 -e POSTGRES_PASSWORD=password -p
5432:5432 -v pgdata:/var/lib/postgresql/data -d postgres 

4. Enter the postgres container and execute SQL

docker exec -it postgres2 bash
psql -h localhost -p 5432 -U postgres --password 

At this point, postgresql is installed successfully.

Supplement: Let's see how to install postgresql in docker

Pull the image

docker pull postgres:9.6

Start the container

Create the /usr/postgresql/data folder for persistence

docker run --name postgres -e
POSTGRES_PASSWORD=password -p 
5432:5432 -v /usr/postgresql/data:/var/lib/postgresql/data -d postgres

Enter postgresql

# Enter the container docker exec -it postgres /bin/bash
# Enter the folder cd /usr/lib/postgresql/9.6/bin
# Enter postgresql, the default postgres user psql -Upostgres

This is the end of this article about the steps to install and persist the postgresql database in docker. For more information about installing the postgresql database in docker, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!