2025-10-31 23:19:17.779 CET [1568] LOG:  database system was shut down at 2025-10-31 23:19:14 CET
2025-10-31 23:24:17.727 CET [4912] LOG:  checkpoint starting: time
2025-10-31 23:24:17.802 CET [4912] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.011 s, sync=0.013 s, total=0.076 s; sync files=2, longest=0.007 s, average=0.007 s; distance=0 kB, estimate=0 kB; lsn=7/A0017810, redo lsn=7/A00177B8
2025-10-31 23:24:28.699 CET [4788] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-10-31 23:24:28.699 CET [4788] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-10-31 23:24:29.312 CET [5424] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-10-31 23:24:29.312 CET [5424] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-10-31 23:24:29.508 CET [5424] ERROR:  Oracle client library (oci.dll) not found
2025-10-31 23:24:29.508 CET [5424] DETAIL:  No Oracle client is installed, or your system is configured incorrectly.
2025-10-31 23:24:29.508 CET [5424] HINT:  Verify that the PATH variable includes the Oracle client.
2025-10-31 23:24:29.508 CET [5424] STATEMENT:  -- 1) Rozszerzenie oracle_fdw
	CREATE EXTENSION IF NOT EXISTS oracle_fdw;
	
	-- 2) Połączenie z Oracle
	DROP SERVER IF EXISTS oracle_lttl CASCADE;
	CREATE SERVER oracle_lttl
	  FOREIGN DATA WRAPPER oracle_fdw
	  OPTIONS (
	    dbserver '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.53.2.38)(PORT=1521))(CONNECT_DATA=(SID=lttp)))'
	  );
	
	-- 3) Użytkownik Oracle (tylko SELECT w Oracle)
	CREATE USER MAPPING FOR CURRENT_USER
	  SERVER oracle_lttl
	  OPTIONS (user 'locusltt', password 'locusltt');
	
	-- 4) Schemat lokalny w Postgresie
	CREATE SCHEMA IF NOT EXISTS ltt;
	
	-- 5) Import wszystkich tabel z Oracle (schema = LOCUSLTT)
	IMPORT FOREIGN SCHEMA "LOCUSLTT"
	  FROM SERVER oracle_lttl
	  INTO ltt;
	
	-- 6) Ograniczenie uprawnień – tylko SELECT
	REVOKE ALL PRIVILEGES ON SCHEMA ltt FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA ltt FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA ltt FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA ltt FROM PUBLIC;
	
	GRANT USAGE ON SCHEMA ltt TO PUBLIC;
	GRANT SELECT ON ALL TABLES IN SCHEMA ltt TO PUBLIC;
	
2025-10-31 23:28:10.240 CET [6152] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-10-31 23:28:10.240 CET [6152] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-10-31 23:28:10.357 CET [6152] ERROR:  Oracle client library (oci.dll) not found
2025-10-31 23:28:10.357 CET [6152] DETAIL:  No Oracle client is installed, or your system is configured incorrectly.
2025-10-31 23:28:10.357 CET [6152] HINT:  Verify that the PATH variable includes the Oracle client.
2025-10-31 23:28:10.357 CET [6152] STATEMENT:  SELECT oracle_diag();
2025-10-31 23:29:17.799 CET [4912] LOG:  checkpoint starting: time
2025-10-31 23:29:20.130 CET [4912] LOG:  checkpoint complete: wrote 21 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.195 s, sync=0.087 s, total=2.332 s; sync files=16, longest=0.015 s, average=0.006 s; distance=24 kB, estimate=24 kB; lsn=7/A001D8C8, redo lsn=7/A001D870
2025-10-31 23:31:27.658 CET [6152] FATAL:  terminating connection due to administrator command
2025-10-31 23:31:27.658 CET [5424] FATAL:  terminating connection due to administrator command
2025-10-31 23:31:27.659 CET [4788] FATAL:  terminating connection due to administrator command
2025-10-31 23:31:27.705 CET [4912] LOG:  shutting down
2025-10-31 23:31:27.714 CET [4912] LOG:  checkpoint starting: shutdown immediate
2025-10-31 23:31:27.759 CET [4912] LOG:  checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.054 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=21 kB; lsn=7/A001D978, redo lsn=7/A001D978