search

citusdata / test-automation

Tools for making our tests easier to run
14 stars 5 forks source link

pg.{set,read}_config rely on having a non-broken version of postgres #33

Open lithp opened 7 years ago

lithp commented 7 years ago

So if you, for instance, run:

fab pg.set_config:shared_preload_libraries,'citus\,cstore_fdw' pg.restart

Without installing cstore first there's no easy way to fix the state you're now in. Running another pg.set_config will fail because it uses ALTER SYSTEM rather than edit the file directly.

lithp commented 7 years ago

As a workaround, you can run:

fab -- rm pg-latest/data/postgresql.auto.conf

Which will reset everything to the original configuration, which hopefully still works.