# Self-hosting **URL:** https://meta.discourse.org/c/support/self-hosting/31.md?page=101 [Latest](https://meta.discourse.org/latest.md) · [Categories](https://meta.discourse.org/categories.md) · [Tags](https://meta.discourse.org/tags.md) **Page:** 102 --- ## [Primary Postgres database process (postmaster) eating all CPU](https://meta.discourse.org/t/primary-postgres-database-process-postmaster-eating-all-cpu/84410)
**Author:** [@pfaffman](https://meta.discourse.org/u/pfaffman)\ **Replies:** 13\ **Last updated:** [May 28, 2020, 4:20pm UTC](https://meta.discourse.org/t/primary-postgres-database-process-postmaster-eating-all-cpu/84410 "2020-05-28T16:20:15Z")
I’ve got a 2-container install on a DO 8GB droplet that is behaving very strangely. There is a postmaster (EDIT: now there are two of them) processing eating 100% CPU. Sidekiq is running, but the Dashboard complains th… --- ## [Restoring from backup failing: failure creating postgres index](https://meta.discourse.org/t/restoring-from-backup-failing-failure-creating-postgres-index/153014)
**Author:** [@Dustin\_Lang](https://meta.discourse.org/u/Dustin_Lang)\ **Replies:** 7\ **Last updated:** [May 28, 2020, 3:23am UTC](https://meta.discourse.org/t/restoring-from-backup-failing-failure-creating-postgres-index/153014 "2020-05-28T03:23:45Z")
Hi all, I’ve been running Discourse painlessly for several years. Today, I tried doing a web ui upgrade from the 2.4.0beta-something version I was running to the current (2.5.0beta5). This… did not go well. I did not… --- ## [Questions about Discourse Forum and Digital Ocean? Hosting?](https://meta.discourse.org/t/questions-about-discourse-forum-and-digital-ocean-hosting/152706)
**Author:** [@HUN\_Raiden](https://meta.discourse.org/u/HUN_Raiden)\ **Replies:** 1\ **Last updated:** [May 27, 2020, 10:06pm UTC](https://meta.discourse.org/t/questions-about-discourse-forum-and-digital-ocean-hosting/152706 "2020-05-27T22:06:57Z")
Hi guys! I wanted to create a forum in my specialty, so I bought a domain and a hosting on a site they also installed WordPress in it. I wanted to use Discourse Forum", so I used this tutoral to get it done: … --- ## [Can't upgrade due to old docker version](https://meta.discourse.org/t/cant-upgrade-due-to-old-docker-version/152947)
**Author:** [@AdrianoFerrari](https://meta.discourse.org/u/AdrianoFerrari)\ **Replies:** 19\ **Last updated:** [May 27, 2020, 9:43pm UTC](https://meta.discourse.org/t/cant-upgrade-due-to-old-docker-version/152947 "2020-05-27T21:43:29Z")
During upgrade, I did cd /var/discourse; git pull; ./launcher rebuild app. I get “Upgrade Complete” and “UPGRADE OF POSTGRES COMPLETE”. The latter says to “rebuild again”, though it seems to make no difference. Despit… --- ## [Is \`./discourse\_setup\` screen output captured to a file or in a log?](https://meta.discourse.org/t/is-discourse-setup-screen-output-captured-to-a-file-or-in-a-log/152940)
**Author:** [@EricGT](https://meta.discourse.org/u/EricGT)\ **Replies:** 1\ **Last updated:** [May 27, 2020, 11:47am UTC](https://meta.discourse.org/t/is-discourse-setup-screen-output-captured-to-a-file-or-in-a-log/152940 "2020-05-27T11:47:19Z")
Just ran me@machine:/var/discourse$ sudo ./discourse-setup and there was a lot of info and some suggestions that scrolled by before I could read them. Is the screen captured to a file, or is there a log of some sort to … --- ## [Postgres upgrade success loop due to prior postgres 8 to 10 migration](https://meta.discourse.org/t/postgres-upgrade-success-loop-due-to-prior-postgres-8-to-10-migration/152827)
**Author:** [@bspcht](https://meta.discourse.org/u/bspcht)\ **Replies:** 3\ **Last updated:** [May 26, 2020, 9:47pm UTC](https://meta.discourse.org/t/postgres-upgrade-success-loop-due-to-prior-postgres-8-to-10-migration/152827 "2020-05-26T21:47:34Z")
In a loop of: To complete the upgrade, rebuild again using: ./launcher rebuild app I must be missing something. Complete log below. Appreciate any help. root@discuss:/var/discourse# ./launcher rebuild app Ensuring lau… --- ## [Updated to latest version: ./analyze\_new\_cluster.sh message](https://meta.discourse.org/t/updated-to-latest-version-analyze-new-cluster-sh-message/151710)
**Author:** [@itcrowd21](https://meta.discourse.org/u/itcrowd21)\ **Replies:** 13\ **Last updated:** [May 26, 2020, 6:47pm UTC](https://meta.discourse.org/t/updated-to-latest-version-analyze-new-cluster-sh-message/151710 "2020-05-26T18:47:30Z")
Hi I upgraded my Discourse today as follows: apt-get update apt-get upgrade ./launcher rebuild app I then got this output: Setting next OID for new cluster ok Sync data directory to disk … --- ## [Using standard install, at step to edit app.yml, No app.yml](https://meta.discourse.org/t/using-standard-install-at-step-to-edit-app-yml-no-app-yml/152773)
**Author:** [@EricGT](https://meta.discourse.org/u/EricGT)\ **Replies:** 6\ **Last updated:** [May 26, 2020, 5:17pm UTC](https://meta.discourse.org/t/using-standard-install-at-step-to-edit-app-yml-no-app-yml/152773 "2020-05-26T17:17:49Z")
Following Beginner Docker install guide but instead of using Digital Ocean using OSU OSL (a perk of SWI-Prolog being an open source project). At the Email step switched to the more detailed instructions in Switching Y… --- ## [Why home page is blank](https://meta.discourse.org/t/why-home-page-is-blank/152774)
**Author:** [@sharkdeng](https://meta.discourse.org/u/sharkdeng)\ **Replies:** 1\ **Last updated:** [May 26, 2020, 2:24pm UTC](https://meta.discourse.org/t/why-home-page-is-blank/152774 "2020-05-26T14:24:31Z")
Hello, I just installed a discourse on AWS ec2. edu3d.co but why the home page is blank? It is normal when I use safe-mode and access via AWS ip address.Thank you!! --- ## [Upgrade fails on old version of Postgres database](https://meta.discourse.org/t/upgrade-fails-on-old-version-of-postgres-database/103287)
**Author:** [@gtanczyk](https://meta.discourse.org/u/gtanczyk)\ **Replies:** 8\ **Last updated:** [May 26, 2020, 7:42am UTC](https://meta.discourse.org/t/upgrade-fails-on-old-version-of-postgres-database/103287 "2020-05-26T07:42:17Z")
I’m upgrading from v2.0.0.beta5 +110 to 2.2.0.beta5 Postgres version: 9.4 Error message: Caused by: ActiveRecord::StatementInvalid: PG::DatatypeMismatch: ERROR: column "info" is of type jsonb but expression is of typ… --- ## [Migrating Site to S3](https://meta.discourse.org/t/migrating-site-to-s3/151111)
**Author:** [@faultline](https://meta.discourse.org/u/faultline)\ **Replies:** 2\ **Last updated:** [May 25, 2020, 11:46pm UTC](https://meta.discourse.org/t/migrating-site-to-s3/151111 "2020-05-25T23:46:31Z")
So long story short, I help run a small-medium sized discourse site (~250k views a month). In the interests of saving some bandwidth/space on the server I’m using I just switched the backups and uploads to point at S3 … --- ## [Avatar, Site Logos, and Cert Errors](https://meta.discourse.org/t/avatar-site-logos-and-cert-errors/152335)
**Author:** [@markcichy](https://meta.discourse.org/u/markcichy)\ **Replies:** 61\ **Last updated:** [May 25, 2020, 9:45pm UTC](https://meta.discourse.org/t/avatar-site-logos-and-cert-errors/152335 "2020-05-25T21:45:09Z")
Hello! I’ve setup Discourse servers in a about 5 instances now and all seem to be exhibiting odd behaviour; not sure if it is indeed a Bug or if anyone else has experience same. Steps to Recreate Server setup goes sm… --- ## [Higher idle process activity after upgrade](https://meta.discourse.org/t/higher-idle-process-activity-after-upgrade/152453)
**Author:** [@tormod](https://meta.discourse.org/u/tormod)\ **Replies:** 7\ **Last updated:** [May 25, 2020, 6:30pm UTC](https://meta.discourse.org/t/higher-idle-process-activity-after-upgrade/152453 "2020-05-25T18:30:58Z")
Hi, After upgrading Discourse to v2.5.0.beta4-399-gbf8085e436 (from 2.4 something, using command line bootstrap from discourse\_docker git, just before the Postgres 12 upgrade commits), there is notably more CPU churn on… --- ## [Trying to install apache2](https://meta.discourse.org/t/trying-to-install-apache2/152592)
**Author:** [@nekodroid](https://meta.discourse.org/u/nekodroid)\ **Replies:** 7\ **Last updated:** [May 25, 2020, 1:38pm UTC](https://meta.discourse.org/t/trying-to-install-apache2/152592 "2020-05-25T13:38:37Z")
Hello, As title says I’ve ran sudo apt install apache2. The server won’t start and this is the error : (98)Address already in use: AH00072: make\_sock: could not bind to address \[::\]:80 (98)Address already in use: AH00… --- ## [Help me setup many websites on one VPS](https://meta.discourse.org/t/help-me-setup-many-websites-on-one-vps/152585)
**Author:** [@hinhsymo](https://meta.discourse.org/u/hinhsymo)\ **Replies:** 3\ **Last updated:** [May 25, 2020, 10:15am UTC](https://meta.discourse.org/t/help-me-setup-many-websites-on-one-vps/152585 "2020-05-25T10:15:00Z")
Hi support ! i have one VPS 2G ram - i want to setup 3 website discourse on 1 VPS i view link: How to Install Discourse Forum with Nginx on Ubuntu 16.04 Step 1 - Install Docker on Ubuntu 16.04 Step 2 - Install and co… --- ## [Huge amount of storage transactions](https://meta.discourse.org/t/huge-amount-of-storage-transactions/151922)
**Author:** [@klopsknoedel](https://meta.discourse.org/u/klopsknoedel)\ **Replies:** 12\ **Last updated:** [May 25, 2020, 1:29am UTC](https://meta.discourse.org/t/huge-amount-of-storage-transactions/151922 "2020-05-25T01:29:03Z")
Hi, we’re facing huge transaction loads on our storage from time to time. We couldn’t find any schedule or time-pattern for this event but it happens at least once a day. Even the duration changes from 10min to several … --- ## [How to migrate from one Digitalocean Droplet to a another Droplet in a different Digitalocean account](https://meta.discourse.org/t/how-to-migrate-from-one-digitalocean-droplet-to-a-another-droplet-in-a-different-digitalocean-account/152475)
**Author:** [@Schoebi](https://meta.discourse.org/u/Schoebi)\ **Replies:** 2\ **Last updated:** [May 24, 2020, 6:05am UTC](https://meta.discourse.org/t/how-to-migrate-from-one-digitalocean-droplet-to-a-another-droplet-in-a-different-digitalocean-account/152475 "2020-05-24T06:05:39Z")
Following Move your Discourse Instance to a Different Server I made a backup within Discourse and restored it on the new discourse instance. But it didn’t affect the content or anything on the new instance. Do I have to … --- ## [Incorrect IpV4?](https://meta.discourse.org/t/incorrect-ipv4/152323)
**Author:** [@archie123](https://meta.discourse.org/u/archie123)\ **Replies:** 22\ **Last updated:** [May 22, 2020, 2:32pm UTC](https://meta.discourse.org/t/incorrect-ipv4/152323 "2020-05-22T14:32:32Z")
Hey! I’m trying to setup my forum in WSL2, and when I put in my forum’s url it says this: I don’t know why this is happening, I got my IP in the terminal, set it in my DNS here: --- ## [Minimum (Hardened) File Permissions](https://meta.discourse.org/t/minimum-hardened-file-permissions/148974)
**Author:** [@maltfield](https://meta.discourse.org/u/maltfield)\ **Replies:** 2\ **Last updated:** [May 21, 2020, 6:12am UTC](https://meta.discourse.org/t/minimum-hardened-file-permissions/148974 "2020-05-21T06:12:22Z")
Is there any published guidance for the proper/minimum/hardened file permissions for Discourse? Specifically, I’m looking for a set of idempotent commands using chown and chmod to strip the permissions to be as low as p… --- ## [Trouble with latest update](https://meta.discourse.org/t/trouble-with-latest-update/152052)
**Author:** [@alehandrof](https://meta.discourse.org/u/alehandrof)\ **Replies:** 2\ **Last updated:** [May 20, 2020, 10:24am UTC](https://meta.discourse.org/t/trouble-with-latest-update/152052 "2020-05-20T10:24:04Z")
I’m having trouble with the latest update. Now my Discourse site is down and will not get up :frowning: After updating via the admin I was prompted to rebuild the app via the commandline. I did ./launcher rebuild app an… --- ## [Clarification needed on memory requirements for Docker install](https://meta.discourse.org/t/clarification-needed-on-memory-requirements-for-docker-install/151976)
**Author:** [@EricGT](https://meta.discourse.org/u/EricGT)\ **Replies:** 4\ **Last updated:** [May 19, 2020, 8:21pm UTC](https://meta.discourse.org/t/clarification-needed-on-memory-requirements-for-docker-install/151976 "2020-05-19T20:21:10Z")
The minimum hardware requirements for install notes 1 GB RAM minimum (with swap) The link for swap notes :bulb: For servers with \<= 2GB of RAM, running ./discourse-setup will prompt for and automatically create a 2G… --- ## [Bind for 0.0.0.0:443 failed: port is already allocated](https://meta.discourse.org/t/bind-for-0-0-0-0-443-failed-port-is-already-allocated/151871)
**Author:** [@Rs40x](https://meta.discourse.org/u/Rs40x)\ **Replies:** 1\ **Last updated:** [May 19, 2020, 8:31pm UTC](https://meta.discourse.org/t/bind-for-0-0-0-0-443-failed-port-is-already-allocated/151871 "2020-05-19T20:31:08Z")
Forums are down since rebuild failed during the upgrade (var/discourse/launcher rebuild app). I tried the solution from here. The Following solution did not work. systemctl stop docker rm -rf /var/lib/docker/network/… --- ## [Error 521 after latest update due to CloudFlare settings](https://meta.discourse.org/t/error-521-after-latest-update-due-to-cloudflare-settings/128272)
**Author:** [@Pravi](https://meta.discourse.org/u/Pravi)\ **Replies:** 19\ **Last updated:** [May 19, 2020, 3:49pm UTC](https://meta.discourse.org/t/error-521-after-latest-update-due-to-cloudflare-settings/128272 "2020-05-19T15:49:28Z")
Hello Guys!! The whole site is down after update to the latest version. After the update, I rebooted the whole server. I am using Cloudflare. Don’t know what is the real issue. Need some serious help!! --- ## [Installation Help on namehero.com](https://meta.discourse.org/t/installation-help-on-namehero-com/151855)
**Author:** [@jakedev](https://meta.discourse.org/u/jakedev)\ **Replies:** 1\ **Last updated:** [May 18, 2020, 5:25pm UTC](https://meta.discourse.org/t/installation-help-on-namehero-com/151855 "2020-05-18T17:25:59Z")
How would I install this using https://namehero.com, It has CPanel and I can’t find a way to install this to my website that namehero hosts. --- ## [Can't uninstall on Ubuntu 18.04](https://meta.discourse.org/t/cant-uninstall-on-ubuntu-18-04/151770)
**Author:** [@online\_0227](https://meta.discourse.org/u/online_0227)\ **Replies:** 3\ **Last updated:** [May 17, 2020, 9:11pm UTC](https://meta.discourse.org/t/cant-uninstall-on-ubuntu-18-04/151770 "2020-05-17T21:11:44Z")
I followed guide here: and now I want to remove it along with database, and possibly re-install so that I get clean one. command like: . /launcher stop app it doesn’t. This is discourse’s file sturctures: --- ## [Corrupted item pointer during backup process](https://meta.discourse.org/t/corrupted-item-pointer-during-backup-process/151680)
**Author:** [@RikoDEV](https://meta.discourse.org/u/RikoDEV)\ **Replies:** 6\ **Last updated:** [May 17, 2020, 4:55pm UTC](https://meta.discourse.org/t/corrupted-item-pointer-during-backup-process/151680 "2020-05-17T16:55:59Z")
Discourse version: 2.5.0.beta4 (e81a4048e3) When trying to backup, I get the error given below. \[2020-05-16 10:09:19\] pg\_dump: processing data for table "public.reviewable\_claimed\_topics" \[2020-05-16 10:09:19\] pg\_dump:… --- ## [Discourse Update Probs. Help please](https://meta.discourse.org/t/discourse-update-probs-help-please/151651)
**Author:** [@Vaughan](https://meta.discourse.org/u/Vaughan)\ **Replies:** 5\ **Last updated:** [May 16, 2020, 2:45pm UTC](https://meta.discourse.org/t/discourse-update-probs-help-please/151651 "2020-05-16T14:45:22Z")
Hi all, I’m a tech for an online Discourse Forum that for some reason?? (which I can’t put my finger on) is running a beta version 2.5.0 beta 3 I have the owner who isn’t very tech savvy who I think has continually che… --- ## [How can I directly edit Discourse database from a GUI?](https://meta.discourse.org/t/how-can-i-directly-edit-discourse-database-from-a-gui/138520)
**Author:** [@Paul\_King](https://meta.discourse.org/u/Paul_King)\ **Replies:** 20\ **Last updated:** [May 14, 2020, 8:18pm UTC](https://meta.discourse.org/t/how-can-i-directly-edit-discourse-database-from-a-gui/138520 "2020-05-14T20:18:13Z")
I am looking for some sort of user friendly utility that can run SQL queries that can globally tidy up my current database containing posts and users imported from two different older forums - for example deleting topics… --- ## [How to install discourse in Hosting?](https://meta.discourse.org/t/how-to-install-discourse-in-hosting/151525)
**Author:** [@Jose1992](https://meta.discourse.org/u/Jose1992)\ **Replies:** 2\ **Last updated:** [May 14, 2020, 7:54pm UTC](https://meta.discourse.org/t/how-to-install-discourse-in-hosting/151525 "2020-05-14T19:54:47Z")
Hello, I want to set up an foro atletico de madrid and I like Discourse is very fast. Can discourse be installed on a hosting? or does it have to be a VPS? What do you recomend me? I did not find a way to install Disco… --- ## [Unable to get the verification email](https://meta.discourse.org/t/unable-to-get-the-verification-email/131794)
**Author:** [@Yankxcool](https://meta.discourse.org/u/Yankxcool)\ **Replies:** 2\ **Last updated:** [October 24, 2019, 4:58pm UTC](https://meta.discourse.org/t/unable-to-get-the-verification-email/131794 "2019-10-24T16:58:39Z")
Hello guys, after three hours I don’t know what more to test. I have re-installed many but anything is working properly. I have checked my SMTP configuration with an external site and is working fine. My domain provid… [Previous page](https://meta.discourse.org/c/support/self-hosting/31.md?page=100) [Next page](https://meta.discourse.org/c/support/self-hosting/31.md?page=102)