2025-10-31 23:31:44.608 CET [3280] LOG: database system was shut down at 2025-10-31 23:31:27 CET 2025-10-31 23:32:06.393 CET [6992] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-10-31 23:32:06.393 CET [6992] 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:32:06.891 CET [3900] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-10-31 23:32:06.891 CET [3900] 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:32:07.036 CET [3900] ERROR: Oracle client library (oci.dll) not found 2025-10-31 23:32:07.036 CET [3900] DETAIL: No Oracle client is installed, or your system is configured incorrectly. 2025-10-31 23:32:07.036 CET [3900] HINT: Verify that the PATH variable includes the Oracle client. 2025-10-31 23:32:07.036 CET [3900] STATEMENT: CREATE EXTENSION IF NOT EXISTS oracle_fdw; SELECT oracle_diag(); 2025-10-31 23:36:44.609 CET [5716] LOG: checkpoint starting: time 2025-10-31 23:36:44.680 CET [5716] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.009 s, sync=0.013 s, total=0.071 s; sync files=2, longest=0.007 s, average=0.007 s; distance=0 kB, estimate=0 kB; lsn=7/A001DA80, redo lsn=7/A001DA28 2025-10-31 23:38:36.507 CET [404] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-10-31 23:38:36.507 CET [404] 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:40:34.237 CET [3900] ERROR: syntax error at or near "\" at character 1 2025-10-31 23:40:34.237 CET [3900] STATEMENT: \dt ltt.* 2025-10-31 23:41:44.673 CET [5716] LOG: checkpoint starting: time 2025-10-31 23:42:08.680 CET [5716] LOG: checkpoint complete: wrote 218 buffers (1.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=23.724 s, sync=0.237 s, total=24.008 s; sync files=41, longest=0.013 s, average=0.006 s; distance=1951 kB, estimate=1951 kB; lsn=7/A0205A38, redo lsn=7/A02059A8 2025-10-31 23:42:25.665 CET [3044] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-10-31 23:42:25.665 CET [3044] 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:42:36.954 CET [5544] WARNING: PID 4412 is not a PostgreSQL backend process 2025-10-31 23:42:39.975 CET [4032] WARNING: PID 4524 is not a PostgreSQL backend process 2025-10-31 23:42:43.332 CET [5388] WARNING: PID 5712 is not a PostgreSQL backend process 2025-10-31 23:42:43.642 CET [6640] WARNING: PID 5728 is not a PostgreSQL backend process 2025-10-31 23:42:43.971 CET [6868] WARNING: PID 5812 is not a PostgreSQL backend process 2025-10-31 23:42:44.301 CET [2992] WARNING: PID 4372 is not a PostgreSQL backend process 2025-10-31 23:42:44.613 CET [2964] WARNING: PID 6616 is not a PostgreSQL backend process 2025-10-31 23:42:44.942 CET [352] WARNING: PID 4472 is not a PostgreSQL backend process 2025-10-31 23:42:45.287 CET [4820] WARNING: PID 840 is not a PostgreSQL backend process 2025-10-31 23:42:48.294 CET [2784] WARNING: PID 6440 is not a PostgreSQL backend process 2025-10-31 23:42:48.911 CET [5192] WARNING: PID 3124 is not a PostgreSQL backend process 2025-10-31 23:42:49.425 CET [5608] WARNING: PID 6804 is not a PostgreSQL backend process 2025-10-31 23:42:50.143 CET [5028] WARNING: PID 2020 is not a PostgreSQL backend process 2025-10-31 23:42:50.974 CET [4044] WARNING: PID 5424 is not a PostgreSQL backend process 2025-10-31 23:42:51.488 CET [1264] WARNING: PID 3284 is not a PostgreSQL backend process 2025-10-31 23:42:51.982 CET [6524] WARNING: PID 3580 is not a PostgreSQL backend process 2025-10-31 23:42:52.541 CET [6840] WARNING: PID 4992 is not a PostgreSQL backend process 2025-10-31 23:42:53.004 CET [1484] WARNING: PID 3576 is not a PostgreSQL backend process 2025-10-31 23:44:13.186 CET [4472] ERROR: relation "ui_translations" does not exist at character 32 2025-10-31 23:44:13.186 CET [4472] STATEMENT: SELECT key, pl_pl AS text FROM ui_translations 2025-10-31 23:44:20.171 CET [4472] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-10-31 23:46:44.683 CET [5716] LOG: checkpoint starting: time 2025-10-31 23:46:45.320 CET [5716] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.547 s, sync=0.039 s, total=0.637 s; sync files=6, longest=0.011 s, average=0.007 s; distance=9 kB, estimate=1757 kB; lsn=7/A0207FA8, redo lsn=7/A0207F50 2025-10-31 23:48:57.857 CET [1056] ERROR: relation "app_users" does not exist at character 25 2025-10-31 23:48:57.857 CET [1056] STATEMENT: SELECT permissions FROM app_users WHERE account_sonex = $1 2025-10-31 23:49:24.564 CET [4192] ERROR: relation "app_users" does not exist at character 25 2025-10-31 23:49:24.564 CET [4192] STATEMENT: SELECT permissions FROM app_users WHERE account_sonex = $1 2025-10-31 23:51:42.633 CET [4776] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-10-31 23:51:42.633 CET [4776] 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:53:03.852 CET [6044] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-10-31 23:53:03.853 CET [7088] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-10-31 23:53:03.855 CET [4000] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-10-31 23:53:03.855 CET [3056] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-10-31 23:53:03.862 CET [6352] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-10-31 23:57:44.433 CET [4776] ERROR: invalid option "fetch_size" 2025-10-31 23:57:44.433 CET [4776] HINT: Valid options in this context are: dbserver, isolation_level, nchar, set_timezone 2025-10-31 23:57:44.433 CET [4776] STATEMENT: -- 1) Serwer FDW do LocusWMS DROP SERVER IF EXISTS locuswms CASCADE; CREATE SERVER locuswms FOREIGN DATA WRAPPER oracle_fdw OPTIONS ( dbserver '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.53.2.30)(PORT=1521))(CONNECT_DATA=(SID=wmsp)))' ); -- 2) Mapowanie użytkownika Oracle CREATE USER MAPPING FOR CURRENT_USER SERVER locuswms OPTIONS (user 'sje', password 'same10'); -- 3) Lokalny schemat na tabele z WMS CREATE SCHEMA IF NOT EXISTS wms; -- 4) Import wszystkich tabel z Oracle (schema = LOCUS) IMPORT FOREIGN SCHEMA "LOCUS" FROM SERVER locuswms INTO wms; -- 5) Tylko SELECT REVOKE ALL PRIVILEGES ON SCHEMA wms FROM PUBLIC; REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA wms FROM PUBLIC; REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA wms FROM PUBLIC; REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA wms FROM PUBLIC; GRANT USAGE ON SCHEMA wms TO PUBLIC; GRANT SELECT ON ALL TABLES IN SCHEMA wms TO PUBLIC; -- (opcjonalnie) tuningi ALTER SERVER locuswms OPTIONS (ADD fetch_size '10000'); ALTER SERVER locuswms OPTIONS (ADD connect_timeout '10');