以应用该设置。 3. 在数据库服务器上，以超级用户身份登录到数据库控制台： PostgreSQL 数据库准备 - 14 - 本文档使用 书栈网 · BookStack.CN 构建 1. su -c "psql" - postgres 4. 创建具有登录权限和密码的数据库用户（在 PostgreSQL 术语中称为角色）。请使用安全的、强密码，而不 是下面的 'gitea' ： 1. CREATE 放置在此类通用规则之上。 重启 PostgreSQL 以应用新的身份验证规则。 7. 在您的 Gitea 服务器上，测试与数据库的连接。 对于本地数据库： 1. psql -U gitea -d giteadb 对于远程数据库： 1. psql "postgres://gitea@203.0.113.3/giteadb" 其中 gitea 是数据库用户， giteadb 是数据库名称， ~/.postgresql/postgresql.crt ~/.postgresql/postgresql.key ~/.postgresql/root.crt 8. 测试与数据库的连接： 1. psql "postgres://gitea@example.db/giteadb?sslmode=verify-full" 您将被提示输入数据库用户的密码，然后连接到数据库。 虽然 Gitea 使用的MySQL驱动程序也支持双向

database 7. Restore the database from the backup: cat backup.sql | docker compose exec -T database psql --username weblate -- �→dbname weblate Hint: Please check that the database name matches POSTGRES_DATABASE Configuration instructions 175 The Weblate Manual, Release 4.18 docker compose exec -T database psql --username weblate --dbname weblate -c �→"ALTER USER weblate WITH PASSWORD 'weblate'" Hint: Please separate user account: # If PostgreSQL was not installed before, set the main password sudo -u postgres psql postgres -c "\password postgres" # Create a database user called "weblate" sudo -u postgres createuser

separate user account: # If PostgreSQL was not installed before, set the main password sudo -u postgres psql postgres -c "\password postgres" # Create a database user called "weblate" sudo -u postgres createuser database 7. Restore the database from the backup: cat backup.sql | docker-compose exec -T database psql --username weblate --dbname postgres 8. (Optional) Update password for the Weblate user. This might PostgreSQL 14 or 15 as way of storing passwords has been changed: docker-compose exec -T database psql --username weblate --dbname postgres -c "ALTER USER weblate WITH PASSWORD 'weblate'" 9. Start all

database 7. Restore the database from the backup: cat backup.sql | docker-compose exec -T database psql --username weblate -- �→dbname postgres 8. (Optional) Update password for the Weblate user. This PostgreSQL 14 or 15 as way of storing passwords has been changed: docker-compose exec -T database psql --username weblate --dbname postgres -c �→"ALTER USER weblate WITH PASSWORD 'weblate'" 9. Start separate user account: # If PostgreSQL was not installed before, set the main password sudo -u postgres psql postgres -c "\password postgres" # Create a database user called "weblate" sudo -u postgres createuser

separate user account: # If PostgreSQL was not installed before, set the main password sudo -u postgres psql postgres -c "\password postgres" # Create a database user called "weblate" sudo -u postgres createuser database 7. Restore the database from the backup: cat backup.sql | docker-compose exec -T database psql --username weblate --dbname postgres 8. (Optional) Update password for the Weblate user. This might PostgreSQL 14 or 15 as way of storing passwords has been changed: docker-compose exec -T database psql --username weblate --dbname postgres -c "ALTER USER weblate WITH PASSWORD 'weblate'" 9. Start all

database 7. Restore the database from the backup: cat backup.sql | docker compose exec -T database psql --username weblate -- �→dbname weblate Hint: Please check that the database name matches POSTGRES_DATABASE Configuration instructions 175 The Weblate Manual, Release 4.18.2 docker compose exec -T database psql --username weblate --dbname weblate -c �→"ALTER USER weblate WITH PASSWORD 'weblate'" Hint: Please separate user account: # If PostgreSQL was not installed before, set the main password sudo -u postgres psql postgres -c "\password postgres" # Create a database user called "weblate" sudo -u postgres createuser

database 7. Restore the database from the backup: cat backup.sql | docker-compose exec -T database psql --username weblate -- �→dbname postgres 8. (Optional) Update password for the Weblate user. This PostgreSQL 14 or 15 as way of storing passwords has been changed: docker-compose exec -T database psql --username weblate --dbname postgres -c �→"ALTER USER weblate WITH PASSWORD 'weblate'" 9. Start separate user account: # If PostgreSQL was not installed before, set the main password sudo -u postgres psql postgres -c "\password postgres" # Create a database user called "weblate" sudo -u postgres createuser

database 7. Restore the database from the backup: cat backup.sql | docker-compose exec -T database psql --username weblate -- �→dbname postgres 8. (Optional) Update password for the Weblate user. This PostgreSQL 14 or 15 as way of storing passwords has been changed: docker-compose exec -T database psql --username weblate --dbname postgres -c �→"ALTER USER weblate WITH PASSWORD 'weblate'" 9. Start separate user account: # If PostgreSQL was not installed before, set the main password sudo -u postgres psql postgres -c "\password postgres" # Create a database user called "weblate" sudo -u postgres createuser

separate user account: # If PostgreSQL was not installed before, set the main password sudo -u postgres psql postgres -c "\password postgres" # Create a database user called "weblate" sudo -u postgres createuser database 7. Restore the database from the backup: cat backup.sql | docker-compose exec -T database psql --username weblate --dbname postgres 8. (Optional) Update password for the Weblate user. This might PostgreSQL 14 or 15 as way of storing passwords has been changed: docker-compose exec -T database psql --username weblate --dbname postgres -c "ALTER USER weblate WITH PASSWORD 'weblate'" 9. Start all

database 7. Restore the database from the backup: cat backup.sql | docker compose exec -T database psql --username weblate -- �→dbname weblate Hint: Please check that the database name matches POSTGRES_DATABASE Configuration instructions 175 The Weblate Manual, Release 4.18.1 docker compose exec -T database psql --username weblate --dbname weblate -c �→"ALTER USER weblate WITH PASSWORD 'weblate'" Hint: Please separate user account: # If PostgreSQL was not installed before, set the main password sudo -u postgres psql postgres -c "\password postgres" # Create a database user called "weblate" sudo -u postgres createuser