To run PostgreSQL on docker, create a directory for saving the data presistant
|
1 |
mkdir -p /opt/my-postgresql |
run docker container
|
1 2 3 4 5 6 7 |
docker run --name my-postgresql \ -p 5432:5432 \ -e POSTGRES_PASSWORD=serverok123 \ -e POSTGRES_USER=serverok \ -e POSTGRES_DB=serverok \ -v /opt/my-postgresql:/var/lib/postgresql/data \ -d postgres |
In above, change the value for POSTGRES_DB, POSTGRES_USER and POSTGRES_PASSWORD as needed. Connect to PostgreSQL server To connect to PostgreSQL server, run
|
1 |
docker container exec -ti my-postgresql bash |
Now you are inside PostgreSQL conainer, to login, run
|
1 |
psql -U serverok -W |
It will ask for […]
