Copy Timescale data to new table for Auditlog

[ootneim]

Copy data from Timescale to a new Table for Auditlog

Procedure is located here: https://github.com/Altinn/altinn-platform/issues/906

Performed in

• [x] AT21
• [x] AT22
• [x] AT23
• [x] AT24
• [ ] YT01
• [ ] TT02
• [ ] PROD

SQL Commands:

CREATE TABLE authentication.eventlogv0 (LIKE authentication.eventlog INCLUDING ALL);

INSERT INTO authentication.eventlogv0
SELECT * FROM authentication.eventlog;

CREATE INDEX authentication_eventlogv0_created_idx ON authentication.eventlogv0 (created);

CREATE TABLE authz.eventlogv0 (LIKE authz.eventlog INCLUDING ALL);

INSERT INTO authz.eventlogv0
SELECT * FROM authz.eventlog;

CREATE INDEX authz_eventlogv0_created_idx ON authz.eventlogv0 (created);

[acn-dgopa]

We have now decided to remove the use of timescaledb from the auditlog database. A background service part of auditlog application will create necessary partitions automatically. It will use the native postgres partition and it will be a new table. The existing data on the table that uses timescale partitioning should be migrated to a new table without timescale. This will be done by the infra team.

[ootneim]

@acn-dgopa What are the names of the new tables?

[acn-dgopa]

The old data must be migrated as follows authentication.eventlog --->authentication.eventlogv0 authz.eventlog -----> authz.eventlogv0