--- a/test/expected/extension_exists.out
+++ b/test/expected/extension_exists.out
@@ -1,126 +1,3 @@
-\i test/sql/common/reset.sql
-ALTER SYSTEM RESET pgaudit.log_directory;
-ALTER SYSTEM RESET pgaudit.log_filename;
-ALTER SYSTEM RESET pgaudit.log_file_mode;
-ALTER SYSTEM RESET pgaudit.log_rotation_age;
-ALTER SYSTEM RESET pgaudit.log_connections;
-ALTER SYSTEM RESET pgaudit.log_disconnections;
-ALTER SYSTEM RESET pgaudit.log_autoclose_minutes;
-ALTER SYSTEM RESET pgaudit.log_format;
-ALTER SYSTEM RESET pgaudit.log_execution_time;
-ALTER SYSTEM RESET pgaudit.log_execution_memory;
-ALTER SYSTEM RESET pgaudit.log_compression;
-ALTER SYSTEM RESET pgaudit.log_compression_level;
-ALTER SYSTEM RESET log_directory;
-ALTER SYSTEM RESET log_filename;
-ALTER SYSTEM RESET log_file_mode;
-ALTER SYSTEM RESET log_connections;
-ALTER SYSTEM RESET log_disconnections;
-SELECT pg_reload_conf();
- pg_reload_conf 
-----------------
- t
-(1 row)
-
-\i test/sql/common/setup.sql
--- pgauditlogtofile uses the log_timezone value for the date pattern
-DO $$
-DECLARE
-  tz text;
-BEGIN
-  SELECT setting INTO tz
-  FROM pg_settings
-  WHERE name = 'log_timezone';
-
-  EXECUTE format('SET TIMEZONE = %L', tz);
-END$$;
--- search for a text pattern in the current audit log file
-CREATE OR REPLACE FUNCTION pgauditlogtofile_regression_audit_log_content(pattern text) RETURNS text AS $$
-DECLARE
-  content text;
-BEGIN
-  content := pg_read_file(
-      current_setting('data_directory') || '/' ||
-      current_setting('pgaudit.log_directory') || '/' || 
-      'regression-audit-' || TO_CHAR(NOW(), 'YYYYMMDDHH24') || '.log');
-    
-  IF strpos(content, pattern) > 0 THEN
-    RETURN 'Found';
-  ELSE
-    RETURN 'Not Found';
-  END IF;
-END;
-$$ LANGUAGE plpgsql;
--- audit log file exists
-CREATE OR REPLACE FUNCTION pgauditlogtofile_regression_audit_file_exists() RETURNS boolean AS $$
-DECLARE
-  compression text := current_setting('pgaudit.log_compression');
-  extension text;
-  count integer;
-BEGIN
-  IF compression = 'off' THEN
-    extension := '.log';
-  ELSIF compression = 'gzip' THEN
-    extension := '.log.gz';
-  ELSIF compression = 'lz4' THEN
-    extension := '.log.lz4';
-  ELSIF compression = 'zstd' THEN
-    extension := '.log.zst';
-  ELSE
-    RAISE EXCEPTION 'Unknown compression: %', compression;
-    RETURN false;
-  END IF;
-
-  SELECT count(*) INTO count
-    FROM (SELECT pg_ls_dir(
-      current_setting('data_directory') || '/' ||
-      current_setting('pgaudit.log_directory')) AS name) AS ls
-    WHERE name LIKE 'regression-audit-' || TO_CHAR(NOW(), 'YYYYMMDDHH24') || extension;
-
-  IF count = 1 THEN
-    RETURN true;
-  ELSE
-    RETURN false;
-  END IF;
-END;
-$$ LANGUAGE plpgsql;
--- search for a text pattern in the current postgresql server log file
-CREATE OR REPLACE FUNCTION pgauditlogtofile_regression_server_log_content(pattern text) RETURNS text AS $$
-DECLARE
-  content text;
-BEGIN
-  content := pg_read_file(
-      current_setting('data_directory') || '/' ||
-      current_setting('log_directory') || '/' || 
-      'regression-server-' || TO_CHAR(NOW(), 'YYYYMMDDHH24') || '.log');
-
-  IF strpos(content, pattern) > 0 THEN
-    RETURN 'Found';
-  ELSE
-    RETURN 'Not Found';
-  END IF;
-END;
-$$ LANGUAGE plpgsql;
--- Force a custom filename for the logs
-ALTER SYSTEM SET log_filename = 'regression-server-%Y%m%d%H.log';
-ALTER SYSTEM SET pgaudit.log_filename = 'regression-audit-%Y%m%d%H.log';
-SELECT pg_reload_conf();
- pg_reload_conf 
-----------------
- t
-(1 row)
-
-SELECT pg_rotate_logfile();
- pg_rotate_logfile 
--------------------
- t
-(1 row)
-
-DO $$
-BEGIN
-  -- Write one line
-  RAISE LOG 'Dummy line to ensure we have file';
-END$$;
 SELECT extname, extrelocatable 
 FROM pg_extension 
 WHERE extname LIKE 'pgaudit%'
@@ -131,71 +8,3 @@ ORDER BY extname;
  pgauditlogtofile | t
 (2 rows)
 
--- Clean up
-\i test/sql/common/reset.sql
-ALTER SYSTEM RESET pgaudit.log_directory;
-ALTER SYSTEM RESET pgaudit.log_filename;
-ALTER SYSTEM RESET pgaudit.log_file_mode;
-ALTER SYSTEM RESET pgaudit.log_rotation_age;
-ALTER SYSTEM RESET pgaudit.log_connections;
-ALTER SYSTEM RESET pgaudit.log_disconnections;
-ALTER SYSTEM RESET pgaudit.log_autoclose_minutes;
-ALTER SYSTEM RESET pgaudit.log_format;
-ALTER SYSTEM RESET pgaudit.log_execution_time;
-ALTER SYSTEM RESET pgaudit.log_execution_memory;
-ALTER SYSTEM RESET pgaudit.log_compression;
-ALTER SYSTEM RESET pgaudit.log_compression_level;
-ALTER SYSTEM RESET log_directory;
-ALTER SYSTEM RESET log_filename;
-ALTER SYSTEM RESET log_file_mode;
-ALTER SYSTEM RESET log_connections;
-ALTER SYSTEM RESET log_disconnections;
-SELECT pg_reload_conf();
- pg_reload_conf 
-----------------
- t
-(1 row)
-
-\i test/sql/common/teardown.sql
--- Clean up
-SELECT pg_rotate_logfile();
- pg_rotate_logfile 
--------------------
- t
-(1 row)
-
-DROP FUNCTION IF EXISTS pgauditlogtofile_regression_audit_log_content(text);
-DROP FUNCTION IF EXISTS pgauditlogtofile_regression_server_log_content(text);
-DROP FUNCTION IF EXISTS pgauditlogtofile_regression_audit_file_exists();
--- delete audit file
-COPY (
-    SELECT 
-        current_setting('data_directory') || '/' ||
-        current_setting('pgaudit.log_directory') || '/' || 
-        'regression-audit-' || TO_CHAR(NOW(), 'YYYYMMDDHH24') || '.log'
-) TO PROGRAM 'read path; rm -f "$path"';
-COPY (
-    SELECT 
-        current_setting('data_directory') || '/' ||
-        current_setting('pgaudit.log_directory') || '/' || 
-        'regression-audit-' || TO_CHAR(NOW(), 'YYYYMMDDHH24') || '.log.gz'
-) TO PROGRAM 'read path; rm -f "$path"';
-COPY (
-    SELECT 
-        current_setting('data_directory') || '/' ||
-        current_setting('pgaudit.log_directory') || '/' || 
-        'regression-audit-' || TO_CHAR(NOW(), 'YYYYMMDDHH24') || '.log.lz4'
-) TO PROGRAM 'read path; rm -f "$path"';
-COPY (
-    SELECT 
-        current_setting('data_directory') || '/' ||
-        current_setting('pgaudit.log_directory') || '/' || 
-        'regression-audit-' || TO_CHAR(NOW(), 'YYYYMMDDHH24') || '.log.zst'
-) TO PROGRAM 'read path; rm -f "$path"';
--- delete server log file
-COPY (
-    SELECT 
-        current_setting('data_directory') || '/' ||
-        current_setting('log_directory') || '/' || 
-        'regression-server-' || TO_CHAR(NOW(), 'YYYYMMDDHH24') || '.log'
-) TO PROGRAM 'read path; rm -f "$path"';
--- a/Makefile
+++ b/Makefile
@@ -7,7 +7,7 @@ OBJS = pgauditlogtofile.o logtofile.o lo
 
 DATA = pgauditlogtofile--1.0.sql pgauditlogtofile--1.0--1.2.sql pgauditlogtofile--1.2--1.3.sql pgauditlogtofile--1.3--1.4.sql pgauditlogtofile--1.4--1.5.sql pgauditlogtofile--1.5--1.6.sql pgauditlogtofile--1.6--1.7.sql pgauditlogtofile--1.7--1.8.sql
 
-REGRESS_OPTS = --inputdir=test --outputdir=test --load-extension=pgaudit --load-extension=pgauditlogtofile --user=postgres
+REGRESS_OPTS = --inputdir=test --outputdir=test --load-extension=pgaudit --load-extension=pgauditlogtofile
 REGRESS = extension_exists guc_defaults audit_file_exists audit_file_content audit_file_mode
 #REGRESS = extension_exists guc_defaults audit_file_exists audit_file_content rotation connections execution_data file_mode error_conditions disconnection_rotation_1_setup disconnection_rotation_2_check
 
