Example Postgresql DB dump with fake tickets, for test purposes

RT Users
1

Hello all,

to test an upgrade procedure I have generated about 5.5 years worth of fake tickets with some “activity” (owner chages, state changes, comments and correspondences), related to v5.0.8 in a RT+RTIR installation.

It was generated calling the relevant endpoints of the REST 2.0 API in a simulated time period between Jan 1st, 2019 and about mid 2024.

If you think it can be useful for doing some tests, you can get it here:

  • https://codeberg.org/polettix/rtir-k8s/src/branch/burlish/context/v5.0.8/attachments
  • file starting with “04;…”, it is a tar.gz with file pg_dump.custom inside

Restoration assumes that the rt_user role already exists in the DB cluster and can be done like this:

# assume database rt5 exists
sudo -u postgres pg_restore --dbname=rt5 /path/to/pg_dump.custom

The root web user has password arargh if you want to take a look at the web interface too. Do not use in production, of course.

Hope it can be of help, cheers Flavio.

1 Like