apazga / docker-pgmodeler

pgModeler running in a Docker container

pgModeler Docker container

This image compiles & run pgModeler inside a Docker container.

Usage

Windows

1. Install X11 Manager for Windows, like vcxsrv (easiest way is using winget or chocolatey)

   winget install vcxsrv

   or

   choco install vcxsrv

   And configure it running XLaunch for multiple windows, start no client, check "disable access control" and IMPORTANT: SAVE the config to Desktop or %APPDATA%/Xming

2. Set environment variable (replacing your IP address, using 192.168.1.100 as a sample)

   Set-Variable -name DISPLAY -value 192.168.1.100:0.0

3. Run docker container

   docker run -ti -e DISPLAY=$DISPLAY apazga/docker-pgmodeler

   Use it with volumes if needed (e.g. to save!):

   docker run -ti -e DISPLAY=$DISPLAY -v F:\data\root:/root apazga/docker-pgmodeler:1.1.2

   You can also specify your DISPLAY IP directly if you don't want to define an environment variable:

   docker run -ti -e DISPLAY=192.168.1.100:0.0 -v F:\data\root:/root apazga/docker-pgmodeler:1.1.2

Windows (PowerShell script)

To ease launch of pgmodeler, make a copy of the run.ps1.example and name it run.ps1. Feel free to modify the environment variables inside the file. Making a copy will avoid losing your settings when you will update the repository.

Linux

Make a copy of the .env.linux.example file and name it .env.linux. Feel free to modify the environment variables.

Then use the provided script run.sh.

MacOS

Check first this Medium post and this Gist by @yuryalencar

On MacOS (following instructions tested on MacOS Big Sure), if you wish to run this image, you need to install XQuartz. With brew installed, do this:

brew install xquartz

Then open Xquartz and allow connections:

xquartz > preferences > security > [mark to allow connections from network clients]

Add the following line to your .zshrc:

export DISPLAY=:0

You can test XQuartz right now with the command xeyes. It should launch a little graphical app.

Then make a copy of the .env.macos.example file and name it .env.macos. Feel free to modify the environment variables.

Finally, make sure XQuartz is started and launch the script run_macos.sh.

I may have forgotten some steps, if any problem please open an issue.

Build image

If you want to build the image using the Dockerfile provided (it can take a while!)

docker build -t apazga/docker-pgmodeler .

Tags

• 0.9.1
• 0.9.2-alpha
• 0.9.2-alpha1
• 0.9.2-beta
• 0.9.2
• 0.9.3-beta1
• 0.9.3
• 0.9.4-alpha
• 0.9.4-beta
• 0.9.4-beta1
• 0.9.4
• 1.0.0-alpha
• 1.0.0-alpha1
• 1.0.0-beta
• 1.0.0-beta1
• 1.0.0
• 1.0.1
• 1.0.2
• 1.0.3
• 1.0.4
• 1.1.0-alpha
• 1.0.5
• 1.0.6
• 1.0.7
• 1.1.0
• 1.1.1
• 1.1.2

Full changelog: https://github.com/pgmodeler/pgmodeler/blob/v1.1.2/CHANGELOG.md

Contributors

• rbrdevs (PowerShell script enhancement)
• Merinorus (MacOS script & PowerShell script enhancement)
• yuryalencar (Medium post & Gist for MacOS users)

Acknowledgment

Thanks rkhaotix for your amazing work with pgModeler, a reference (and open source) tool to PostgreSQL community.

docker-pgmodeler's Issues

General.conf :unable to write the file

Hello,

I have successfully downloaded and run the docker image for pgModeler, but I am encountering an error when saving the settings. The error message reads: "Unable to write the file /root/.config/pgmodeler-1.0/general.conf due to one or more errors in the definition generation process."
I don't know if the last 2 error is linked to my problem.

Thank you in advance.

Install on M1 Mac (running Sonoma) Failed

I'm not sure if I did something wrong or not, but I couldn't get this work on my M1 Mac (running Sonoma).

./run_macos.sh
access control disabled, clients can connect from any host
HOST_IP: 192.168.1.235
Unable to find image 'apazga/docker-pgmodeler:1.1.0' locally
1.1.0: Pulling from apazga/docker-pgmodeler
01007420e9b0: Pull complete
84468a1d9db1: Pull complete
4f4fb700ef54: Pull complete
e2c1cf881a89: Pull complete
121dc5ebe34b: Pull complete
79df955cbd06: Pull complete
447d4c352730: Pull complete
Digest: sha256:22de87f1c1f2c68c5d8379b87b896127a5e5cb699ab5434c1a0c13c753742276
Status: Downloaded newer image for apazga/docker-pgmodeler:1.1.0
WARNING: The requested image's platform (linux/amd64) does not match the detected host platform (linux/arm64/v8) and no specific platform was requested
qt.qpa.xcb: could not connect to display 192.168.1.235:0
qt.qpa.plugin: Could not load the Qt platform plugin "xcb" in "" even though it was found.
This application failed to start because no Qt platform plugin could be initialized. Reinstalling the application may fix this problem.

Available platform plugins are: eglfs, linuxfb, minimal, minimalegl, offscreen, vkkhrdisplay, vnc, xcb.

qt.qpa.xcb: could not connect to display 192.168.1.235:0
qt.qpa.plugin: Could not load the Qt platform plugin "xcb" in "" even though it was found.
This application failed to start because no Qt platform plugin could be initialized. Reinstalling the application may fix this problem.

Available platform plugins are: eglfs, linuxfb, minimal, minimalegl, offscreen, vkkhrdisplay, vnc, xcb.

Aborted

QXcbConnection: Could not connect to display

Hi there,

I downloaded the image and tried to run it using the sh script replacing the 192.168.0.100:0.0 ip by my local ip, but is raising the following error:

QXcbConnection: Could not connect to display <<"my-ip-address">>

Can you give some hint?