Helm chart doesn't create the DB for external databases #175

New Issue

Wael · 2021-06-11T14:46:25Z

Wael commented

2021-06-11 14:46:25 +00:00

When I try to install Gitea with a new external Database "postgres", I receive the below error

pq: database "gitea" does not exist

I'm installing Gitea via the helm chart.

When I try to install Gitea with a new external Database "postgres", I receive the below error ``` pq: database "gitea" does not exist ``` I'm installing Gitea via the helm chart.

volker.raschek commented

2021-06-12 15:19:04 +00:00

You need to set up the external database manually.

CREATE SCHEMA gitea;
CREATE USER gitea  WITH LOGIN PASSWORD 'yourSecretPassword';
GRANT ALL ON SCHEMA gitea TO gitea; 
ALTER USER gitea SET search_path=gitea;

Use the following config to use the external postgres database and adapt the settings.

    database:
      CHARSET: utf8
      DB_TYPE: postgres
      USER: gitea
      PASSWD: yourSecretPassword
      HOST: 1.2.3.4:5432
      NAME: postgres
      SSL_MODE: disable
      SCHEMA: gitea

You need to set up the external database manually. ```sql CREATE SCHEMA gitea; CREATE USER gitea WITH LOGIN PASSWORD 'yourSecretPassword'; GRANT ALL ON SCHEMA gitea TO gitea; ALTER USER gitea SET search_path=gitea; ``` Use the following config to use the external postgres database and adapt the settings. ```yaml database: CHARSET: utf8 DB_TYPE: postgres USER: gitea PASSWD: yourSecretPassword HOST: 1.2.3.4:5432 NAME: postgres SSL_MODE: disable SCHEMA: gitea ```

👍 1

luhahn closed this issue

2021-06-22 14:27:16 +00:00

Sign in to join this conversation.

No Milestone

No Assignees

2 Participants

Notifications

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: gitea/helm-chart#175