惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

WordPress大学
WordPress大学
Microsoft Azure Blog
Microsoft Azure Blog
aimingoo的专栏
aimingoo的专栏
Vercel News
Vercel News
U
Unit 42
L
LangChain Blog
J
Java Code Geeks
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
The Cloudflare Blog
F
Fortinet All Blogs
小众软件
小众软件
I
InfoQ
P
Proofpoint News Feed
D
DataBreaches.Net
Martin Fowler
Martin Fowler
H
Help Net Security
T
Tailwind CSS Blog
N
Netflix TechBlog - Medium
有赞技术团队
有赞技术团队
Y
Y Combinator Blog
Recent Announcements
Recent Announcements
B
Blog RSS Feed
酷 壳 – CoolShell
酷 壳 – CoolShell
B
Blog

Discourse Meta - Latest posts

Horizon: High Context Topic Cards I'd like to ask what this file /var/www/discourse/vendor/data/RT_sRGB.icm is used for? Discourse to Markdown Plugin How to verify a subdomain (mysite.discourse.group) in Google Search Console? Reader Mode Publishing WordPress gallery posts on Discourse Discourse User Feedback New user filter by custom field and contact Interact with discourse from Python? Why we can't type the assignee in the search of a post to assign - home screen app Redis Flushall Category-toggled one-touch move post Some sort of variable to eliminate duplicate text? Why did this plugin replacement fail? Add user to list modal often appears above the mobile viewport sceen Creating/Editing a post on mobile: let's discuss the 2026 Discourse experience Wp-discourse feature request - do not show comments with specific tag? Are there any good Chinese plugins? Discourse ID and 2FA Discourse MCP is here! Sample Forum to See Admin Features? I am unable to register for a free Discourse site Wikipedia Lookup Add text for /login (like js.create_account.disclaimer for /signup) How can i set disable Markdown & Default to Rich Text What's the background image size for the Welcome Banner? How do I enable Associated Accounts with 2FA? Hamburger toggle Support <span data-attribute> in the rich editor Cannot disable read-only mode on Free Plan
Accessing Discourse DB with DBeaver
@Milton_Htsi · 2026-04-25 · via Discourse Meta - Latest posts
The built-in Data Explorer is fine for quick queries, but if you want to use a real GUI like DBeaver or TablePlus, you have to jump through a few hoops since Discourse’s Postgres is locked inside the Docker bridge. Here is how to expose it safely over a private network (like Tailscale) so you aren’t leaving your DB open to the internet. 1. Map a custom port Discourse usually eats up the standard ports, so I used 5434 . Edit your containers/app.yml : YAML expose: - "80:80" - "443:443" - "5434:5432" # Host 5434 -> Container 5432 Then rebuild: ./launcher rebuild app 2. Firewall Don’t open this port to the public. If you’re using Tailscale or some others tunnels, restrict access to that interface only: Bash sudo ufw allow in on tailscale0 to any port 5434 proto tcp 3. Fix the Auth (The annoying part) Discourse uses peer auth by default, which blocks external password logins. So you need to tell Postgres to allow scram-sha-256 Inside the container ( ./launcher enter app ): Bash echo "host all all 0.0.0.0/0 scram-sha-256" >> /shared/postgres_data/pg_hba.conf sudo -u postgres psql -c "SELECT pg_reload_conf();" 4. Set a password The discourse user doesn’t have a password by default. Set one so app like DBeaver can actually log in to it Bash sudo -u postgres psql -c "ALTER USER discourse WITH PASSWORD 'your_password_here';" 5. Connection Details Host: Your IP Port: 5434 Database: discourse User: discourse