Tag: PostgreSQL
| Occurrence | Published | |
|---|---|---|
PostgreSQL installationAutomatic starting To enable PostgreSQL to start when the server is booted use: systemctl enable postgresql |
||
PostgreSQL database creationCreating 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 restoreBackup 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 tuningYou can find help with tuning a PostgreSQL server in the PostgreSQL wiki. |
||
Pre-installation checklistDatabase ▢ 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. |
||
Installing Jiglu on Amazon Web ServicesChange PostgreSQL passwords While the PostgreSQL database is not accessible externally, it is still essential to change the default passwords. |
||
Getting startedTo 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 |