Handle minor issues with the upgrade
This documents how to handle two minor issues I had while upgrading my database:
- I had some collation warnings on the
template_postgis
database, so I randocker exec ark-database psql --user devuser postgres -c "ALTER DATABASE template_postgis REFRESH COLLATION VERSION"
just like for the other databases - The performance was awful right after upgrading, so I ran
docker exec ark-database psql --user devuser arkindex_dev -c "ANALYZE VERBOSE"
to refresh all the statistics and everything immediately ran much more smoothly