Activity overview
Latest activity by jim brazendale
just encountered the same issue when upgrading from postgresql v13 to v16, the error can be reproduced in sql by running the following query : SELECT * FROM list_postgres_log_files() ORDER BY 1; and is fixed by recreating the extension and foreign data wrapper as per set up instructions: drop EXTENSION log_fdw cascade; select * from pg_available_extensions where name ='log_fdw'; CREATE EXTENSION IF NOT EXISTS pg_stat_statements; CREATE EXTENSION IF NOT EXISTS log_fdw; CREATE SERVER sqlmonitor_file_server FOREIGN DATA WRAPPER log_fdw; GRANT EXECUTE ON FUNCTION list_postgres_log_files() TO "*****"; GRANT EXECUTE ON FUNCTION create_foreign_table_for_log_file(text, text, text) TO "****"; GRANT USAGE ON FOREIGN SERVER sqlmonitor_file_server TO "****"; select * from pg_available_extensions where name ='log_fdw'; / comments
just encountered the same issue when upgrading from postgresql v13 to v16, the error can be reproduced in sql by running the following query :SELECT * FROM list_postgres_log_files() ORDER BY 1;and ...