Tag: PostgreSQL

7 occurrences
Occurrence Published

PostgreSQL installation

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

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 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.

PostgreSQL tuning

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

Pre-installation checklist

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

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.

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