Hello, I encountered a fatal error while I tried to enable import logging in PGAdmin 4. I would be very grateful if you can give me any advice or suggestions. Background: I installed Postgres 14 and PGAdmin 4 on Windows Server 2019. How to create the problem: I followed the instructions on Postgres 4 FAQ to enable the import logging. This instruction - https://www.pgadmin.org/faq/#8 The instruction said to create a python file and placed it under \PostgreSQL\14\pgAdmin 4\web. I copied the syntax on FAQ page and created config_local.py (where the logging level is set to “DEBUG”), and I placed the file in the above mentioned folder. But afterwards, when I try to launch PGAdmin 4, it is failing to launch with a fatal error. And it looks like Postgres also can’t start up at all. What have I tried to troubleshoot and fix the problem: As a test, I changed the logging level in config_local.py to NOSET, it is also causing the error. The only way to resolve the error is to delete all the syntaxes in config_local.py, or delete config_local.py from the folder altogether. I tried and searched the archive in the general community, but I couldn’t find a matching the record -
https://www.postgresql.org/list/pgsql-general/ The error message: This is the error I am seeing: The full stack for the fatal error is: pgAdmin Runtime Environment -------------------------------------------------------- Python Path: "C:\Program Files\PostgreSQL\14\pgAdmin 4\python\python.exe" Runtime Config File: "C:\Users\Administrator\AppData\Roaming\pgadmin\runtime_config.json" pgAdmin Config File: "C:\Program Files\PostgreSQL\14\pgAdmin 4\web\config.py" Webapp Path: "C:\Program Files\PostgreSQL\14\pgAdmin 4\web\pgAdmin4.py" pgAdmin Command: "C:\Program Files\PostgreSQL\14\pgAdmin 4\python\python.exe -s C:\Program Files\PostgreSQL\14\pgAdmin 4\web\pgAdmin4.py" Environment: - ALLUSERSPROFILE: C:\ProgramData - APPDATA: C:\Users\Administrator\AppData\Roaming - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_2108_XAEXTHSRZQXHPLHB - CHROME_RESTART: NW.js|Whoa! NW.js has crashed. Relaunch now?|LEFT_TO_RIGHT - CLASSPATH: .;C:\PROGRA~1\IBM\SQLLIB\java\db2java.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc4.jar;C:\PROGRA~1\IBM\SQLLIB\java\sqlj4.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\PROGRA~1\IBM\SQLLIB\bin;C:\PROGRA~1\IBM\SQLLIB\java\common.jar - CommonProgramFiles: C:\Program Files\Common Files - CommonProgramFiles(x86): C:\Program Files (x86)\Common Files - CommonProgramW6432: C:\Program Files\Common Files - COMPUTERNAME: EIA250 - ComSpec: C:\Windows\system32\cmd.exe - DB2INSTANCE: DB2 - FPS_BROWSER_APP_PROFILE_STRING: Internet Explorer - FPS_BROWSER_USER_PROFILE_STRING: Default - GEOTRANS_DATA: C:\Program Files (x86)\Common Files\i2 Shared\Geotrans\Data\ - HOMEDRIVE: C: - HOMEPATH: \Users\Administrator - INCLUDE: C:\PROGRA~1\IBM\SQLLIB\INCLUDE;C:\PROGRA~1\IBM\SQLLIB\LIB - LIB: ;C:\PROGRA~1\IBM\SQLLIB\LIB - LOCALAPPDATA: C:\Users\Administrator\AppData\Local - LOGONSERVER: \\I2DC - NUMBER_OF_PROCESSORS: 4 - OS: Windows_NT - Path: C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\ibm\gsk8\lib64;C:\Program Files (x86)\ibm\gsk8\lib;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IBM\SQLLIB\SAMPLES\REPL;C:\Program
Files (x86)\Common Files\i2 Shared\Geotrans\;C:\Program Files (x86)\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files\Microsoft SQL Server\150\DTS\Binn\;C:\Program
Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Program Files\Azure Data Studio\bin;C:\Users\Administrator\AppData\Local\Microsoft\WindowsApps; - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC - PGADMIN_INT_KEY: 639145fb-c750-43c0-9b9f-f698a800886c - PGADMIN_INT_PORT: 52456 - PGADMIN_SERVER_MODE: OFF - PROCESSOR_ARCHITECTURE: AMD64 - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 142 Stepping 10, GenuineIntel - PROCESSOR_LEVEL: 6 - PROCESSOR_REVISION: 8e0a - ProgramData: C:\ProgramData - ProgramFiles: C:\Program Files - ProgramFiles(x86): C:\Program Files (x86) - ProgramW6432: C:\Program Files - PSModulePath: %ProgramFiles%\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules;C:\Program Files (x86)\Microsoft SQL Server\150\Tools\PowerShell\Modules\ - PUBLIC: C:\Users\Public - SystemDrive: C: - SystemRoot: C:\Windows - TEMP: C:\Users\ADMINI~1\AppData\Local\Temp - TMP: C:\Users\ADMINI~1\AppData\Local\Temp - USERDNSDOMAIN: DL.LAN - USERDOMAIN: DL - USERDOMAIN_ROAMINGPROFILE: DL - USERNAME: Administrator - USERPROFILE: C:\Users\Administrator - windir: C:\Windows -------------------------------------------------------- Total spawn time to start the pgAdmin4 server: 0.006 Sec Traceback (most recent call last): File "C:\Program Files\PostgreSQL\14\pgAdmin 4\web\pgAdmin4.py", line 93, in <module> app = create_app() File "C:\Program Files\PostgreSQL\14\pgAdmin 4\web\pgadmin\__init__.py", line 270, in create_app create_app_data_directory(config) File "C:\Program Files\PostgreSQL\14\pgAdmin 4\web\pgadmin\setup\data_directory.py", line 65, in create_app_data_directory _create_directory_if_not_exists(os.path.dirname(config.LOG_FILE)) File "C:\Program Files\PostgreSQL\14\pgAdmin 4\web\pgadmin\setup\data_directory.py", line 20, in _create_directory_if_not_exists os.mkdir(_path) FileNotFoundError: [WinError 3] The system cannot find the path specified: '/desired/path/to' May I ask you to help me? Any suggestion or advice would be greatly appreciated. Thank you in advance.
|