Обсуждение: Cannot export connections / servers - pgAdmin4 4.24 (windows)

Поиск
Список
Период
Сортировка

Cannot export connections / servers - pgAdmin4 4.24 (windows)

От
"Rengert, Mark"
Дата:
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>






Re: Cannot export connections / servers - pgAdmin4 4.24 (windows)

От
Aditya Toshniwal
Дата:
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"