Lemmy-Postgres

PostgreSQL database for Lemmy with automatic database upgrades.

  • Databases
PostgreSQL database for Lemmy with automatic database upgrades. It stores Lemmy data and helps self-hosted operators upgrade PostgreSQL with less manual work.

Platform availability

Available on 4 of 10 platforms

  • Unraid
  • TrueNAS
  • Umbrel (not listed)
  • ZimaOS (not listed)
  • Proxmox (not listed)
  • Helm
  • Mac (not listed)
  • Windows (not listed)
  • Linux (not listed)
  • Any server

Health score?A 0-100 score computed nightly from four factors: maintained (40%: recent commits and steady activity), popular (25%: GitHub stars, log scale), easy to install (20%: platforms, install notes, setup guides, Docker image) and light to run (15%: minimum RAM, ARM support). When the source code has been checked, a fifth factor, security check (20%: automated scan for committed secrets, unsafe desktop-app settings, known-vulnerable dependencies and project hygiene; any serious finding caps it at 20), is added. Factors without data are left out and the rest are rescaled.

68/100 Good

Maintained
100last commit 22 days ago
Popular
8314,658 GitHub stars
Easy to install
553 install platforms, install notes, Docker image
Light to run
404 GB minimum RAM, runs on ARM
Security check
201 serious finding, 3 minor, tests, OpenSSF Scorecard 5.3/10

Availability: platform listings confirmed today, links checked 55 days ago

GitHub stars
14,658
Open issues
121
Last commit
2026-10-30
Latest release
0.19.21
License
AGPL-3.0
Activity
rising

Checked 22 days ago - source: GitHub (LemmyNet/lemmy)

Resources & Compatibility

Minimum requirements: 4 GB RAM, 2 CPU core(s), 50 GB disk. ARM (e.g. Raspberry Pi) is supported.

Checked 54 days ago - source: Docker Hub image tags and published docs

First-install notes

  • Start PostgreSQL first Install and start PostgreSQL (for example with pacman, apt, or Homebrew); if the service errors, create the data folder, make it owned by the postgres user, and initialize it. Without a running database, Lemmy cannot save posts, comments, or accounts and the server will not start. source
  • Edit .env.local before first run Copy the example environment file to .env.local and fill in your site settings before starting Lemmy. Missing or wrong settings can make the site show errors, use the wrong database, or not reach you by your domain. source
  • Set your real domain in lemmy-ui Replace the placeholder example.com in the lemmy-ui service file (a system service file) with your actual domain and save it under /etc/systemd/system. If you leave the wrong host, the web front end may not connect to your server or HTTPS may not work properly. source

Fetched 54 days ago - each note links to its source

Alternatives (8)

  • Aether - Open source, self-governing communities with auditable moderation and mod elections.
  • Digg - Social news platform with topic-based communities, transparent moderation, user voting, content discovery, anti-spam measures, web and mobi…
  • Hacker News - Hacker News is a social news website that caters to programmers and entrepreneurs, delivering content related to computer science and entre…
  • Mbin - Mbin is a decentralized, self-hosted content aggregator and microblogging platform that lets you run a voting and discussion community fede…
  • Reddit - A social news website where content shared by users is voted on, organized into 'subreddits,' and can appear on the front page amid diverse…
  • Steemit - A non-censored social platform where users are incentivized to contribute and curate content.
  • Tildes - A non-profit community site driven by its users' interests.
  • Voyager - Voyager is a self-hostable, open-source web client for Lemmy, a federated link aggregator.

Checked 51 days ago - source: AlternativeTo

Common questions

Why does Lemmy fail to start or save posts if PostgreSQL is not working?

Start PostgreSQL first; if the service errors, create the data folder, make it owned by the postgres user, and initialize it. Without a running database, Lemmy cannot save posts, comments, or accounts and will not start.

What environment file needs to be prepared before the first Lemmy run?

Copy the example environment file to .env.local and fill in site settings before starting Lemmy. Missing or wrong settings can cause errors, make Lemmy use the wrong database, or prevent the site from being reachable by your domain.

What host setting can break HTTPS or the Lemmy web front end?

Replace the placeholder example.com in the lemmy-ui service file with your actual domain and save it under /etc/systemd/system. Leaving the wrong host can prevent the web front end from connecting to your server or make HTTPS not work properly.

Why might a remote Lemmy instance appear lagging in federation state?

Remote Lemmy instances send apub sync actions serially through the Lemmy queue. If your server processes them slower than the origin server sends them, the remote instance will show as lagging.

Answers sourced from github.com, github.com, github.com, join-lemmy.org

Community

Collected 54 days ago - public community threads