How to remove Postgres extension
DROP EXTENSION pg_stat_statements;
pg-stat-statements
DOCKER container with postgres, WARNING: could not open statistics file “pg_stat_tmp/global.stat”: Operation not permitted
Simple and dumb I’ve tried another way: leaving the temporary file in container, where you need not deal with user permissions – and that worked. I’ve changed with inline command the Postgresql config in docker-compose.yml: postgresdb: image: ‘postgres’ command: postgres -c stats_temp_directory=/tmp . . . This is quick and simple solution, but it does not … Read more
pg_stat_statements enabled, but the table does not exist
Extension isn’t installed: SELECT * FROM pg_available_extensions WHERE name=”pg_stat_statements” and installed_version is not null; If the table is empty, create the extension: CREATE EXTENSION pg_stat_statements;