Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings
This repository was archived by the owner on Dec 12, 2024. It is now read-only.
/devops-composePublic archive

Commitbef2aa4

Browse files
committed
Add create-database.sql
1 parentf23fb98 commitbef2aa4

File tree

7 files changed

+28
-69
lines changed

7 files changed

+28
-69
lines changed

‎docker-compose.yml‎

Lines changed: 0 additions & 16 deletions
Original file line numberDiff line numberDiff line change
@@ -120,21 +120,6 @@ services:
120120
environment:
121121
POSTGRES_USER:postgres
122122
POSTGRES_PASSWORD:postgres
123-
JIRA_DB_NAME:jira
124-
JIRA_DB_USER:jira
125-
JIRA_DB_PASSWORD:jira
126-
CONFLUENCE_DB_NAME:confluence
127-
CONFLUENCE_DB_USER:confluence
128-
CONFLUENCE_DB_PASSWORD:confluence
129-
GITBUCKET_DB_NAME:gitbucket
130-
GITBUCKET_DB_USER:gitbucket
131-
GITBUCKET_DB_PASSWORD:gitbucket
132-
MATTERMOST_DB_NAME:mattermost
133-
MATTERMOST_DB_USER:mattermost
134-
MATTERMOST_DB_PASSWORD:mattermost
135-
OWNCLOUD_DB_NAME:owncloud
136-
OWNCLOUD_DB_USER:owncloud
137-
OWNCLOUD_DB_PASSWORD:owncloud
138123
volumes:
139124
-db-data:/var/lib/postgresql/data
140125

@@ -180,4 +165,3 @@ networks:
180165
reverse-proxy-network:
181166
external:
182167
name:${REVERSE_PROXY_NETWORK}
183-

‎postgres/Dockerfile‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,2 +1,2 @@
11
FROM postgres:9.4
2-
ADD init-*.sh /docker-entrypoint-initdb.d/
2+
COPY create-database.sql /docker-entrypoint-initdb.d/

‎postgres/create-database.sql‎

Lines changed: 27 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,27 @@
1+
-- JIRA
2+
-- https://confluence.atlassian.com/adminjiraserver072/connecting-jira-applications-to-postgresql-828787559.html
3+
CREATEUSERjira PASSWORD'jira';
4+
CREATEDATABASEjira WITH ENCODING'UNICODE' LC_COLLATE'C' LC_CTYPE'C' TEMPLATE template0;
5+
GRANT ALL PRIVILEGESON DATABASE jira TO jira;
6+
7+
-- Confluence
8+
-- https://confluence.atlassian.com/doc/database-setup-for-postgresql-173244522.html
9+
CREATEUSERconfluence PASSWORD'confluence';
10+
CREATEDATABASEconfluence;
11+
GRANT ALL PRIVILEGESON DATABASE confluence TO confluence;
12+
13+
-- GitBucket
14+
CREATEUSERgitbucket PASSWORD'gitbucket';
15+
CREATEDATABASEgitbucket;
16+
GRANT ALL PRIVILEGESON DATABASE gitbucket TO gitbucket;
17+
18+
-- Mattermost
19+
-- https://github.com/mattermost/mattermost-docker
20+
CREATEUSERmattermost PASSWORD'mattermost';
21+
CREATEDATABASEmattermost;
22+
GRANT ALL PRIVILEGESON DATABASE mattermost TO mattermost;
23+
24+
-- ownCloud
25+
CREATEUSERowncloud PASSWORD'owncloud';
26+
CREATEDATABASEowncloud;
27+
GRANT ALL PRIVILEGESON DATABASE owncloud TO owncloud;

‎postgres/init-gitbucket.sh‎

Lines changed: 0 additions & 11 deletions
This file was deleted.

‎postgres/init-jira.sh‎

Lines changed: 0 additions & 14 deletions
This file was deleted.

‎postgres/init-mattermost.sh‎

Lines changed: 0 additions & 14 deletions
This file was deleted.

‎postgres/init-owncloud.sh‎

Lines changed: 0 additions & 13 deletions
This file was deleted.

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp