From decb2dc0e9f1167d5cd8fb4d455305be6b9fdfbe Mon Sep 17 00:00:00 2001 From: Richard Date: Tue, 4 Oct 2022 00:17:55 +0100 Subject: initial --- sql/README.md | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100755 sql/README.md (limited to 'sql/README.md') diff --git a/sql/README.md b/sql/README.md new file mode 100755 index 0000000..1dafe7a --- /dev/null +++ b/sql/README.md @@ -0,0 +1,11 @@ +# Database dump +partialemergence.sql contains an excerpt of the SONICS database system to be used with Partial Emergence. +The script should be executed on a PostgreSQL server with the version 13.1 or above and will create a database named *partialemergence*, a user with the same name, and relevant objects within the database which are used by SONICS UDOs. + +The executing user must have CREATE DATABASE and CREATE USER permissions among others, so it is best to run as an admin user or even the postgres user. + +The password for *partialemergence* is hardcoded in the sql script and matches the password specified in sonics/__config__.udo. These should be altered accordingly if required. + +If the database is to be run on the same host as Csound runs, then no alterations are required to __config__.udo ; otherwise PGDB_HOST should be changed or the relevant macro passed at invocation. + +The PostgreSQL instance's pg_hba.conf may also need altering in order to allow relevant host based access to the database. \ No newline at end of file -- cgit v1.2.3