Skip to content

Mathesar 0.2.4

Upgrade to 0.2.5 strongly recommended

Mathesar 0.2.4 contains a regression that renders the Data Explorer inccessible for users unless you are connecting to PostgreSQL over a Unix socket. This bug is fixed in 0.2.5.

Summary

This release contains targeted fixes for bugs within Mathesar’s new UNIX socket connection feature, as released in version 0.2.3.

We are keeping this release intentionally narrow to expedite delivery of these bug fixes. Additional new features and improvements will launch in our 0.3.0 release, targeted for June 2025.

This page provides a comprehensive list of all changes in the release.

Bug fixes

Unix socket bug fixes

In version 0.2.3, users experienced the following issues when connecting via Unix socket:

  • Inability to create new databases when Mathesar’s internal database used a Unix socket connection #4473.
  • Failure to connect when the internal database used a Unix socket connection with an explicit port specified #4473.
  • Problems working with data explorations whose base tables were connected via Unix socket #4481.

These issues have all been resolved. Additionally, Unix socket connections no longer require URL encoding. Instead, they must now be provided unencoded:

  • ❌ %2Fvar%2Frun%2Fpostgresql
  • ✅ /var/run/postgresql

Upgrading to 0.2.4

For installations using Docker Compose

If you have a Docker compose installation (including one from the guided script), run the command below:

docker compose -f /etc/mathesar/docker-compose.yml up --pull always -d

Your installation directory may be different

You may need to change /etc/mathesar/ in the command above if you chose to install Mathesar to a different directory.

For installations done from scratch

If you installed Mathesar from scratch, then use these steps to upgrade your installation to 0.2.4.

  1. Go to your Mathesar installation directory

    cd xMATHESAR_INSTALLATION_DIRx

    Note

    Your installation directory may be different from above if you used a different directory when installing Mathesar.

  2. Pull version 0.2.4 from the repository

    git pull https://github.com/mathesar-foundation/mathesar.git
git checkout 0.2.4

  3. Update Python dependencies

    pip install -r requirements.txt

  4. Activate our virtual environment

    source ./mathesar-venv/bin/activate

  5. Run Django migrations

    python manage.py migrate

  6. Download and extract frontend assets

    wget https://github.com/mathesar-foundation/mathesar/releases/download/0.2.4/static_files.zip
unzip static_files.zip && mv static_files mathesar/static/mathesar && rm static_files.zip

  7. Compile Mathesar translation files

    python manage.py compilemessages

  8. Update Mathesar functions on the database:

    python -m mathesar.install --skip-confirm | tee /tmp/install.py.log

  9. Restart the gunicorn server

    systemctl restart gunicorn