# Postgres-Datenbank auf zentralen DB-Server verschieben: Build-Fehler

**URL:** <https://meta.discourse.org/t/moving-postgres-db-to-central-db-server-build-error/284615>\
**Category:** Self-hosting\
**Created:** [6. November 2023 um 19:44 UTC](https://meta.discourse.org/t/moving-postgres-db-to-central-db-server-build-error/284615 "2023-11-06T19:44:34Z")\
**Posts on this page:** 1\
**Showing post:** 13

<div class="post-metadata">

**Author:** ![Thomas\_Rother](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/thomas_rother/32/423597_2.png) [@Thomas\_Rother](https://meta.discourse.org/u/Thomas_Rother)\
**Post date:** [10. November 2023 um 22:14 UTC](https://meta.discourse.org/t/moving-postgres-db-to-central-db-server-build-error/284615/13 "2023-11-10T22:14:58Z")

</div>

… ok ok, es sieht so aus, als hätte ich hier weitere Berechtigungsprobleme, siehe /var/log/postgresql/postgresql-13-main.log:

```plaintext
2023-11-10 22:07:58.371 UTC [196127] postgres@postgres STATEMENT: ALTER DEFAULT PRIVILEGES IN SCHEMA 'public' GRANT ALL ON TABLES TO 'discourse';
2023-11-10 22:10:18.270 UTC [196160] discourse@discourse ERROR: permission denied for table site_settings
2023-11-10 22:10:18.270 UTC [196160] discourse@discourse STATEMENT: SELECT name, data_type, value FROM site_settings
2023-11-10 22:10:18.313 UTC [196160] discourse@discourse ERROR: permission denied for table users
2023-11-10 22:10:18.313 UTC [196160] discourse@discourse STATEMENT: SELECT COUNT(*) FROM (SELECT 1 AS one FROM "users" LIMIT 20) subquery_for_count

```

---

_[View the full topic](https://meta.discourse.org/t/moving-postgres-db-to-central-db-server-build-error/284615)._
