<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Mattias Glaving on Medium]]></title>
        <description><![CDATA[Stories by Mattias Glaving on Medium]]></description>
        <link>https://medium.com/@mglaving?source=rss-8224acde60fd------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*uLatJKMWL6ZLCE4z.</url>
            <title>Stories by Mattias Glaving on Medium</title>
            <link>https://medium.com/@mglaving?source=rss-8224acde60fd------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 07:39:39 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@mglaving/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Compiling and installing pgModeler 2.x on Debian Linux derivatives — Ubuntu, Mint, Pop!_OS, etc]]></title>
            <link>https://medium.com/@mglaving/compiling-and-installing-pgmodeler-2-x-on-debian-linux-derivatives-ubuntu-mint-pop-os-etc-9c22e66d23d1?source=rss-8224acde60fd------2</link>
            <guid isPermaLink="false">https://medium.com/p/9c22e66d23d1</guid>
            <category><![CDATA[data-modeling]]></category>
            <category><![CDATA[compilation]]></category>
            <category><![CDATA[pgmodeler]]></category>
            <dc:creator><![CDATA[Mattias Glaving]]></dc:creator>
            <pubDate>Sat, 15 Nov 2025 08:45:17 GMT</pubDate>
            <atom:updated>2026-05-27T13:12:55.094Z</atom:updated>
            <content:encoded><![CDATA[<h3>Compiling and installing pgModeler 2.x on Debian Linux derivatives — Ubuntu, Mint, Pop!_OS, etc</h3><p>This tutorial describes how to build, install and run pgModeler 2.x on Debian Linux. It should also work on any recent Debian derivative like Ubuntu, Mint, Pop!_OS, etc.</p><p>pgModeler is a free and open-source multiplatform database modeler for PostgreSQL.</p><p>In Terminal type the following:</p><pre>##################################################<br>## Install PostgreSQL and other needed packages ##<br># Update the package lists and upgrade the system<br><br>sudo apt update &amp;&amp; sudo apt upgrade -y<br><br># Install the latest version of PostgreSQL<br>sudo apt install postgresql postgresql-common postgresql-contrib -y<br><br># Install build libs and tools<br>sudo apt install build-essential libxml2-dev perl libx11-xcb-dev \<br> ^libxcb.*-dev libfontconfig1-dev libfreetype6-dev libx11-dev \<br> libx11-xcb-dev libxext-dev libxfixes-dev libxi-dev libxrender-dev \<br> libxcb1-dev libxcb-glx0-dev libxcb-keysyms1-dev libxcb-image0-dev \<br> libxcb-shm0-dev libxcb-icccm4-dev \<br> libxcb-sync0-dev libxcb-xfixes0-dev \<br> libxcb-shape0-dev libxcb-randr0-dev libxcb-render-util0-dev \<br> libxkbcommon-dev libxkbcommon-x11-dev libxcb-xinerama0-dev \<br> libxcb-sync-dev libcups2-dev libpq-dev git \<br> cmake clang clang-tools \<br> freeglut3-dev binutils libglew-dev mesa-common-dev libglew-dev \<br> libglm-dev qt6-base-dev libqt6svg6* qt6-tools-dev-tools \<br> qt6-tools-dev -y<br><br># Install QT - needed as long as the Debian repos do not<br># include at least Qt v6.4<br>wget https://download.qt.io/official_releases/online_installers/qt-online-installer-linux-x64-online.run<br>chmod +x qt-online-installer-linux-x64-online.run<br>./qt-online-installer-linux-x64-online.run<br># Follow the prompts<br># Select Custom Install and select Qt 10 only<br># This will install Qt 10 in ~/Qt<br><br>##################################<br>## Set up the local environment ##<br><br>export PGMODELER_VERSION=v2.0.0-beta<br>export QT_VERSION=6.10.0<br>export QT_ARCH=gcc_64<br>#export QT_ROOT=/usr/lib # default debian<br>#export QT_LIB=/usr/lib/x86_64-linux-gnu # default debian<br>#export QT_LIB_PLUGINS=$QT_LIB/qt6/plugins # default debian<br>export QT_ROOT=~/Qt/6.10.0/gcc_64/bin<br>export QT_LIB=~/Qt/6.10.0/gcc_64/lib<br>export QT_LIB_PLUGINS=~/Qt/6.10.0/gcc_64/plugins<br>export PGMODELER_MAINDIR=~/code/pgmodeler2<br>export PGMODELER_SOURCE=$PGMODELER_MAINDIR/pgmodeler<br>export INSTALLATION_ROOT=$PGMODELER_MAINDIR/bin/$PGMODELER_VERSION<br>export INSTALLATION_BIN=$INSTALLATION_ROOT/bin<br>export PGMODELER_DESKTOP_SHORTCUT=~/Desktop/pgModeler-$(echo $PGMODELER_VERSION).desktop<br>export PROCESSORS=$(($(nproc) &gt; 1 ? $(nproc) - 1 : 1))<br>mkdir -p $INSTALLATION_ROOT/lib/qtplugins/platforms<br><br>##############################<br>## Fetch the pgModeler code ##<br># &#39;git clone&#39; needed first time only<br><br>cd $PGMODELER_MAINDIR<br>git clone https://github.com/pgmodeler/pgmodeler.git<br><br># Get the version we want<br>cd $PGMODELER_SOURCE<br>git pull<br>git checkout $PGMODELER_VERSION<br><br>###################<br>## Apply patches ##<br><br>sed -i &#39;s/QPalette::Accent/QPalette::Highlight/g&#39; \<br>libs/libgui/src/settings/appearanceconfigwidget.cpp<br><br>sed -i &#39;1i#include &lt;QApplication&gt; // for qApp&#39; \<br>~/code/pgmodeler2/pgmodeler/libs/libgui/src/tools/modelexporthelper.cpp<br><br>#######################<br>## Compile pgModeler ##<br><br>cd $PGMODELER_SOURCE &amp;&amp; \<br>echo &quot;Making...&quot; &amp;&amp; \<br>cmake -S . -B ./cmake-build \<br>  -DCMAKE_PREFIX_PATH=$QT_ROOT \<br>  -DCMAKE_BUILD_TYPE=Release \<br>  -DPGM_PREFIX=$INSTALLATION_ROOT \<br>  --fresh &amp;&amp; \<br>echo &quot;Building...&quot; &amp;&amp; \<br>cmake --build ./cmake-build --target all -j$PROCESSORS<br>echo &quot;Installing...&quot; &amp;&amp; \<br>cmake --install ./cmake-build/<br><br>####################################<br>## Resolve pgModeler dependencies ##<br><br>echo -e \<br> &quot;[Paths]\nPrefix=.\nPlugins=lib/qtplugins\nLibraries=lib&quot; \<br> &gt; $INSTALLATION_ROOT/qt.conf<br><br>cd $QT_LIB<br>cp libQt6DBus.so.6 libQt6PrintSupport.so.6 \<br> libQt6Widgets.so.6 libQt6Network.so.6 libQt6Gui.so.6 \<br> libQt6Core.so.6 libQt6XcbQpa.so.6 libQt6Svg.so.6 \<br> libicui18n.so.* libicuuc.so.* libicudata.so.* \<br> $INSTALLATION_ROOT/lib<br><br>cd $QT_LIB_PLUGINS<br>cp -r iconengines/ $INSTALLATION_ROOT/lib/qtplugins/<br>cp -r imageformats/ $INSTALLATION_ROOT/lib/qtplugins/<br>cp -r platforminputcontexts/ $INSTALLATION_ROOT/lib/qtplugins/<br>cp -r platforms/libqxcb.so platforms/libqoffscreen.so \<br>$INSTALLATION_ROOT/lib/qtplugins/platforms<br>cp -r printsupport/ $INSTALLATION_ROOT/lib/qtplugins/<br>cp -r tls/ $INSTALLATION_ROOT/lib/qtplugins/<br>cp -r xcbglintegrations/ $INSTALLATION_ROOT/lib/qtplugins/<br><br>cp -r $PGMODELER_SOURCE/assets $INSTALLATION_ROOT<br><br>###################<br>## Run pgModeler ##<br><br># Run pgModeler from the terminal<br>cd $INSTALLATION_BIN &amp;&amp; export LD_LIBRARY_PATH=$(pwd)/lib &amp;&amp; ./pgmodeler &amp;<br><br># Create Desktop shortcut<br>echo [Desktop Entry] &gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Comment=Starts pgModeler $(echo $PGMODELER_VERSION) &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo &#39;Exec=sh -c &quot;cd &#39;$(echo $INSTALLATION_BIN)&#39; &amp;&amp; export LD_LIBRARY_PATH=&#39;$(echo $INSTALLATION_BIN)&#39;/lib &amp;&amp; ./pgmodeler&quot;&#39; &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo GenericName=pgModeler $(echo $PGMODELER_VERSION) &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Icon=$INSTALLATION_ROOT/assets/conf/pgmodeler_logo.png &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo &quot;Categories=Development;&quot; &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Name=pgModeler $(echo $PGMODELER_VERSION) &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Type=Application &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Terminal=false &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>gio set $PGMODELER_DESKTOP_SHORTCUT metadata::trusted true<br>chmod +x $PGMODELER_DESKTOP_SHORTCUT<br># Now double-click the pgModeler shortcut on the Desktop to launch pgModeler<br># If double-clicking does not work:<br># Right-click on the pgModeler desktop icon and select &#39;Allow Launching&#39;<br># Then double-click on the pgModeler shortcut on the desktop again<br># Add to menu<br><br>cp $PGMODELER_DESKTOP_SHORTCUT ~/.local/share/applications</pre><p>Verified on May 27th 2026 on Debian Linux with the latest updates installed.</p><h3>Links</h3><p><a href="https://pgmodeler.io/">pgModeler - PostgreSQL Database Modeler</a></p><p><em>Originally published at </em><a href="https://medium.com/@mglaving/compiling-and-installing-pgmodeler-1-1-4-on-debian-linux-b4662a8520a6?postPublishedType=repub"><em>https://medium.com</em></a><em> on November 15, 2025.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=9c22e66d23d1" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to install PostgreSQL 17 on Linux Mint 21]]></title>
            <link>https://medium.com/@mglaving/how-to-install-postgresql-17-on-linux-mint-21-0c8208f9318a?source=rss-8224acde60fd------2</link>
            <guid isPermaLink="false">https://medium.com/p/0c8208f9318a</guid>
            <category><![CDATA[tutorial]]></category>
            <category><![CDATA[linux-mint]]></category>
            <category><![CDATA[postgresql]]></category>
            <category><![CDATA[installation]]></category>
            <dc:creator><![CDATA[Mattias Glaving]]></dc:creator>
            <pubDate>Fri, 27 Sep 2024 19:13:24 GMT</pubDate>
            <atom:updated>2024-09-27T19:15:04.299Z</atom:updated>
            <content:encoded><![CDATA[<p>To install PostgreSQL 17 on Linux Mint at the time of writing we’ll need to use the PostgreSQL official repo.</p><p>The PostgreSQL <strong>jammy</strong> repo is compatible with Linux Mint 21.</p><p>Recommended: create a snapshot of your Mint box before starting.</p><p>Type the following in the Terminal of your Mint box:</p><pre># Create the file repository configuration:<br>sudo sh -c \<br>  &#39;echo &quot;deb http://apt.postgresql.org/pub/repos/apt jammy-pgdg main&quot; \<br>  &gt; /etc/apt/sources.list.d/pgdg.list&#39;<br><br># Import the repository signing key:<br>wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | \<br>  sudo apt-key add -<br><br># Update the package lists and the system:<br>sudo apt update &amp;&amp; sudo apt upgrade -y<br><br># Install the latest version of PostgreSQL.<br># If you want a specific version, use &#39;postgresql-15&#39; or similar<br># instead of &#39;postgresql&#39;:<br>sudo apt install postgresql -y<br><br># Check status<br>service postgresql status<br>sudo netstat -tulpn | grep postgres<br><br>#########################<br># The below is optional #<br>#########################<br><br>###########################<br># Allow remote connections<br># Set listen to all addresses<br>sudo pico /etc/postgresql/17/main/postgresql.conf<br><br># Set the following line in postgresql.conf:<br>listen_addresses = &#39;*&#39;<br><br># Set allow remote connections - do this on your own peril<br>sudo pico /etc/postgresql/17/main/pg_hba.conf<br><br># Add the following lines in pg_hba.conf:<br># TYPE  DATABASE USER    ADDRESS         METHOD<br>host    all      all     0.0.0.0/0       md5<br>host    all      all     ::/0            md5<br><br># Restart the service<br>sudo systemctl restart postgresql<br><br># Open firewall - do this on your own peril<br>sudo ufw allow 5432<br><br>#######################<br># Locales<br># Even though the locale seem to be there it does not always work<br># and then it can sometimes be fixed by a reconfig.<br># If a locale needed does not exist, eg: sv_SE.UTF-8:<br>cat /etc/locale.gen | grep sv_SE.UTF-8<br><br># then generate it with<br>sudo dpkg-reconfigure locales  <br><br># the server may need a restart to pick up the new locales<br>sudo service postgresql restart<br><br>#####################<br># pg_cron - cron jobs in the DB<br><br># Install<br>sudo apt install postgresql-17-cron<br><br># set this in postgresql.conf:<br>shared_preload_libraries = &#39;pg_cron&#39;<br><br># restart the cluster<br>sudo service postgresql restart<br><br># Execute this command in the DB where cron should run:<br>CREATE EXTENSION pg_cron;<br><br># Example cron command to purge pg_cron log table at 3.22 am every day - keep 7 days worth of data<br>SELECT cron.schedule(&#39;22 3 * * *&#39;, $$DELETE FROM cron.job_run_details WHERE end_time &lt; now() - interval &#39;7 days&#39;$$);<br><br># view all cron jobs<br>SELECT * FROM cron.job;<br>SELECT * FROM cron.job_run_details ORDER BY runid DESC LIMIT 20;<br><br># update the schedule for cron job &#39;SELECT &quot;auth&quot;.&quot;purge&quot;()&#39;<br>SELECT cron.schedule(&#39;* * * * *&#39;, &#39;SELECT &quot;auth&quot;.&quot;purge&quot;()&#39;) WHERE jobid = &lt;job_id&gt;;<br><br>################################<br># Useful commands<br>sudo -u postgres psql -c &quot;SHOW config_file;&quot; <br>service postgresql status<br>sudo service postgresql restart<br>ps -ef | grep postgres<br>sudo netstat -tulpn | grep 5432<br>sudo netstat -tulpn | grep postgres<br>sudo netstat -tulpn | grep node<br>cat /etc/postgresql/17/main/postgresql.conf | grep pg_hba<br>cat /etc/postgresql/17/main/postgresql.conf | grep listen_addresses<br>cat /etc/postgresql/17/main/postgresql.conf | grep port<br>tail -f /var/log/postgresql/postgresql-17-main.log<br><br># on the machine where the db is located<br>sudo su postgres<br>psql<br><br># Connect to AWS DB available from Internet<br>psql -h &lt;host_url&gt; -d &lt;db_name&gt; -U &lt;db_username&gt; -W -p 5432<br><br># tunnelling<br># Set up ssh tunnel from port 5438 on the local machine to port 5432 on<br># the remote server<br># if &lt;remote_ssh_port&gt; is 22 then this is not needed: -p &lt;remote_ssh_port&gt;<br># &lt;remote_host&gt; can be a fully qualified hostname or an ip<br>ssh &lt;db_user&gt;@&lt;remote_host&gt; -p &lt;remote_ssh_port&gt; -L 5438:&lt;remote_host&gt;:5432 -N -v -C -v -v<br><br># Potentially useful psql commands<br>help (show help)<br>\? (show all psql commands)<br>\h (show all DML commands)<br>\h create database (show help for the DML command &#39;create database&#39;)<br>\l (list databases)<br>\l+ (list databases with storage info)<br>\connect dbname (connect to database dbname)<br><br># Potentially useful tools<br>* pgModeler<br>* pgAdmin 4<br>* dbeaver<br>* btop</pre><p><a href="https://www.postgresql.org/about/news/postgresql-17-released-2936/">PostgreSQL 17 Released!</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=0c8208f9318a" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Compiling and installing pgModeler 1.x on Debian Linux derivatives — Ubuntu, Mint, Pop!_OS, etc]]></title>
            <link>https://medium.com/@mglaving/compiling-and-installing-pgmodeler-1-1-4-on-debian-linux-b4662a8520a6?source=rss-8224acde60fd------2</link>
            <guid isPermaLink="false">https://medium.com/p/b4662a8520a6</guid>
            <category><![CDATA[postgresql]]></category>
            <category><![CDATA[data-modeling]]></category>
            <category><![CDATA[debian]]></category>
            <category><![CDATA[compile]]></category>
            <category><![CDATA[pgmodeler]]></category>
            <dc:creator><![CDATA[Mattias Glaving]]></dc:creator>
            <pubDate>Sun, 01 Sep 2024 11:18:56 GMT</pubDate>
            <atom:updated>2025-11-15T08:44:58.285Z</atom:updated>
            <content:encoded><![CDATA[<p>This tutorial describes how to build, install and run pgModeler 1.x on Debian Linux. It should also work on any recent Debian derivative like Ubuntu, Mint, Pop!_OS, etc.</p><p>pgModeler is a free and open-source multiplatform database modeler for PostgreSQL.</p><p>In Terminal type the following:</p><pre>##################################################<br>## Install PostgreSQL and other needed packages ##<br><br># Update the package lists and update the system<br>sudo apt update &amp;&amp; sudo apt upgrade -y<br><br># Install the latest version of PostgreSQL<br>sudo apt install postgresql postgresql-common postgresql-contrib -y<br><br># Install build libs and tools<br>sudo apt install build-essential libxml2-dev perl libx11-xcb-dev \<br> ^libxcb.*-dev libfontconfig1-dev libfreetype6-dev libx11-dev \<br> libx11-xcb-dev libxext-dev libxfixes-dev libxi-dev libxrender-dev \<br> libxcb1-dev libxcb-glx0-dev libxcb-keysyms1-dev libxcb-image0-dev \<br> libxcb-shm0-dev libxcb-icccm4-dev libxcb-sync0-dev libxcb-xfixes0-dev \<br> libxcb-shape0-dev libxcb-randr0-dev libxcb-render-util0-dev \<br> libxkbcommon-dev libxkbcommon-x11-dev libxcb-xinerama0-dev \<br> libxcb-sync-dev libcups2-dev libpq-dev git g++ cmake \<br> freeglut3-dev binutils libglew-dev mesa-common-dev libglew-dev \<br> libglm-dev qt6-base-dev libqt6svg6* qt6-tools-dev-tools \<br> qt6-tools-dev -y<br><br>##################################<br>## Set up the local environment ##<br>export QT_VERSION=6.2.4<br>export QT_ARCH=gcc_64<br>export QT_ROOT=/usr/lib/qt6<br>export QT_LIB=/usr/lib/x86_64-linux-gnu<br>export QT_LIB_PLUGINS=$QT_LIB/qt6/plugins<br>export PGMODELER_MAINDIR=~/code/pgmodeler<br>export PGMODELER_SOURCE=~/code/pgmodeler/pgmodeler<br>export PGMODELER_VERSION=v1.2.2<br>export INSTALLATION_ROOT=~/code/pgmodeler/bin/$PGMODELER_VERSION<br>export PGMODELER_DESKTOP_SHORTCUT=~/Desktop/pgModeler-$(echo $PGMODELER_VERSION).desktop<br>export PKG_CONFIG_PATH=/usr/lib/x86_64-linux-gnu/pkgconfig/<br>mkdir -p \<br> $INSTALLATION_ROOT/lib/qtplugins/imageformats \<br> $INSTALLATION_ROOT/lib/qtplugins/printsupport \<br> $INSTALLATION_ROOT/lib/qtplugins/platforms \<br> $INSTALLATION_ROOT/lib/qtplugins/tls<br><br>#######################<br>## Compile pgModeler ##<br><br># Get the pgModeler repo<br><br>cd $PGMODELER_MAINDIR<br>git clone https://github.com/pgmodeler/pgmodeler.git<br>cd $PGMODELER_SOURCE<br>git pull<br>git checkout $PGMODELER_VERSION<br><br># Configure the pgModeler build<br>cd $PGMODELER_SOURCE<br>$QT_ROOT/bin/qmake -r CONFIG+=release \<br> PREFIX=$INSTALLATION_ROOT \<br> BINDIR=$INSTALLATION_ROOT \<br> PRIVATEBINDIR=$INSTALLATION_ROOT \<br> PRIVATELIBDIR=$INSTALLATION_ROOT/lib \<br> pgmodeler.pro<br><br># Build pgModeler<br>cd $PGMODELER_SOURCE<br>make -j$(($(nproc) &gt; 1 ? $(nproc) - 1 : 1)) &amp;&amp; make install<br><br># Resolve pgModeler dependencies<br>cd $QT_LIB<br>cp libQt6DBus.so.6 libQt6PrintSupport.so.6 libQt6Widgets.so.6 \<br> libQt6Network.so.6 libQt6Gui.so.6 libQt6Core.so.6 libQt6XcbQpa.so.6 \<br> libQt6Svg.so.6 libQt6OpenGL.so.6 libicui18n.so.* libicuuc.so.* \<br> libicudata.so.* \<br> $INSTALLATION_ROOT/lib<br>cd $QT_LIB_PLUGINS<br>cp -r imageformats/libqgif.so imageformats/libqico.so \<br> imageformats/libqjpeg.so imageformats/libqsvg.so \<br> $INSTALLATION_ROOT/lib/qtplugins/imageformats<br>cp -r printsupport/libcupsprintersupport.so \<br> $INSTALLATION_ROOT/lib/qtplugins/printsupport<br>cp -r platforms/libqxcb.so platforms/libqoffscreen.so \<br> $INSTALLATION_ROOT/lib/qtplugins/platforms<br>cp -r tls/* \<br> $INSTALLATION_ROOT/lib/qtplugins/tls<br>echo -e \<br> &quot;[Paths]\nPrefix=.\nPlugins=lib/qtplugins\nLibraries=lib&quot; \<br> &gt; $INSTALLATION_ROOT/qt.conf<br><br>###################<br>## Run pgModeler ##<br><br># Only if needed - view or (re)create pgModeler runtime config files<br>ls -lah ~/.config/pgmodeler-1.2<br>rm -rf ~/.config/pgmodeler-1.2<br>cd $INSTALLATION_ROOT &amp;&amp; ./pgmodeler-cli -cc -mo<br><br># Run pgModeler from the terminal<br>cd $INSTALLATION_ROOT &amp;&amp; export LD_LIBRARY_PATH=$(pwd)/lib &amp;&amp; ./pgmodeler &amp;<br><br># Create Desktop shortcut<br>echo [Desktop Entry] &gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Comment=Starts pgModeler $(echo $PGMODELER_VERSION) &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo &#39;Exec=sh -c &quot;cd ~/code/pgmodeler/bin/&#39;$(echo $PGMODELER_VERSION)&#39; &amp;&amp; export LD_LIBRARY_PATH=$(pwd)/lib &amp;&amp; ./pgmodeler&quot;&#39; &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo GenericName=pgModeler $(echo $PGMODELER_VERSION) &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Icon=~/code/pgmodeler/bin/$(echo $PGMODELER_VERSION)/share/pgmodeler/conf/pgmodeler_logo.png &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo &quot;Categories=Development;&quot; &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Name=pgModeler $(echo $PGMODELER_VERSION) &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Type=Application &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Terminal=false &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>gio set $PGMODELER_DESKTOP_SHORTCUT metadata::trusted true<br>chmod +x $PGMODELER_DESKTOP_SHORTCUT<br># Now double-click the pgModeler shortcut on the Desktop to launch pgModeler<br># If double-clicking does not work:<br>#   Right-click on the pgModeler desktop icon and select &#39;Allow Launching&#39;<br>#   Then double-click on the pgModeler shortcut on the desktop again<br><br># Add to menu<br>cp $PGMODELER_DESKTOP_SHORTCUT ~/.local/share/applications</pre><p>Verified on October 18th 2025 on Debian Linux with the latest updates installed.</p><ul><li><a href="https://www.debian.org/">The Operating System</a></li><li><a href="https://pgmodeler.io/">pgModeler - PostgreSQL Database Modeler</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b4662a8520a6" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Javascript HMAC SHA256 in Nodejs]]></title>
            <link>https://medium.com/@mglaving/javascript-hmac-sha256-in-nodejs-dfd8d2a6897c?source=rss-8224acde60fd------2</link>
            <guid isPermaLink="false">https://medium.com/p/dfd8d2a6897c</guid>
            <category><![CDATA[javascript]]></category>
            <category><![CDATA[nodejs]]></category>
            <category><![CDATA[hmacsha256]]></category>
            <dc:creator><![CDATA[Mattias Glaving]]></dc:creator>
            <pubDate>Sat, 24 Aug 2024 06:44:38 GMT</pubDate>
            <atom:updated>2024-08-24T06:44:38.849Z</atom:updated>
            <content:encoded><![CDATA[<p>Javascript HMACSHA256 utility functions for Node.</p><pre>const crypto = require(&#39;crypto&#39;);<br><br>const hmacSha256 = (key, message) =&gt;<br>  crypto.createHmac(&#39;sha256&#39;, key).update(message);<br><br>const hmacSha256Hex = (key, message) =&gt;<br>  crypto.createHmac(&#39;sha256&#39;, key).update(message).digest(&#39;hex&#39;);<br><br>const hmacSha256Base64 = (key, message) =&gt;<br>  crypto.createHmac(&#39;sha256&#39;, key).update(message).digest(&#39;base64&#39;);</pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=dfd8d2a6897c" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Compiling pgModeler 1.1.0 for CockroachDB on Linux Mint guide — experimental]]></title>
            <link>https://medium.com/@mglaving/compiling-pgmodeler-1-1-0-for-cockroachdb-on-linux-mint-guide-experimental-8e00e1ad090b?source=rss-8224acde60fd------2</link>
            <guid isPermaLink="false">https://medium.com/p/8e00e1ad090b</guid>
            <category><![CDATA[cockroachdb]]></category>
            <category><![CDATA[pgmodeler]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[build]]></category>
            <category><![CDATA[compile]]></category>
            <dc:creator><![CDATA[Mattias Glaving]]></dc:creator>
            <pubDate>Fri, 23 Feb 2024 19:54:29 GMT</pubDate>
            <atom:updated>2024-02-23T19:55:11.912Z</atom:updated>
            <content:encoded><![CDATA[<h3>Compiling pgModeler 1.1.0 for CockroachDB on Linux Mint guide — experimental</h3><p>This experimental tutorial describes how to tweak, build, install and run pgModeler on Linux Mint 21 for CockroachDB compatibility. It should work on any recent Linux Mint or Ubuntu version. <strong>For experimental use only</strong>.</p><p><a href="https://www.cockroachlabs.com/">CockroachDB</a> is a PostgreSQL derivative supporting a subset of PostgreSQL’s features, with some feature modifications and additions.</p><p><a href="https://pgmodeler.io/">pgModeler</a> is an open-source, multi-platform database modeler for PostgreSQL, but with these tweaks it works with CockroachDB with the following caveats:</p><ul><li>If any functionality not available in CockroachDB (e.g.: triggers) is used in the pgModeler data model then pgModeler may malfunction or dump.</li><li>Full database diff does not seem to work, partial diff by selecting a list of schema seems to work.</li><li>It will no longer work for PostgreSQL — use different binaries for PostgreSQL and CockroachDB.</li><li>For experimental use only. Do this on your own peril — do not use with production databases or with databases containing any valuable data.</li></ul><p>In Terminal on a Linux Mint instance type the following:</p><pre>##################################################<br>## Install PostgreSQL and other needed packages ##<br><br># Update the package lists and update the system<br>sudo apt update &amp;&amp; sudo apt upgrade -y<br><br># Install the latest version of PostgreSQL<br>sudo apt install postgresql postgresql-common postgresql-contrib -y<br><br># Install build libs and tools<br>sudo apt install build-essential libxml2-dev perl libx11-xcb-dev \<br> ^libxcb.*-dev libfontconfig1-dev libfreetype6-dev libx11-dev \<br> libx11-xcb-dev libxext-dev libxfixes-dev libxi-dev libxrender-dev \<br> libxcb1-dev libxcb-glx0-dev libxcb-keysyms1-dev libxcb-image0-dev \<br> libxcb-shm0-dev libxcb-icccm4-dev libxcb-sync0-dev libxcb-xfixes0-dev \<br> libxcb-shape0-dev libxcb-randr0-dev libxcb-render-util0-dev \<br> libxkbcommon-dev libxkbcommon-x11-dev libxcb-xinerama0-dev \<br> libxcb-sync-dev libcups2-dev libpq-dev git g++ cmake freeglut3 \<br> freeglut3-dev binutils libglew-dev mesa-common-dev libglew-dev \<br> libglm-dev qt6-base-dev libqt6svg6* qt6-tools-dev-tools \<br> qt6-tools-dev -y<br><br>##################################<br>## Set up the local environment ##<br><br>export QT_VERSION=6.2.4<br>export QT_ARCH=gcc_64<br>export QT_ROOT=/usr/lib/qt6<br>export QT_LIB=/usr/lib/x86_64-linux-gnu<br>export QT_LIB_PLUGINS=$QT_LIB/qt6/plugins<br>export PGMODELER_SOURCE=~/code/pgmodeler-mint-cockroachdb/pgmodeler<br>export PGMODELER_VERSION=1.1.0<br>export INSTALLATION_ROOT=~/code/pgmodeler-mint-cockroachdb/bin/$PGMODELER_VERSION<br>export PGMODELER_DESKTOP_SHORTCUT=~/Desktop/pgModeler-CockroachDB-$(echo $PGMODELER_VERSION).desktop<br>mkdir -p\<br> $INSTALLATION_ROOT/lib/qtplugins/imageformats \<br> $INSTALLATION_ROOT/lib/qtplugins/printsupport \<br> $INSTALLATION_ROOT/lib/qtplugins/platforms \<br> $INSTALLATION_ROOT/lib/qtplugins/tls<br><br>############################<br>## Get the pgModeler repo ##<br><br>cd ~/code/pgmodeler-mint-cockroachdb<br>git clone https://github.com/pgmodeler/pgmodeler.git<br>cd $PGMODELER_SOURCE<br>git pull<br>git checkout $PGMODELER_VERSION<br><br>#######################################<br>## Modify the source for CockroachDB ##<br><br>sed -i &quot;s/pg_tablespace_location(oid)/&#39;\/foo\/bar&#39;/&quot; \<br>  $PGMODELER_SOURCE/assets/schemas/catalog/tablespace.sch<br>sed -i &quot;s/PostgreSQL Database Modeler/CockroachDB Database Modeler/&quot; \<br>  $PGMODELER_SOURCE/libs/libgui/ui/mainwindow.ui<br><br>###################################<br>## Configure the pgModeler build ##<br>export PKG_CONFIG_PATH=/usr/lib/x86_64-linux-gnu/pkgconfig/<br>cd $PGMODELER_SOURCE<br>$QT_ROOT/bin/qmake -r CONFIG+=release \<br> PREFIX=$INSTALLATION_ROOT \<br> BINDIR=$INSTALLATION_ROOT \<br> PRIVATEBINDIR=$INSTALLATION_ROOT \<br> PRIVATELIBDIR=$INSTALLATION_ROOT/lib \<br> pgmodeler.pro<br><br># Build pgModeler<br>cd $PGMODELER_SOURCE<br>make -j$(($(nproc) &gt; 1 ? $(nproc) - 1 : 1)) &amp;&amp; make install<br><br># Resolve pgModeler dependencies<br>cd $QT_LIB<br>cp libQt6DBus.so.6 libQt6PrintSupport.so.6 libQt6Widgets.so.6 \<br> libQt6Network.so.6 libQt6Gui.so.6 libQt6Core.so.6 libQt6XcbQpa.so.6 \<br> libQt6Svg.so.6 libQt6OpenGL.so.6 libicui18n.so.* libicuuc.so.* \<br> libicudata.so.* \<br> $INSTALLATION_ROOT/lib<br>cd $QT_LIB_PLUGINS<br>cp -r imageformats/libqgif.so imageformats/libqico.so \<br> imageformats/libqjpeg.so imageformats/libqsvg.so \<br> $INSTALLATION_ROOT/lib/qtplugins/imageformats<br>cp -r printsupport/libcupsprintersupport.so \<br> $INSTALLATION_ROOT/lib/qtplugins/printsupport<br>cp -r platforms/libqxcb.so platforms/libqoffscreen.so \<br> $INSTALLATION_ROOT/lib/qtplugins/platforms<br>cp -r tls/* \<br> $INSTALLATION_ROOT/lib/qtplugins/tls<br>echo -e \<br> &quot;[Paths]\nPrefix=.\nPlugins=lib/qtplugins\nLibraries=lib&quot; \<br> &gt; $INSTALLATION_ROOT/qt.conf<br><br>###################<br>## Run pgModeler ##<br><br># Only if needed - (re)create pgModeler runtime config files<br>rm -rf ~/.config/pgmodeler-1.0<br>cd $INSTALLATION_ROOT &amp;&amp; ./pgmodeler-cli -cc -mo<br><br># Run pgModeler from the terminal<br>cd $INSTALLATION_ROOT &amp;&amp; export LD_LIBRARY_PATH=$(pwd)/lib &amp;&amp; ./pgmodeler &amp;<br><br># Create Desktop shortcut<br>echo [Desktop Entry] &gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Comment=Starts pgModeler CockroachDB version $(echo $PGMODELER_VERSION) &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo &#39;Exec=sh -c &quot;cd ~/code/pgmodeler-mint-cockroachdb/bin/&#39;$(echo $PGMODELER_VERSION)&#39; &amp;&amp; export LD_LIBRARY_PATH=$(pwd)/lib &amp;&amp; ./pgmodeler&quot;&#39; &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo GenericName=pgModeler $(echo $PGMODELER_VERSION) &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Icon=~/code/pgmodeler-mint-cockroachdb/bin/$(echo $PGMODELER_VERSION)/share/pgmodeler/conf/pgmodeler_logo.png &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo &quot;Categories=Development;&quot; &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Name=pgModeler CockroachDB version $(echo $PGMODELER_VERSION) &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Type=Application &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Terminal=false &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>gio set $PGMODELER_DESKTOP_SHORTCUT metadata::trusted true<br>chmod +x $PGMODELER_DESKTOP_SHORTCUT<br># Now double-click the pgModeler shortcut on the Desktop to launch pgModeler<br># If double-clicking does not work:<br>#   Right-click on the pgModeler desktop icon and select &#39;Allow Launching&#39;<br>#   Then double-click on the pgModeler shortcut on the desktop again<br><br># Add to Mint menu<br>cp $PGMODELER_DESKTOP_SHORTCUT ~/.local/share/applications</pre><p>Verified on February 23rd 2024 on Linux Mint 21 with the latest updates installed.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8e00e1ad090b" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Compiling and installing pgModeler 1.1.0-beta1 on Ubuntu 22.04 howto guide]]></title>
            <link>https://medium.com/@mglaving/compiling-and-installing-pgmodeler-1-1-0-beta1-on-ubuntu-22-04-howto-guide-cd1faab9585e?source=rss-8224acde60fd------2</link>
            <guid isPermaLink="false">https://medium.com/p/cd1faab9585e</guid>
            <category><![CDATA[postgresql]]></category>
            <category><![CDATA[postgres]]></category>
            <category><![CDATA[compile]]></category>
            <category><![CDATA[data-modeling]]></category>
            <category><![CDATA[pgmodeler]]></category>
            <dc:creator><![CDATA[Mattias Glaving]]></dc:creator>
            <pubDate>Tue, 05 Dec 2023 12:53:25 GMT</pubDate>
            <atom:updated>2023-12-05T12:54:04.618Z</atom:updated>
            <content:encoded><![CDATA[<p>This tutorial describes how to build, install and run pgModeler 1.1.0-beta1 on Ubuntu 22.04. It should work on any recent Ubuntu version.</p><p>In Terminal on your Ubuntu box type the following:</p><pre>##################################################<br>## Install PostgreSQL and other needed packages ##<br><br># Update the package lists and update the system<br>sudo apt update &amp;&amp; sudo apt upgrade -y<br><br># Install the latest version of PostgreSQL<br>sudo apt install postgresql postgresql-common postgresql-contrib -y<br><br># Install build libs and tools<br>sudo apt install build-essential libxml2-dev perl libx11-xcb-dev \<br> ^libxcb.*-dev libfontconfig1-dev libfreetype6-dev libx11-dev \<br> libx11-xcb-dev libxext-dev libxfixes-dev libxi-dev libxrender-dev \<br> libxcb1-dev libxcb-glx0-dev libxcb-keysyms1-dev libxcb-image0-dev \<br> libxcb-shm0-dev libxcb-icccm4-dev libxcb-sync0-dev libxcb-xfixes0-dev \<br> libxcb-shape0-dev libxcb-randr0-dev libxcb-render-util0-dev \<br> libxkbcommon-dev libxkbcommon-x11-dev libxcb-xinerama0-dev \<br> libxcb-sync-dev libcups2-dev libpq-dev git g++ cmake freeglut3 \<br> freeglut3-dev binutils libglew-dev mesa-common-dev libglew-dev \<br> libglm-dev qt6-base-dev libqt6svg6* qt6-tools-dev-tools \<br> qt6-tools-dev -y<br><br>##################################<br>## Set up the local environment ##<br>export QT_VERSION=6.2.4<br>export QT_ARCH=gcc_64<br>export QT_ROOT=/usr/lib/qt6<br>export QT_LIB=/usr/lib/x86_64-linux-gnu<br>export QT_LIB_PLUGINS=$QT_LIB/qt6/plugins<br>export PGMODELER_ROOTDIR=~/code/pgmodeler<br>export PGMODELER_SOURCE=$PGMODELER_ROOTDIR/pgmodeler<br>export PGMODELER_VERSION=1.1.0-beta1<br>export INSTALLATION_ROOT=$PGMODELER_ROOTDIR/bin/$PGMODELER_VERSION<br>export PGMODELER_DESKTOP_SHORTCUT=~/Desktop/pgModeler-$(echo $PGMODELER_VERSION).desktop<br>mkdir -p\<br> $cd $PGMODELER_ROOTDIR \<br> $INSTALLATION_ROOT/lib/qtplugins/imageformats \<br> $INSTALLATION_ROOT/lib/qtplugins/printsupport \<br> $INSTALLATION_ROOT/lib/qtplugins/platforms \<br> $INSTALLATION_ROOT/lib/qtplugins/tls<br><br>#######################<br>## Compile pgModeler ##<br><br># Get the pgModeler repo<br>cd $PGMODELER_ROOTDIR<br>git clone https://github.com/pgmodeler/pgmodeler.git<br>cd $PGMODELER_SOURCE<br>git pull<br>git checkout $PGMODELER_VERSION<br><br># Configure the pgModeler build<br>export PKG_CONFIG_PATH=/usr/lib/x86_64-linux-gnu/pkgconfig/<br>cd $PGMODELER_SOURCE<br>$QT_ROOT/bin/qmake -r CONFIG+=release \<br> PREFIX=$INSTALLATION_ROOT \<br> BINDIR=$INSTALLATION_ROOT \<br> PRIVATEBINDIR=$INSTALLATION_ROOT \<br> PRIVATELIBDIR=$INSTALLATION_ROOT/lib \<br> pgmodeler.pro<br><br># Build pgModeler<br>cd $PGMODELER_SOURCE<br>make -j$(nproc) &amp;&amp; make install<br><br># Resolve pgModeler dependencies<br>cd $QT_LIB<br>cp libQt6DBus.so.6 libQt6PrintSupport.so.6 libQt6Widgets.so.6 \<br> libQt6Network.so.6 libQt6Gui.so.6 libQt6Core.so.6 libQt6XcbQpa.so.6 \<br> libQt6Svg.so.6 libQt6OpenGL.so.6 libicui18n.so.* libicuuc.so.* \<br> libicudata.so.* \<br> $INSTALLATION_ROOT/lib<br>cd $QT_LIB_PLUGINS<br>cp -r imageformats/libqgif.so imageformats/libqico.so \<br> imageformats/libqjpeg.so imageformats/libqsvg.so \<br> $INSTALLATION_ROOT/lib/qtplugins/imageformats<br>cp -r printsupport/libcupsprintersupport.so \<br> $INSTALLATION_ROOT/lib/qtplugins/printsupport<br>cp -r platforms/libqxcb.so platforms/libqoffscreen.so \<br> $INSTALLATION_ROOT/lib/qtplugins/platforms<br>cp -r tls/* \<br> $INSTALLATION_ROOT/lib/qtplugins/tls<br>echo -e \<br> &quot;[Paths]\nPrefix=.\nPlugins=lib/qtplugins\nLibraries=lib&quot; \<br> &gt; $INSTALLATION_ROOT/qt.conf<br><br>###################<br>## Run pgModeler ##<br><br># Only if needed - (re)create pgModeler runtime config files<br>rm -rf ~/.config/pgmodeler-1.0<br>cd $INSTALLATION_ROOT &amp;&amp; ./pgmodeler-cli -cc -mo<br><br># Run pgModeler from the terminal<br>cd $INSTALLATION_ROOT &amp;&amp; export LD_LIBRARY_PATH=$(pwd)/lib &amp;&amp; ./pgmodeler &amp;<br><br># Create Desktop shortcut<br>echo [Desktop Entry] &gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Comment=Starts pgModeler $(echo $PGMODELER_VERSION) &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo &#39;Exec=sh -c &quot;cd ~/code/pgmodeler/bin/&#39;$(echo $PGMODELER_VERSION)&#39; &amp;&amp; export LD_LIBRARY_PATH=$(pwd)/lib &amp;&amp; ./pgmodeler&quot;&#39; &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo GenericName=pgModeler $(echo $PGMODELER_VERSION) &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Icon=~/code/pgmodeler/bin/$(echo $PGMODELER_VERSION)/share/pgmodeler/conf/pgmodeler_logo.png &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo &quot;Categories=Development;&quot; &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Name=pgModeler $(echo $PGMODELER_VERSION) &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Type=Application &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Terminal=false &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>gio set $PGMODELER_DESKTOP_SHORTCUT metadata::trusted true<br>chmod +x $PGMODELER_DESKTOP_SHORTCUT<br># Now double-click the pgModeler shortcut on the Desktop to launch pgModeler<br># If double-clicking does not work:<br>#   Right-click on the pgModeler desktop icon and select &#39;Allow Launching&#39;<br>#   Then double-click on the pgModeler shortcut on the desktop again<br><br># Add to Applications<br>cp $PGMODELER_DESKTOP_SHORTCUT ~/.local/share/applications</pre><p>Verified on December 5th 2023.</p><p>pgModeler 1.x is using a new and breaking database format compared to previous 0.x versions, see the pgModeler website for migration instructions if needed.</p><p>The pgModeler plugins repo does not compile under Qt6 yet it seems, leave a comment if you discover that to no longer be true.</p><p>There may be a newer guide — check my other posts.</p><p>Please give a clap if you found this useful.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=cd1faab9585e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Compiling and installing pgModeler 1.1.4 on Linux Mint 21 howto guide]]></title>
            <link>https://medium.com/@mglaving/compiling-and-installing-pgmodeler-1-1-0-beta1-on-linux-mint-21-howto-guide-b924f091c54a?source=rss-8224acde60fd------2</link>
            <guid isPermaLink="false">https://medium.com/p/b924f091c54a</guid>
            <category><![CDATA[postgres]]></category>
            <category><![CDATA[tutorial]]></category>
            <category><![CDATA[pgmodeler]]></category>
            <category><![CDATA[database-model]]></category>
            <category><![CDATA[postgresql-tutorials]]></category>
            <dc:creator><![CDATA[Mattias Glaving]]></dc:creator>
            <pubDate>Tue, 05 Dec 2023 11:40:04 GMT</pubDate>
            <atom:updated>2024-08-22T12:06:53.923Z</atom:updated>
            <content:encoded><![CDATA[<p>This tutorial describes how to build, install and run pgModeler on Linux Mint 21. It should work on any recent Linux Mint version and on any recent Ubuntu Linux derivative.</p><p>pgModeler is an open-source multiplatform database modeler for PostgreSQL.</p><p>In Terminal on a Linux Mint instance type the following:</p><pre>##################################################<br>## Install PostgreSQL and other needed packages ##<br><br># Update the package lists and update the system<br>sudo apt update &amp;&amp; sudo apt upgrade -y<br><br># Install the latest version of PostgreSQL<br>sudo apt install postgresql postgresql-common postgresql-contrib -y<br><br># Install build libs and tools<br>sudo apt install build-essential libxml2-dev perl libx11-xcb-dev \<br> ^libxcb.*-dev libfontconfig1-dev libfreetype6-dev libx11-dev \<br> libx11-xcb-dev libxext-dev libxfixes-dev libxi-dev libxrender-dev \<br> libxcb1-dev libxcb-glx0-dev libxcb-keysyms1-dev libxcb-image0-dev \<br> libxcb-shm0-dev libxcb-icccm4-dev libxcb-sync0-dev libxcb-xfixes0-dev \<br> libxcb-shape0-dev libxcb-randr0-dev libxcb-render-util0-dev \<br> libxkbcommon-dev libxkbcommon-x11-dev libxcb-xinerama0-dev \<br> libxcb-sync-dev libcups2-dev libpq-dev git g++ cmake freeglut3 \<br> freeglut3-dev binutils libglew-dev mesa-common-dev libglew-dev \<br> libglm-dev qt6-base-dev libqt6svg6* qt6-tools-dev-tools \<br> qt6-tools-dev -y<br><br>##################################<br>## Set up the local environment ##<br>export QT_VERSION=6.2.4<br>export QT_ARCH=gcc_64<br>export QT_ROOT=/usr/lib/qt6<br>export QT_LIB=/usr/lib/x86_64-linux-gnu<br>export QT_LIB_PLUGINS=$QT_LIB/qt6/plugins<br>export PGMODELER_MAINDIR=~/code/pgmodeler-mint<br>export PGMODELER_SOURCE=~/code/pgmodeler-mint/pgmodeler<br>export PGMODELER_VERSION=v1.1.4<br>export INSTALLATION_ROOT=~/code/pgmodeler-mint/bin/$PGMODELER_VERSION<br>export PGMODELER_DESKTOP_SHORTCUT=~/Desktop/pgModeler-$(echo $PGMODELER_VERSION).desktop<br>export PKG_CONFIG_PATH=/usr/lib/x86_64-linux-gnu/pkgconfig/<br>mkdir -p\<br> $INSTALLATION_ROOT/lib/qtplugins/imageformats \<br> $INSTALLATION_ROOT/lib/qtplugins/printsupport \<br> $INSTALLATION_ROOT/lib/qtplugins/platforms \<br> $INSTALLATION_ROOT/lib/qtplugins/tls<br><br>#######################<br>## Compile pgModeler ##<br><br># Get the pgModeler repo<br><br>cd $PGMODELER_MAINDIR<br>git clone https://github.com/pgmodeler/pgmodeler.git<br>cd $PGMODELER_SOURCE<br>git pull<br>git checkout $PGMODELER_VERSION<br><br># Configure the pgModeler build<br>cd $PGMODELER_SOURCE<br>$QT_ROOT/bin/qmake -r CONFIG+=release \<br> PREFIX=$INSTALLATION_ROOT \<br> BINDIR=$INSTALLATION_ROOT \<br> PRIVATEBINDIR=$INSTALLATION_ROOT \<br> PRIVATELIBDIR=$INSTALLATION_ROOT/lib \<br> pgmodeler.pro<br><br># Build pgModeler<br>cd $PGMODELER_SOURCE<br>make -j$(($(nproc) &gt; 1 ? $(nproc) - 1 : 1)) &amp;&amp; make install<br><br># Resolve pgModeler dependencies<br>cd $QT_LIB<br>cp libQt6DBus.so.6 libQt6PrintSupport.so.6 libQt6Widgets.so.6 \<br> libQt6Network.so.6 libQt6Gui.so.6 libQt6Core.so.6 libQt6XcbQpa.so.6 \<br> libQt6Svg.so.6 libQt6OpenGL.so.6 libicui18n.so.* libicuuc.so.* \<br> libicudata.so.* \<br> $INSTALLATION_ROOT/lib<br>cd $QT_LIB_PLUGINS<br>cp -r imageformats/libqgif.so imageformats/libqico.so \<br> imageformats/libqjpeg.so imageformats/libqsvg.so \<br> $INSTALLATION_ROOT/lib/qtplugins/imageformats<br>cp -r printsupport/libcupsprintersupport.so \<br> $INSTALLATION_ROOT/lib/qtplugins/printsupport<br>cp -r platforms/libqxcb.so platforms/libqoffscreen.so \<br> $INSTALLATION_ROOT/lib/qtplugins/platforms<br>cp -r tls/* \<br> $INSTALLATION_ROOT/lib/qtplugins/tls<br>echo -e \<br> &quot;[Paths]\nPrefix=.\nPlugins=lib/qtplugins\nLibraries=lib&quot; \<br> &gt; $INSTALLATION_ROOT/qt.conf<br><br>###################<br>## Run pgModeler ##<br><br># Only if needed - (re)create pgModeler runtime config files<br>rm -rf ~/.config/pgmodeler-1.0<br>cd $INSTALLATION_ROOT &amp;&amp; ./pgmodeler-cli -cc -mo<br><br># Run pgModeler from the terminal<br>cd $INSTALLATION_ROOT &amp;&amp; export LD_LIBRARY_PATH=$(pwd)/lib &amp;&amp; ./pgmodeler &amp;<br><br># Create Desktop shortcut<br>echo [Desktop Entry] &gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Comment=Starts pgModeler $(echo $PGMODELER_VERSION) &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo &#39;Exec=sh -c &quot;cd ~/code/pgmodeler-mint/bin/&#39;$(echo $PGMODELER_VERSION)&#39; &amp;&amp; export LD_LIBRARY_PATH=$(pwd)/lib &amp;&amp; ./pgmodeler&quot;&#39; &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo GenericName=pgModeler $(echo $PGMODELER_VERSION) &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Icon=~/code/pgmodeler-mint/bin/$(echo $PGMODELER_VERSION)/share/pgmodeler/conf/pgmodeler_logo.png &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo &quot;Categories=Development;&quot; &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Name=pgModeler $(echo $PGMODELER_VERSION) &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Type=Application &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>echo Terminal=false &gt;&gt; $PGMODELER_DESKTOP_SHORTCUT<br>gio set $PGMODELER_DESKTOP_SHORTCUT metadata::trusted true<br>chmod +x $PGMODELER_DESKTOP_SHORTCUT<br># Now double-click the pgModeler shortcut on the Desktop to launch pgModeler<br># If double-clicking does not work:<br>#   Right-click on the pgModeler desktop icon and select &#39;Allow Launching&#39;<br>#   Then double-click on the pgModeler shortcut on the desktop again<br><br># Add to Mint menu<br>cp $PGMODELER_DESKTOP_SHORTCUT ~/.local/share/applications</pre><p>Verified on August 22nd 2024 on Linux Mint 21 with the latest updates installed.</p><p>pgModeler 1.x is using a new and breaking database format compared to previous 0.x versions, see the pgModeler website for migration instructions if needed.</p><p>The pgModeler plugins repo does not compile under Qt6 yet it seems, leave a comment if you discover that to no longer be true.</p><p><a href="https://pgmodeler.io/">pgModeler - PostgreSQL Database Modeler</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b924f091c54a" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Partitioned Tables in pgModeler howto]]></title>
            <link>https://medium.com/@mglaving/partitioned-tables-in-pgmodeler-howto-02b1915e81dc?source=rss-8224acde60fd------2</link>
            <guid isPermaLink="false">https://medium.com/p/02b1915e81dc</guid>
            <category><![CDATA[how-to]]></category>
            <category><![CDATA[partitioning]]></category>
            <category><![CDATA[pgmodeler]]></category>
            <category><![CDATA[tutorial]]></category>
            <category><![CDATA[postgres]]></category>
            <dc:creator><![CDATA[Mattias Glaving]]></dc:creator>
            <pubDate>Sun, 03 Dec 2023 16:29:28 GMT</pubDate>
            <atom:updated>2023-12-03T19:13:57.977Z</atom:updated>
            <content:encoded><![CDATA[<p>This guide describes how to create partitioned tables in pgModeler. It does not describe what a partitioned table is or why to use one, see links below.</p><p><strong>Create a partitioned table in pgModeler like so</strong>:</p><ol><li>Create a table complete with default values, constraints, indexes, triggers, etc, and select a suitable name for the table, e.g.: transactions. This is the parent table which <em>will not</em> hold any data.</li><li>In the Table properties modal for the parent table open the tab Partition keys and select partitioning options, and apply.</li><li>Create a new table (do not copy an existing table, create a new one from scratch), add a name, e.g.: transactions_2023 if it will hold transactions for 2023, but do not add any columns or change any of the default settings, and apply. This is a partition table that <em>will</em> hold data.</li><li>Right-click the newly created partition table to get the context menu, select New -&gt; Relationship -&gt; Partitioning. This changes the mouse pointer to a relationship creation tool, click on the parent table to create a partitioning relationship. This causes the partition table to inherit all properties from the parent table, but not all properties are visible in the UI, only the columns and some of their properties.</li><li>If this is the default partition then check the Default partition checkbox, and apply.</li><li>If this is not the default partition then enter the criteria in the criteria text box, eg FROM (‘2023–01–01’::timestamptz) TO (‘2024–01–01’::timestamptz), and apply.</li><li>Repeat steps 3 to 6 for all partition tables.</li></ol><h3>Notes</h3><ul><li>To do multi level partitioning then the partition key column has to be present in the partition table before step 4, or else pgModeler can not handle it (at least not in the current version at the time of writing this). When step 4 is completed then all non-duplicate properties will be inherited, and it is now possible to use the newly created table as a parent table for another partition in the same way as above from step 2.</li><li>When creating things like indexes and triggers on a partition table directly then this can cause strange, seemingly random, error messages from pgModeler when performing a diff. Doing multi level partitioning like above works fine, though.</li><li>If the parent table is altered then the alterations will not propagate to existing partition tables. To get the alterations to propagate then the partition relationships have to be re-created.</li></ul><h3>Links</h3><p><a href="https://pgmodeler.io/support/docs">PostgreSQL Database Modeler Documentation Index</a></p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2F53eWt8sBDtk%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D53eWt8sBDtk&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2F53eWt8sBDtk%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/af0135085b2540e5895f7116eb23f1c4/href">https://medium.com/media/af0135085b2540e5895f7116eb23f1c4/href</a></iframe><p><a href="https://www.postgresql.org/docs/current/ddl-partitioning.html">5.12. Table Partitioning</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=02b1915e81dc" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to install PostgreSQL 16 on Linux Mint 21]]></title>
            <link>https://medium.com/@mglaving/how-to-install-postgresql-16-on-linux-mint-21-d58e875fe7c6?source=rss-8224acde60fd------2</link>
            <guid isPermaLink="false">https://medium.com/p/d58e875fe7c6</guid>
            <category><![CDATA[postgres]]></category>
            <category><![CDATA[linux-mint-21]]></category>
            <category><![CDATA[postgresql-tutorials]]></category>
            <dc:creator><![CDATA[Mattias Glaving]]></dc:creator>
            <pubDate>Mon, 30 Oct 2023 15:35:20 GMT</pubDate>
            <atom:updated>2023-12-04T19:41:51.666Z</atom:updated>
            <content:encoded><![CDATA[<p>PostgreSQL 16 is not in the Linux Mint 21 repos at the time of writing, hence we’ll need to use the PostgreSQL official repo.</p><p>The PostgreSQL <strong>jammy</strong> repo is compatible with Linux Mint 21.</p><p>Recommended: create a snapshot of your Mint box before starting.</p><p>Type the following in the Terminal of your Mint box:</p><pre># Create the file repository configuration:<br>sudo sh -c &#39;echo &quot;deb http://apt.postgresql.org/pub/repos/apt jammy-pgdg main&quot; &gt; /etc/apt/sources.list.d/pgdg.list&#39;<br><br># Import the repository signing key:<br>wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -<br><br># Update the package lists and the system:<br>sudo apt update &amp;&amp; sudo apt upgrade -y<br><br># Install the latest version of PostgreSQL.<br># If you want a specific version, use &#39;postgresql-15&#39; or similar instead of &#39;postgresql&#39;:<br>sudo apt install postgresql -y<br><br># Check status<br>service postgresql status<br>sudo netstat -tulpn | grep postgres<br><br>#########################<br># The below is optional #<br>#########################<br><br>###########################<br># Allow remote connections<br><br># Set listen to all addresses<br>sudo pico /etc/postgresql/16/main/postgresql.conf<br><br># Set the following line in postgresql.conf:<br>listen_addresses = &#39;*&#39;<br><br># Set allow remote connections - do this on your own peril<br>sudo pico /etc/postgresql/16/main/pg_hba.conf<br><br># Add the following lines in pg_hba.conf:<br># TYPE  DATABASE USER    ADDRESS         METHOD<br>host    all      all     0.0.0.0/0       md5<br>host    all      all     ::/0            md5<br><br># Restart the service<br>sudo systemctl restart postgresql<br><br># Open firewall - do this on your own peril<br>sudo ufw allow 5432<br><br>#######################<br># Locales<br><br># Even though the locale seem to be there it does not always work<br># and then it can sometimes be fixed by a reconfig.<br># If a locale needed does not exist, eg: sv_SE.UTF-8:<br>cat /etc/locale.gen | grep sv_SE.UTF-8<br><br># then generate it with<br>sudo dpkg-reconfigure locales  <br><br># the server may need a restart to pick up the new locales<br>sudo service postgresql restart<br><br>#####################<br># pg_cron - cron jobs in the DB<br><br># Install<br>sudo apt install postgresql-16-cron<br><br># set this in postgresql.conf:<br>shared_preload_libraries = &#39;pg_cron&#39;<br><br># restart the cluster<br>sudo service postgresql restart<br><br># Execute this command in the DB where cron should run:<br>CREATE EXTENSION pg_cron;<br><br># Example cron command to purge pg_cron log table at 3.22 am every day - keep 7 days worth of data<br>SELECT cron.schedule(&#39;22 3 * * *&#39;, $$DELETE FROM cron.job_run_details WHERE end_time &lt; now() - interval &#39;7 days&#39;$$);<br><br># view all cron jobs<br>SELECT * FROM cron.job;<br>SELECT * FROM cron.job_run_details ORDER BY runid DESC LIMIT 20;<br><br># update the schedule for cron job &#39;SELECT &quot;auth&quot;.&quot;purge&quot;()&#39;<br>SELECT cron.schedule(&#39;* * * * *&#39;, &#39;SELECT &quot;auth&quot;.&quot;purge&quot;()&#39;) WHERE jobid = &lt;job_id&gt;;<br><br>################################<br># Useful commands<br>sudo -u postgres psql -c &quot;SHOW config_file;&quot; <br><br>service postgresql status<br>sudo service postgresql restart<br>ps -ef | grep postgres<br>sudo netstat -tulpn | grep 5432<br>sudo netstat -tulpn | grep postgres<br>sudo netstat -tulpn | grep node<br>cat /etc/postgresql/16/main/postgresql.conf | grep pg_hba<br>cat /etc/postgresql/16/main/postgresql.conf | grep listen_addresses<br>cat /etc/postgresql/16/main/postgresql.conf | grep port<br>tail -f /var/log/postgresql/postgresql-16-main.log<br><br># on the machine where the db is located<br>sudo su postgres<br>psql<br><br># Connect to AWS DB available from Internet<br>psql -h &lt;host_url&gt; -d &lt;db_name&gt; -U &lt;db_username&gt; -W -p 5432<br><br># tunnelling<br># Set up ssh tunnel from port 5438 on the local machine to port 5432 on<br># the remote server<br># if &lt;remote_ssh_port&gt; is 22 then this is not needed: -p &lt;remote_ssh_port&gt;<br># &lt;remote_host&gt; can be a fully qualified hostname or an ip<br>ssh &lt;db_user&gt;@&lt;remote_host&gt; -p &lt;remote_ssh_port&gt; -L 5438:&lt;remote_host&gt;:5432 -N -v -C -v -v<br><br># Potentially useful psql commands<br>help (show help)<br>\? (show all psql commands)<br>\h (show all DML commands)<br>\h create database (show help for the DML command &#39;create database&#39;)<br>\l (list databases)<br>\l+ (list databases with storage info)<br>\connect dbname (connect to database dbname)<br><br># Potentially useful tools<br>* pgModeler<br>* pgAdmin 4<br>* dbeaver<br>* terminator<br>* btop</pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d58e875fe7c6" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to install PostgreSQL 15 on Linux Mint 21]]></title>
            <link>https://medium.com/@mglaving/how-to-install-postgresql-15-on-linux-mint-21-27cca7918006?source=rss-8224acde60fd------2</link>
            <guid isPermaLink="false">https://medium.com/p/27cca7918006</guid>
            <category><![CDATA[how-to]]></category>
            <category><![CDATA[linux-mint-21]]></category>
            <category><![CDATA[installation]]></category>
            <category><![CDATA[postgresql]]></category>
            <category><![CDATA[tutorial]]></category>
            <dc:creator><![CDATA[Mattias Glaving]]></dc:creator>
            <pubDate>Sun, 25 Jun 2023 09:20:32 GMT</pubDate>
            <atom:updated>2023-10-30T15:27:42.890Z</atom:updated>
            <content:encoded><![CDATA[<p>PostgreSQL 15 is not in the Linux Mint 21 repos at the time of writing, hence we’ll need to use the PostgreSQL official repo.</p><p>The PostgreSQL <strong>jammy</strong> repo is compatible with Linux Mint 21.</p><p>Recommended: create a snapshot of your Mint box before starting.</p><p>Type the following in the Terminal of your Mint box:</p><pre># Create the file repository configuration:<br>sudo sh -c &#39;echo &quot;deb http://apt.postgresql.org/pub/repos/apt jammy-pgdg main&quot; &gt; /etc/apt/sources.list.d/pgdg.list&#39;<br><br># Import the repository signing key:<br>wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -<br><br># Update the package lists:<br>sudo apt update<br><br># Install the latest version of PostgreSQL.<br># If you want a specific version, use &#39;postgresql-12&#39; or similar instead of &#39;postgresql&#39;:<br>sudo apt install postgresql -y<br><br># Check status<br>service postgresql status<br>sudo netstat -tulpn | grep postgres<br><br>#########################<br># The below is optional #<br>#########################<br><br>###########################<br># Allow remote connections<br><br># Set listen to all addresses<br>sudo pico /etc/postgresql/15/main/postgresql.conf<br><br># Set the following line in postgresql.conf:<br>listen_addresses = &#39;*&#39;<br><br># Set allow remote connections - do this on your own peril<br>sudo pico /etc/postgresql/15/main/pg_hba.conf<br><br># Add the following lines in pg_hba.conf:<br># TYPE  DATABASE USER    ADDRESS         METHOD<br>host    all      all     0.0.0.0/0       md5<br>host    all      all     ::/0            md5<br><br># Restart the service<br>sudo systemctl restart postgresql<br><br># Open firewall - do this on your own peril<br>sudo ufw allow 5432<br><br>#######################<br># Locales<br><br># Even though the locale seem to be there it does not always work<br># and then it can sometimes be fixed by a reconfig.<br># If a locale needed does not exist, eg: sv_SE.UTF-8:<br>cat /etc/locale.gen | grep sv_SE.UTF-8<br><br># then generate it with<br>sudo dpkg-reconfigure locales  <br><br># the server may need a restart to pick up the new locales<br>sudo service postgresql restart<br><br>#####################<br># pg_cron - cron jobs in the DB<br><br># Install<br>sudo apt install postgresql-15-cron<br><br># set this in postgresql.conf:<br>shared_preload_libraries = &#39;pg_cron&#39;<br><br># restart the cluster<br>sudo service postgresql restart<br><br># Execute this command in the DB where cron should run:<br>CREATE EXTENSION pg_cron;<br><br># Example cron command to purge pg_cron log table at 3.22 am every day - keep 7 days worth of data<br>SELECT cron.schedule(&#39;22 3 * * *&#39;, $$DELETE FROM cron.job_run_details WHERE end_time &lt; now() - interval &#39;7 days&#39;$$);<br><br># view all cron jobs<br>SELECT * FROM cron.job;<br>SELECT * FROM cron.job_run_details ORDER BY runid DESC LIMIT 20;<br><br># update the schedule for cron job &#39;SELECT &quot;auth&quot;.&quot;purge&quot;()&#39;<br>SELECT cron.schedule(&#39;* * * * *&#39;, &#39;SELECT &quot;auth&quot;.&quot;purge&quot;()&#39;) WHERE jobid = &lt;job_id&gt;;<br><br>################################<br># Useful commands<br>sudo -u postgres psql -c &quot;SHOW config_file;&quot; <br><br>service postgresql status<br>sudo service postgresql restart<br>ps -ef | grep postgres<br>sudo netstat -tulpn | grep 5432<br>sudo netstat -tulpn | grep postgres<br>sudo netstat -tulpn | grep node<br>cat /etc/postgresql/15/main/postgresql.conf | grep pg_hba<br>cat /etc/postgresql/15/main/postgresql.conf | grep listen_addresses<br>cat /etc/postgresql/15/main/postgresql.conf | grep port<br>tail -f /var/log/postgresql/postgresql-15-main.log<br><br># on the machine where the db is located<br>sudo su postgres<br>psql<br><br># Connect to AWS DB available from Internet<br>psql -h &lt;host_url&gt; -d &lt;db_name&gt; -U &lt;db_username&gt; -W -p 5432<br><br># tunnelling<br># Set up ssh tunnel from port 5438 on the local machine to port 5432 on<br># the remote server<br># if &lt;remote_ssh_port&gt; is 22 then this is not needed: -p &lt;remote_ssh_port&gt;<br># &lt;remote_host&gt; can be a fully qualified hostname or an ip<br>ssh &lt;db_user&gt;@&lt;remote_host&gt; -p &lt;remote_ssh_port&gt; -L 5438:&lt;remote_host&gt;:5432 -N -v -C -v -v<br><br># Potentially useful psql commands<br>help (show help)<br>\? (show all psql commands)<br>\h (show all DML commands)<br>\h create database (show help for the DML command &#39;create database&#39;)<br>\l (list databases)<br>\l+ (list databases with storage info)<br>\connect dbname (connect to database dbname)<br><br># Potentially useful tools<br>* pgModeler<br>* pgAdmin 4<br>* dbeaver<br>* terminator</pre><h3>Improvementes</h3><p>Store the repo signing key like so:</p><p><a href="https://www.linuxuprising.com/2021/01/apt-key-is-deprecated-how-to-add.html">apt-key Is Deprecated. How To Add OpenPGP Repository Signing Keys Without It On Debian, Ubuntu, Linux Mint, Pop!_OS, Etc.</a></p><h3>Links</h3><ul><li><a href="https://www.postgresql.org/download/linux/ubuntu/">Linux downloads (Ubuntu)</a></li><li><a href="https://tecadmin.net/postgresql-allow-remote-connections/">How To Configure PostgreSQL to Allow Remote Connections - TecAdmin</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=27cca7918006" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>