Postgres SQL, PG Admin and MS SQL

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.

Prerequisites

• Git
• Docker

How to use

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:
  • DB_TAG is latest. Possible values here.
  • DB_USER provide a superuser
  • DB_PASSWORD is a password for superuser
  • DB_PHAM is POSTGRES_HOST_AUTH_METHOD. More information about it here.
• For PG Admin:
  • PG_TAG is latest. Possible values here
  • PG_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 value password in $DB_PHAM.

• In MS SSMS connect to MS SQL server use default user SA and password from value $SA_PASSWORD.

License

MIT