I use it for virtual environment when I need run Postgres SQL, PG Admin and MS SQL Express. In my case I use Ubuntu server 20.04 for docker host. Checked in Redos server 7.3.2 with Postgres and PostgresPRO.
Clone git-repo
git clone https://github.com/2s3vhbs99o/docker-pg-ms-sql-pgadmin.git
Go to repo folder
cd ./pgsql-pgadmin-mssql
Fill variable values in .env file
vim .env
- For Postgres:
- For PG Admin:
PG_TAG
islatest
. Possible values herePG_EMAIL
provide a login email.PG_PASSWORD
provide a password for login.
- For MS SQL:
MSDB_TAG
possible values:2022-latest, 2019-latest, 2017-latest
, full tag listing here.MSDB_PASSWORD
is a password for MS SQL sysadmin -SA
.MSSQL_PID
possible values:Evaluation, Developer, Express, Web, Standard, Enterprise or A product key: #####-#####-#####-#####-#####
.TZ
a time zone for container, the list of time zones here.
Run docker-compose
docker compose up -d
Open PG Admin console
-
In browser open PG Admin console: http://<ip_of_docker_server> and use values from
$PG_EMAIL
and$PG_PASSWORD
for login. -
In PG Admin console connect to Postrges SQL server use default db
postgres
and values from$DB_USER
and$DB_PASSWORD
. The connection can be possible to the server through the valuepassword
in$DB_PHAM
. -
In MS SSMS connect to MS SQL server use default user
SA
and password from value$SA_PASSWORD
.
MIT