To update www_fdw with new feature (username & password header basic authorization) you have to do
drop extension & create extension step. (All your sql will be cascaded dropped).
This fix prevents this hard way update. Now you can do:
unpack new sources
export USE_PGXS=1
make & make install
psql -c "ALTER EXTENSION www_fdw UPDATE" db
That's it. Nothing else needed. It will work from next psql session.
Downgrade is more complicated and have some problems. I saw that you will need to restart PostgreSQL server and clean up share/extensions PostgreSQL LIB folder.
To downgrade version from 0.1.9 to 0.1.9:
ALTER EXTENSION www_fdw UPDATE TO '0.1.8';
To update www_fdw with new feature (username & password header basic authorization) you have to do drop extension & create extension step. (All your sql will be cascaded dropped).
This fix prevents this hard way update. Now you can do:
That's it. Nothing else needed. It will work from next psql session.
Downgrade is more complicated and have some problems. I saw that you will need to restart PostgreSQL server and clean up share/extensions PostgreSQL LIB folder. To downgrade version from 0.1.9 to 0.1.9: ALTER EXTENSION www_fdw UPDATE TO '0.1.8';