Pierre-Yves Chibon
00a6aae964
Rename the constraint
...
Signed-off-by: Pierre-Yves Chibon <pingou@pingoured.fr>
2021-02-12 17:48:04 +01:00
Pierre-Yves Chibon
72ad2d72c7
Save some of the queries we've used for the record
...
Signed-off-by: Pierre-Yves Chibon <pingou@pingoured.fr>
2021-02-12 11:01:49 +01:00
Pierre-Yves Chibon
60425dbea1
Adding an index on the msg_id field of messages when it's partitioned
...
Signed-off-by: Pierre-Yves Chibon <pingou@pingoured.fr>
2021-02-11 15:26:05 +01:00
Pierre-Yves Chibon
0b38388b51
Add a unique constraint on msg_id/timestamp on messages2
...
Signed-off-by: Pierre-Yves Chibon <pingou@pingoured.fr>
2021-02-11 15:18:21 +01:00
Pierre-Yves Chibon
c69127dbe6
Adding an index on the id field of messages when it's partitioned
...
Signed-off-by: Pierre-Yves Chibon <pingou@pingoured.fr>
2021-02-11 14:15:54 +01:00
Pierre-Yves Chibon
2060e10a2b
Add unique constraing and fix ownership
...
Signed-off-by: Pierre-Yves Chibon <pingou@pingoured.fr>
2021-02-11 12:39:44 +01:00
Pierre-Yves Chibon
7eb32d878a
Update migration_timescaledb.sql as we drop foreign key constraints
...
Signed-off-by: Pierre-Yves Chibon <pingou@pingoured.fr>
2021-02-11 12:15:26 +01:00
Pierre-Yves Chibon
221b86edad
Fix typo
...
Signed-off-by: Pierre-Yves Chibon <pingou@pingoured.fr>
2021-02-10 15:22:35 +01:00
Pierre-Yves Chibon
9971f132fb
Restructure migration_timescaledb
...
With this restructuration we adjust the FK before we make the messages2
table a hypertable.
Fingers crossed that'll help
Signed-off-by: Pierre-Yves Chibon <pingou@pingoured.fr>
2021-02-09 17:20:54 +01:00
Pierre-Yves Chibon
c5ea7e4010
Some more changes/improvements to the migration_timescaledb.sql file
...
Signed-off-by: Pierre-Yves Chibon <pingou@pingoured.fr>
2021-02-09 11:48:36 +01:00
Pierre-Yves Chibon
b9ad3e9c75
Add logic to fix the foreign key
...
Signed-off-by: Pierre-Yves Chibon <pingou@pingoured.fr>
2021-02-09 11:47:11 +01:00
Pierre-Yves Chibon
346ff989e2
Fix foreign key constraint
...
Signed-off-by: Pierre-Yves Chibon <pingou@pingoured.fr>
2021-02-05 16:53:10 +01:00
Pierre-Yves Chibon
807b58df14
Drop statements that don't apply to timescaledb
...
Signed-off-by: Pierre-Yves Chibon <pingou@pingoured.fr>
2021-02-04 09:33:27 +01:00
Pierre-Yves Chibon
72b02b0ad8
Add a migration_timescaledb script
...
This script contains the steps followed to install, configure,
enable, activate and convert the datanommer database to timescaledb
Signed-off-by: Pierre-Yves Chibon <pingou@pingoured.fr>
2021-02-04 09:32:09 +01:00
