In this article, I will show you how to install PostgreSQL on Windows, MacOS and Docker
1. Install PostgreSQL on Docker
To install PostgreSQL on Docker is very simple, follow the steps below:
- In the terminal, go to drag its image:
1 2 | docker pull postgres |
By default, I will use the latest version. You can see its versions here https://hub.docker.com/_/postgres .
- To use a specific version, you can add the following statement on the version you want to use:
1 2 | docker pull postgres:12.12 |
- Then you can check whether the image has been pulled or not as follows:
1 2 | docker images |
- The last step is to run the following command and you already have a PostgreSQL to use:
1 2 | docker run --name postgres-db -e POSTGRES_USER=huytx -e POSTGRES_PASSWORD=huy123 -p 5432:5432 -v /data:/var/lib/postgresql/data -d postgres |
Let me explain the following command a bit:
- –name in this parameter will pass up the name of the container you want to set, here I set it as postgres-db .
- -e POSTGRES_USER this is the parameter passed to name the user using PostgreSQL, if not, the default is postgres , guys, here, I’m passing it on as huytx .
- -e POSTGRES_PASSWORD this is the parameter passed to set the password for the user just created above, this is a mandatory variable so there is no default value, the value I left in the above command is huy123 .
- -p 5432:5432 this is the port setting parameter that will be mapped between the docker container and the host machine, I leave it here as port 5432.
- -v this is the parameter that will help the container mount the data folder outside the host machine, ensuring that the data will not be lost when the container is suddenly lost.
- -d add this parameter the container will run in detached mode ie running in the background.
- postgres this parameter indicates the image we just pulled above.
Using docker-compose:
First you create the file docker-compose.yml then copy the content below into the file and run the command:
1 2 | docker-compose up -d |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 | version: '3.5' services: postgres: container_name: postgres_db image: postgres environment: POSTGRES_USER: postgres POSTGRES_PASSWORD: postgres PGDATA: /data/postgres volumes: - ./data:/data/postgres ports: - "5432:5432" networks: - postgres restart: always networks: postgres: driver: bridge volumes: postgres: |
That’s it, you guys have something to play with, check the results you just set up above:
1 2 | docker ps |
2. Install PostgreSQL on MacOS and Windows
To install PostgreSQL on MacOS or Windows, go to this page and download it according to your operating system https://www.postgresql.org/download/
At the last step, it will ask if you want to install any more tools, check it if there is no need and complete it.
After the installation is complete, PostgreSQL will come with PgAdmin, please open it and enjoy
Thank you for reading this far, if you find it useful, give me an upvote to be motivated to make more posts.