Comments
Sort by recent activity
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 ...