Tag: database (databases)

11 occurrences

	Occurrence	Published
	PostgreSQL database creation Database users There are two users involved in the creation of Jiglu databases: the owner user, who owns all the databases and their tables, and can be used to perform data definition operations; the database user, who is used to connect from the Jiglu server and perform data manipulation operations. database, PostgreSQL Stephen Hebditch	7 April 2021, 15:08
	PostgreSQL installation Database initialisation The PostgreSQL database instance needs to be initialised before it is used for the first time and the database started. PostgreSQL, database, Configuration, Amazon Linux, package installation Stephen Hebditch	21 November 2023, 16:58
	PostgreSQL dump and restore Note that if you restore the database in this way it will then be necessary to rebuild the search indexes. PostgreSQL, Backup, Restore, database Stephen Hebditch	12 November 2020, 10:38
	Installing Jiglu on Amazon Web Services Either you can set the root volume to be a suitable size for the database or you can add a separate volume for the database. Amazon Web Services, database, sendmail, Configuration, PostgreSQL Stephen Hebditch	4 October 2023, 09:18
	Sendmail configuration The databases also need to be rebuilt. sendmail, milter, bootstrap.properties, Jiglu domain, Amazon Linux Stephen Hebditch	4 October 2023, 09:08
	Pre-installation checklist Database ▢ PostgreSQL 14+ ▢ Oracle 12c PostgreSQL will be suitable for most small to moderately large installations but we also support Oracle for organisations that prefer it. Supported software, MTA, sendmail, LDAP, OpenSuse Stephen Hebditch	4 October 2023, 09:13
	Licence key This gives differing abilities depending on the database: On PostgreSQL the default licence allows 10 users, 10 monitor users, 10 groups and access to all group types on a single server instance. LDAP, database Stephen Hebditch	4 October 2023, 09:26
	Jiglu installation directories /opt/jiglu/db Database scripts. Configuration, Directories, email, database, OpenSuse Stephen Hebditch	4 October 2023, 08:53
	Upgrading Jiglu For hotfix upgrades even if there is no data upgrade the version number of system stored in the database will always be changed to match the current version. Upgrading, Tomcat, architecture, Jiglu web application, Directories Stephen Hebditch	4 October 2023, 08:55
	Jiglu server installation For external hosts it will normally be 25. com.jiglu.jdbc.url The JDBC URL for connecting to the database server. com.jiglu.jdbc.password The password for the Jiglu database user at the database server. com.jiglu.jdbc.ownerPassword The password for the Jiglu owner user at the database server. bootstrap.properties, Jiglu server installation, package installation, Configuration, Jiglu system Stephen Hebditch	4 October 2023, 10:04
	Starting Jiglu for the first time However, following the initial install you will need to start it manually if you do not reboot the system: systemctl start jiglu When Jiglu is first run, the database schema that was previously created will be populated with the initial default data. Tomcat, database Stephen Hebditch	4 October 2023, 08:55