Tag: PostgreSQL

7 occurrences
Occurrence Published
Published: April 2021

Installing Jiglu on Amazon Web Services

Change PostgreSQL passwords While the PostgreSQL database is not accessible externally, it is still essential to change the default passwords.

PostgreSQL database creation

Creating the database To create the owner user, the initial database and the connecting user use: cd /opt/jiglu/db/postgresql psql --set dbowner=owner-name \ --set dbownerpwd=owner-password \ --set dbuser=user-name \ --set dbuserpwd=user-password \ -f create_database.sql postgres postgres You will be prompted for the postgres user password (i.e. the postgres super user) and the owner user password if these are not set up as environment variables.

PostgreSQL installation

Automatic starting To enable PostgreSQL to start when the server is booted use: systemctl enable postgresql

Pre-installation checklist

Database ▢ PostgreSQL 10.0+ ▢ Oracle 12c ▢ SQL Server 2019 PostgreSQL will be suitable for most small to moderately large installations.

Published: November 2020

PostgreSQL dump and restore

Backup To manually backup the database use the PostgreSQL pg_dump command: pg_dump --create --format=c --file=backup.dmp --username=postgres jiglu You will be prompted for the password of the postgres user.

Published: September 2018

PostgreSQL tuning

You can find help with tuning a PostgreSQL server in the PostgreSQL wiki.

Published: September 2017

Getting started

To install Jiglu on Linux, first understand how it fits into other systems and what you need to get going: Server architecture Email integration Pre-installation checklist Next, install the prerequisites: PostgreSQL installation Java installation Tomcat installation Configuring Apache Then install and configure Jiglu: Jiglu server installation Sendmail configuration PostgreSQL database creation Finally start and use the application: Starting Jiglu for the first time Accessing Jiglu for the first time