Skip to content

Files

Latest commit

de2a2d4 · Jan 20, 2025

History

History

perun-db

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
Jan 29, 2021
Sep 29, 2022
Jan 16, 2025
Jan 22, 2024
Nov 8, 2022
Jun 24, 2020
Oct 29, 2022
Jul 27, 2022
Jan 17, 2024
Jan 20, 2025

Perun DB

This module holds all DB related utilities, which are necessary to install and run Perun.

Supported DB types

  • Oracle (>11) support for Oracle was dropped in 3.10.0
  • Postgres (>=9.5)

Data in Perun is stored using UTF-8 charset. When using Oracle DB, some columns are limited to 4000 of ASCII characters (1000 with full UTF-8 set).

Installation

Theses instructions doesn't cover creation of initial user (perun admin) and setting up other components like Apache and Tomcat. For complete installation instructions please refer to our wiki.

Empty schema of Perun's database can be created using postgres.sql. Before running sql files please fill or edit username/schema/password in them to match your setting.

  • Create user perun and grant it access from localhost.
  • Create schema perun and grant all privileges to user perun.
  • Install official extension unaccent and add it to schema perun (must be performed by user perun with temporary elevated privileges).
  • Log-in as user perun and run postgres.sql to create empty tables.