Toolkit update error

[jerryxwu]

Relevant system information:

• OS: WSL running Ubuntu 20.04
• PG: 14.2
• TimescaleDB: 2.6.1
• TimescaleDB: 1.5.1 & 1.6.0
• Installation method: timescaledb-ha docker

Describe the bug
Attempting to update from 1.5.1 to 1.6.0 failed with error message:
ERROR: attempt to redefine parameter "timescaledb_toolkit_acknowledge_auto_drop"

To Reproduce
Steps to reproduce the behavior:

1. docker run -d --name tsdb -p 5432:5432 -e POSTGRES_PASSWORD=password timescale/timescaledb-ha:pg14.2-ts2.6.1-latest
2. docker exec -it tsdb psql -U postgres
3. CREATE EXTENSION timescaledb_toolkit VERSION "1.5.1";
4. \dx timescaledb_toolkit;
5. ALTER EXTENSION timescaledb_toolkit UPDATE; should produce the aforementioned error. More importantly, the toolkit version stays at 1.5.1, not 1.6.0.

Expected behavior
timescaledb_toolkit extension should be updated to "1.6.0"

Actual behavior
timescaledb_toolkit extension stays at "1.5.1".

Workaround
Start a new psql session and run ALTER EXTENSION timescaledb_toolkit UPDATE;, the extension may be updated correctly. I've seen this happening twice to me.

[jerryxwu]

I just confirmed the same behaviour on the Timescale cloud.

[jerryxwu]

@JLockerman do you think this might be fixed by PR #395 ?

[jerryxwu]

Users no longer need to CREATE EXTENSION after starting timescaledb-ha docker. The issue can no longer be reproduced.