# \#postgres **URL:** https://meta.discourse.org/tag/postgres/874.md [Latest](https://meta.discourse.org/latest.md) · [Categories](https://meta.discourse.org/categories.md) · [Tags](https://meta.discourse.org/tags.md) --- ## [Error running remap after changing site url](https://meta.discourse.org/t/error-running-remap-after-changing-site-url/406649)
**Author:** [@tobiaseigen](https://meta.discourse.org/u/tobiaseigen)\ **Replies:** 12\ **Last updated:** [July 3, 2026, 2:20am UTC](https://meta.discourse.org/t/error-running-remap-after-changing-site-url/406649 "2026-07-03T02:20:41Z")
I changed the URL of my discourse site, and am following the directions in Change the domain name or rename your Discourse. When attempting to run remap, I am repeatedly getting the following error. It keeps telling me t… --- ## [Which versions of AWS Aurora Postgres are supported?](https://meta.discourse.org/t/which-versions-of-aws-aurora-postgres-are-supported/393871)
**Author:** [@stevejr](https://meta.discourse.org/u/stevejr)\ **Replies:** 1\ **Last updated:** [January 20, 2026, 11:42am UTC](https://meta.discourse.org/t/which-versions-of-aws-aurora-postgres-are-supported/393871 "2026-01-20T11:42:30Z")
Hi, According to the official separate Postgres installation docs, Postgres v13 is supported but later versions may/may not work. This document is pretty old so not sure if the statement is still correct. As V13 of AWS… --- ## [“Move to existing topic” search silently fails while site search still works](https://meta.discourse.org/t/move-to-existing-topic-search-silently-fails-while-site-search-still-works/392872)
**Author:** [@Ethsim2](https://meta.discourse.org/u/Ethsim2)\ **Replies:** 3\ **Last updated:** [January 7, 2026, 2:04pm UTC](https://meta.discourse.org/t/move-to-existing-topic-search-silently-fails-while-site-search-still-works/392872 "2026-01-07T14:04:45Z")
Hi, I’m seeing an issue with the “Move to existing topic” modal (this previously worked on my site, so appears to be a regression): Typing in Search for a Topic does not refine results Network requests return 200 with… --- ## [Fresh install discourse 3.4.7 fail : Failed to create 'badge\_posts' view](https://meta.discourse.org/t/fresh-install-discourse-3-4-7-fail-failed-to-create-badge-posts-view/378853)
**Author:** [@janfy](https://meta.discourse.org/u/janfy)\ **Replies:** 1\ **Last updated:** [August 16, 2025, 9:32am UTC](https://meta.discourse.org/t/fresh-install-discourse-3-4-7-fail-failed-to-create-badge-posts-view/378853 "2025-08-16T09:32:49Z")
Hi, Discourse v3.4.7 install from scratch failed with the following error : 08:18:53.15 INFO ==\> Populating database rake aborted! StandardError: An error has occurred, this and all later migrations canceled: (Standa… --- ## [DB corrupted after Linode outage?](https://meta.discourse.org/t/db-corrupted-after-linode-outage/376350)
**Author:** [@Dannii](https://meta.discourse.org/u/Dannii)\ **Replies:** 1\ **Last updated:** [July 29, 2025, 6:36pm UTC](https://meta.discourse.org/t/db-corrupted-after-linode-outage/376350 "2025-07-29T18:36:53Z")
I think my forum’s DB is now corrupted after the recent Linode outage, I’m seeing this in its postgres log: LOG: database system was interrupted; last known up at 2025-07-27 10:46:10 UTC LOG: invalid primary checkpoi… --- ## [Connect to database and redis on a docker host using sockets](https://meta.discourse.org/t/connect-to-database-and-redis-on-a-docker-host-using-sockets/359549)
**Author:** [@silverdr](https://meta.discourse.org/u/silverdr)\ **Replies:** 1\ **Last updated:** [March 31, 2025, 12:54am UTC](https://meta.discourse.org/t/connect-to-database-and-redis-on-a-docker-host-using-sockets/359549 "2025-03-31T00:54:40Z")
I have a multisite running in a container, connecting to remote “databases” server, with postgres and redis running over there. Now I want to move both of those to the host dockerised discourse runs on and connect to the… --- ## [Error while Plugin Install](https://meta.discourse.org/t/error-while-plugin-install/359403)
**Author:** [@crazzybat](https://meta.discourse.org/u/crazzybat)\ **Replies:** 0\ **Last updated:** [March 29, 2025, 7:31am UTC](https://meta.discourse.org/t/error-while-plugin-install/359403 "2025-03-29T07:31:41Z")
I’m am try to install a plugin Discourse Reaction but give me this error. Please help me with this. postgres already running stop container FAILED Pups::ExecError: if \[ -f /root/install\_postgres \]; then/root/install\_p… --- ## [Discourse Randomly Does Not run or Rebuild](https://meta.discourse.org/t/discourse-randomly-does-not-run-or-rebuild/358231)
**Author:** [@joshhabka](https://meta.discourse.org/u/joshhabka)\ **Replies:** 15\ **Last updated:** [March 22, 2025, 3:51am UTC](https://meta.discourse.org/t/discourse-randomly-does-not-run-or-rebuild/358231 "2025-03-22T03:51:15Z")
Out of nowhere, Discourse is no longer wanting to run and is not even rebuilding using ./launcher rebuild app. I commented out all plugins too. Here is the logs when I try to start it: https://codefile.io/f/8XUuOqyEDd H… --- ## [Upgrade from postgres 13 to 15 failing - currently means forum is unavailable](https://meta.discourse.org/t/upgrade-from-postgres-13-to-15-failing-currently-means-forum-is-unavailable/357028)
**Author:** [@tanya\_byrne](https://meta.discourse.org/u/tanya_byrne)\ **Replies:** 8\ **Last updated:** [March 13, 2025, 4:10pm UTC](https://meta.discourse.org/t/upgrade-from-postgres-13-to-15-failing-currently-means-forum-is-unavailable/357028 "2025-03-13T16:10:31Z")
Hi all, I am getting the below error when trying to run a rebuild to upgrade to most recent test-passed. This would include bumping the postgres version from 13 to 15. \[2025-03-12T20:49:22.045226 #1\] INFO -- : Replaci… --- ## [Postgresql OOM Errors?](https://meta.discourse.org/t/postgresql-oom-errors/354705)
**Author:** [@piffy](https://meta.discourse.org/u/piffy)\ **Replies:** 1\ **Last updated:** [February 26, 2025, 9:35pm UTC](https://meta.discourse.org/t/postgresql-oom-errors/354705 "2025-02-26T21:35:18Z")
It seems that about every 30 minutes or so I am getting this error: ActiveRecord::ConnectionNotEstablished : connection to server on socket “/var/run/postgresql/.s.PGSQL.5432” failed: FATAL: the database system is in … --- ## [Sidekiq job (Calculate Scores) are constantly failing after PG15 migration](https://meta.discourse.org/t/sidekiq-job-calculate-scores-are-constantly-failing-after-pg15-migration/354100)
**Author:** [@Dmitry\_Krasnoperov](https://meta.discourse.org/u/Dmitry_Krasnoperov)\ **Replies:** 1\ **Last updated:** [February 24, 2025, 3:39pm UTC](https://meta.discourse.org/t/sidekiq-job-calculate-scores-are-constantly-failing-after-pg15-migration/354100 "2025-02-24T15:39:18Z")
Greetings. All of a sudden after migration to PSQL15 one of my jobs (Calculate Scores) are constantly failing: Job exception: ERROR: could not open file "base/16384/544114.1" (target block 655360): previous segment is o… --- ## [Endlessly running Postgres processes & bad performance after Reinstall/restore](https://meta.discourse.org/t/endlessly-running-postgres-processes-bad-performance-after-reinstall-restore/352681)
**Author:** [@helmi](https://meta.discourse.org/u/helmi)\ **Replies:** 9\ **Last updated:** [February 17, 2025, 7:00pm UTC](https://meta.discourse.org/t/endlessly-running-postgres-processes-bad-performance-after-reinstall-restore/352681 "2025-02-17T19:00:04Z")
In an effort to update our Forum I did a fresh VPS install + Restore on the weekend. This was going to solve multiple issues for us: Renew outdated ubuntu Update Discourse Upgrade to Postgres 15 While generally thing… --- ## [How to optimize postgres and the discourse DB](https://meta.discourse.org/t/how-to-optimize-postgres-and-the-discourse-db/338275)
**Author:** [@Abdelrahman\_MoHamed](https://meta.discourse.org/u/Abdelrahman_MoHamed)\ **Replies:** 7\ **Last updated:** [December 9, 2024, 1:29pm UTC](https://meta.discourse.org/t/how-to-optimize-postgres-and-the-discourse-db/338275 "2024-12-09T13:29:14Z")
Sometimes DB gets fired because of some queries, and we were told that we need to optimize the PostgreSQL, any idea hot to achieve this? In the screen below this is our DB resources CPU: 4 vcpu Memory: 22 GB --- ## [Redis\_data & Postgres\_data are eating my 20GB+ Space](https://meta.discourse.org/t/redis-data-postgres-data-are-eating-my-20gb-space/341002)
**Author:** [@Vikash\_Kumar](https://meta.discourse.org/u/Vikash_Kumar)\ **Replies:** 16\ **Last updated:** [December 8, 2024, 8:41pm UTC](https://meta.discourse.org/t/redis-data-postgres-data-are-eating-my-20gb-space/341002 "2024-12-08T20:41:08Z")
What I can do about this? redis\_date & Postgres\_date are eating my 20GB+ Space Due to this, I am paying more on the digital ocean. My forum: https://onehourforum.com/ Everytime these two folder are taking much of my s… --- ## [Can database replica be used for read-only queries?](https://meta.discourse.org/t/can-database-replica-be-used-for-read-only-queries/340914)
**Author:** [@trobiyo](https://meta.discourse.org/u/trobiyo)\ **Replies:** 0\ **Last updated:** [December 6, 2024, 1:59pm UTC](https://meta.discourse.org/t/can-database-replica-be-used-for-read-only-queries/340914 "2024-12-06T13:59:10Z")
Hello Team, I’ve been looking around for some sort of documentation about the db\_replica\_host configuration, and whether this replica host can be used for database load balancing? (I.e., when using a replica, can SQL re… --- ## [Which is more performant: A separate PostgreSQL server? Or local PostgreSQL?](https://meta.discourse.org/t/which-is-more-performant-a-separate-postgresql-server-or-local-postgresql/314659)
**Author:** [@kuaza](https://meta.discourse.org/u/kuaza)\ **Replies:** 4\ **Last updated:** [July 9, 2024, 7:17pm UTC](https://meta.discourse.org/t/which-is-more-performant-a-separate-postgresql-server-or-local-postgresql/314659 "2024-07-09T19:17:45Z")
Which is more performant: A separate PostgreSQL server? Or local PostgreSQL? I have been running PostgreSQL on a separate server for a long time and use it on my site. From time to time I wonder, do you think this is ne… --- ## [Does anyone have a multisite with external postgres?](https://meta.discourse.org/t/does-anyone-have-a-multisite-with-external-postgres/314436)
**Author:** [@Isambard](https://meta.discourse.org/u/Isambard)\ **Replies:** 1\ **Last updated:** [July 1, 2024, 11:00am UTC](https://meta.discourse.org/t/does-anyone-have-a-multisite-with-external-postgres/314436 "2024-07-01T11:00:06Z")
Does anyone run multi-site with external postgres? I have multisite config like this: before\_bundle\_exec: - file: path: $home/config/multisite.yml contents: | example: adapter: …