Обсуждение: Cannot export connections / servers - pgAdmin4 4.24 (windows)
Hello - I'm attempting to "dump servers" according to documentation at https://www.pgadmin.org/docs/pgadmin4/4.24/import_export_servers.html... I tried searching your archives for dump-serversbut got "no hits". Seems unlikely, maybe something screwy with the search but there is no help anywhere thatI can find. It fails with an error " ModuleNotFoundError: No module named 'encodings'". Any ideas what I am doing wrong? I did try settingthe env variables PYTHONHOME and PYTHONPATH to several different things in the "\Program Files\pgAdmin 4\v4" treebut not sure what it wants, if that even matters. I do see the servers in the Web app. This is the pgAdmin4 v 4.24 Windows 64-bit version on Windows 10 added via the installer. I am not sure if I am running in"server or desktop mode" but probably desktop? C:\Users\redacted> "\Program Files\pgAdmin 4\v4\runtime\python.exe" "\Program Files\pgAdmin 4\v4\web\setup.py" --dump-serverspgservers.json Python path configuration: PYTHONHOME = (not set) PYTHONPATH = (not set) program name = '\Program Files\pgAdmin 4\v4\runtime\python.exe' isolated = 0 environment = 1 user site = 1 import site = 1 sys._base_executable = 'C:\\Program Files\\pgAdmin 4\\v4\\runtime\\python.exe' sys.base_prefix = '' sys.base_exec_prefix = '' sys.executable = 'C:\\Program Files\\pgAdmin 4\\v4\\runtime\\python.exe' sys.prefix = '' sys.exec_prefix = '' sys.path = [ 'C:\\Program Files\\pgAdmin 4\\v4\\runtime\\python38.zip', '.\\DLLs', '.\\lib', 'C:\\Program Files\\pgAdmin 4\\v4\\runtime', ] Fatal Python error: init_fs_encoding: failed to get the Python codec of the filesystem encoding Python runtime state: core initialized ModuleNotFoundError: No module named 'encodings' Current thread 0x00002640 (most recent call first): <no Python frame>
Hi Mark,
On Tue, Aug 11, 2020 at 8:18 PM Rengert, Mark <mark.rengert@redcom.com> wrote:
Hello -
I'm attempting to "dump servers" according to documentation at https://www.pgadmin.org/docs/pgadmin4/4.24/import_export_servers.html... I tried searching your archives for dump-servers but got "no hits". Seems unlikely, maybe something screwy with the search but there is no help anywhere that I can find.
It fails with an error " ModuleNotFoundError: No module named 'encodings'". Any ideas what I am doing wrong? I did try setting the env variables PYTHONHOME and PYTHONPATH to several different things in the "\Program Files\pgAdmin 4\v4" tree but not sure what it wants, if that even matters. I do see the servers in the Web app.
This is the pgAdmin4 v 4.24 Windows 64-bit version on Windows 10 added via the installer. I am not sure if I am running in "server or desktop mode" but probably desktop?
C:\Users\redacted> "\Program Files\pgAdmin 4\v4\runtime\python.exe" "\Program Files\pgAdmin 4\v4\web\setup.py" --dump-servers pgservers.json
Please try with - "C:\Program Files\pgAdmin 4\v4\venv\Scripts\python.exe" "C:\Program Files\pgAdmin 4\v4\web\setup.py" --dump-servers pgservers.json
Python path configuration:
PYTHONHOME = (not set)
PYTHONPATH = (not set)
program name = '\Program Files\pgAdmin 4\v4\runtime\python.exe'
isolated = 0
environment = 1
user site = 1
import site = 1
sys._base_executable = 'C:\\Program Files\\pgAdmin 4\\v4\\runtime\\python.exe'
sys.base_prefix = ''
sys.base_exec_prefix = ''
sys.executable = 'C:\\Program Files\\pgAdmin 4\\v4\\runtime\\python.exe'
sys.prefix = ''
sys.exec_prefix = ''
sys.path = [
'C:\\Program Files\\pgAdmin 4\\v4\\runtime\\python38.zip',
'.\\DLLs',
'.\\lib',
'C:\\Program Files\\pgAdmin 4\\v4\\runtime',
]
Fatal Python error: init_fs_encoding: failed to get the Python codec of the filesystem encoding
Python runtime state: core initialized
ModuleNotFoundError: No module named 'encodings'
Current thread 0x00002640 (most recent call first):
<no Python frame>
Thanks,
Aditya Toshniwal
pgAdmin hacker | Sr. Software Engineer | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"