Mercurial > p > roundup > code
annotate scripts/systemd.gunicorn @ 7719:3071db43bfb6
feat: issue2550852 - support using a specified PostgreSQL db schema
Finally after 7 years this is closed.
roundup/backends/back_postgresql.py:
Support use of schema when specified in RDBMS_NAME. Stuart McGraws
code is finally merged 8-).
test/test_postgresql.py, test/conftest.py:
Run all postgresql tests in the schema db as well.
Also make sure that db_nuke raises an error when trying to delete
the schema test database. Conftest defines pg_schema mark that can
be used to exclude schema tests with pytest -m "not pg_schema".
roundup/configuration.py:
change doc on RDBMS_NAME to include db.schema form.
.travis.yml, .github/workflows/ci-test.yml:
create schema test db; add user for testing with schema; grant new
user create privs for schema.
doc/installation.txt:
Reference to roundup-admin init deleting schema added.
doc/mysql.txt doc/postgresql.txt:
New documentation on psql/mysql commands to set up a production db.
doc/upgrading.txt:
mention schema support, also document service setting for
selecting connection from pg_service.conf.
doc/reference.txt:
update config.ini documentation for RDBMS_NAME.
| author | John Rouillard <rouilj@ieee.org> |
|---|---|
| date | Wed, 27 Dec 2023 22:52:14 -0500 |
| parents | c63df349f319 |
| children |
| rev | line source |
|---|---|
|
6344
c63df349f319
issue2551117 - add example systemd config
John Rouillard <rouilj@ieee.org>
parents:
diff
changeset
|
1 [Unit] |
|
c63df349f319
issue2551117 - add example systemd config
John Rouillard <rouilj@ieee.org>
parents:
diff
changeset
|
2 Description=Roundup Server - roundup |
|
c63df349f319
issue2551117 - add example systemd config
John Rouillard <rouilj@ieee.org>
parents:
diff
changeset
|
3 |
|
c63df349f319
issue2551117 - add example systemd config
John Rouillard <rouilj@ieee.org>
parents:
diff
changeset
|
4 [Service] |
|
c63df349f319
issue2551117 - add example systemd config
John Rouillard <rouilj@ieee.org>
parents:
diff
changeset
|
5 User=roundup |
|
c63df349f319
issue2551117 - add example systemd config
John Rouillard <rouilj@ieee.org>
parents:
diff
changeset
|
6 WorkingDirectory=/path/to/roundup/trackers/roundup |
|
c63df349f319
issue2551117 - add example systemd config
John Rouillard <rouilj@ieee.org>
parents:
diff
changeset
|
7 SyslogIdentifier=roundup-server-roundup |
|
c63df349f319
issue2551117 - add example systemd config
John Rouillard <rouilj@ieee.org>
parents:
diff
changeset
|
8 ExecStart=/path/to/gunicorn -b unix:///var/run/roundup/roundup.sock wsgi -w 4 --preload --max-requests 128 --max-requests-jitter 32 --timeout 60 --graceful-timeout 60 --access-logfile - --error-logfile |
|
c63df349f319
issue2551117 - add example systemd config
John Rouillard <rouilj@ieee.org>
parents:
diff
changeset
|
9 ExecReload=/bin/kill -HUP $MAINPID |
|
c63df349f319
issue2551117 - add example systemd config
John Rouillard <rouilj@ieee.org>
parents:
diff
changeset
|
10 ExecStop = /bin/kill -s TERM $MAINPID |
|
c63df349f319
issue2551117 - add example systemd config
John Rouillard <rouilj@ieee.org>
parents:
diff
changeset
|
11 KillMode=mixed |
|
c63df349f319
issue2551117 - add example systemd config
John Rouillard <rouilj@ieee.org>
parents:
diff
changeset
|
12 Restart=on-failure |
|
c63df349f319
issue2551117 - add example systemd config
John Rouillard <rouilj@ieee.org>
parents:
diff
changeset
|
13 RestartSec=15s |
|
c63df349f319
issue2551117 - add example systemd config
John Rouillard <rouilj@ieee.org>
parents:
diff
changeset
|
14 |
|
c63df349f319
issue2551117 - add example systemd config
John Rouillard <rouilj@ieee.org>
parents:
diff
changeset
|
15 [Install] |
|
c63df349f319
issue2551117 - add example systemd config
John Rouillard <rouilj@ieee.org>
parents:
diff
changeset
|
16 WantedBy=multi-user.target |