Setting up the Spotfire database (PostgreSQL)
There are multiple ways to set up a PostgreSQL server for storing the Spotfire database, as discussed in previous sections. This topic lists more information about some parameters you must provide, and detailed steps for setting up the database using the provided scripts.
About this task
To create and configure the Spotfire databases in a containerized environment, use the Cloud Deployment Kit for Spotfire on GitHub or the prebuilt container images.
For example, increasing
shared_buffers
(e.g., to 2 GB) can have a large
impact on performance. You might also want to tune things like the
work_mem
,
maintenance_work_mem
and
effective_cache_size
. You can search for information
about how you can tune your PostgreSQL server and find tips from PostgreSQL or
external sources like, for example,
this page.
To use the provided scripts to set up the database, follow the steps below.
Before you begin
- Download and unzip the Spotfire Server installation kit from the Spotfire Download site. For instructions, see Downloading installation software.
- The command-line database tool psql must be installed in the system when configuring the database server using scripts.
- You have access to a PostgreSQL database server.
Procedure
Results
The log file log.txt file is created in the working directory. If the execution should fail, then the log file contains information about the failure. If the execution succeeds, then information about the changes made to the database is available in the log file.