Comment on page
Working with the Tonic application database
Tonic uses a PostgreSQL database to store its internal state. This database does not store customer data. It only stores data that Tonic needs to operate.
In general, you do not need to connect directly to the Tonic application database. These details are provided if needed for advanced troubleshooting.
When you initially set up Tonic, you provide Tonic with connection details to a PostgreSQL database. How to connect depends on where you set up your PostgreSQL database.
Some customers set up a PostgreSQL database inside the same Docker network as the other Tonic containers. In that case, you should ensure that:
- Port 5432 is exposed on the PostgreSQL Docker container.
- Port 5432 is properly mapped.
To do this, add the following section to the PostgreSQL service section of your docker-compose file:
#This will expose Port 5432 on the docker container and map it to
#Port 5432 on the host machine
ports:
- 5432:5432
If you installed PostgreSQL in a standalone fashion, or you use a cloud service such as Amazon RDS, then make sure that the firewall settings and security groups allow a connection on the appropriate port.
You can use any PostgreSQL client. The following example uses psql, the PostgreSQL command line client.
#Format
#psql -h <HOST> -p <PORT> -U <user> -d <Tonic DB name>
#Example
psql -h localhost -p 5432 -U pguser -d allos
The Tonic application database includes a
ColumnSchema
table that contains the column schema information for your workspace source databases.By default, when you delete a workspace, Tonic does a soft delete. It marks the workspace as deleted, but does not remove the associated rows from the
ColumnSchema
table.To help prevent the table from growing too large, you can configure Tonic to instead do a hard delete, and remove the
ColumnSchema
rows that are associated with a deleted workspace.To have Tonic remove the
ColumnSchema
rows for deleted workspaces, set the environment setting TONIC_DELETE_COLUMN_SCHEMA_ON_WORKSPACE_DELETE
to true
.Last modified 8d ago