To see more details on installing and configuration of docker and dbeaver and portainer, see this post:
https://sqlkitty.home.blog/2019/12/15/setting-up-docker-with-sql-server-backup-on-mac/
Create a docker volume to have persistent data
docker volume create pgdata
Create posgresql instance (note we are changing the port to 54320 in case 5432 is already in use on your computer:
docker run –name postgres -e POSTGRES_PASSWORD=Putstrongpassw0rdhere! -d -p 54320:5432 -v pgdata:/var/lib/postgresql/data postgres:11
See what containers you have and what is and isn’t running. You should see postgresql listed and running:
docker ps -a
You could also go into Portainer to see the status of your postgresql container if you have Portainer setup
Setup postgresql in dbeaver like below:
Connect to postgresql db in dbeaver and create a new db
create database testdatabase
I want copy data from sql server to postgresql, so I selected all the tables in dbeaver and right-click and say export data
Also, select all the tables and say generate DDL for all the tables
then export as insert sql files and save locally
then run the DDL and insert sql files in postgresql instance in dbeaver
I had to fix the issues in the DDL script since it was scripted from SQL Server so there are keyword and data types and characters not allowed when running postgresql
Search for specific file in docker container
docker export postgres | tar tf – | grep dump