Lack of update path

[kelvk]

When attempting to update pg_prometheus:

ERROR:  extension "pg_prometheus" has no update path from version "0.0.1" to version "0.2"

I had to place an empty 0.0.1--0.2.sql file in the extension directory as suggested by @niksajakovljevic to work around it.

[momania]

I'm seeing the same problem when trying to update to 0.2.1.

I've tried the suggested work around, placed a an empty file at /var/lib/postgresql/9.6/main/pg_promtheus/0.0.1--0.2.1.sql, but the error is still there.

[niksajakovljevic]

@momania Not sure if that's the proper folder to store it? I guess the file should be named pg_prometheus--0.0.1--0.2.1.sql and should be stored where the rest of extensions sql scripts are: for PG10 thats ./share/extension/

[momania]

Ah go it!

For reference: you can find $SHAREDIR by looking at the output of pg_config

In my case, creating empty file /usr/share/postgresql/9.6/extension/pg_prometheus--0.0.1--0.2.1.sql did the trick.