RE: Re: Re: upgrade from version 4.28 to 8.8

[Bonafé , Giacomo]

Hi,

i dont think so.
I did try to start pgadmin4 8.8 after reboot or after killing any pgadmin 
processes, the log is always the same

pgAdmin Runtime Environment

Python Path: "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 
4\python\python.exe"
Runtime Config File: 
"C:\Users\Giacomo\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 
4\web\config.py"
Webapp Path: "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 
4\python\python.exe -s C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 
4\web\pgAdmin4.py"
Environment:
  - ALLUSERSPROFILE: C:\ProgramData
  - APPDATA: C:\Users\Giacomo\AppData\Roaming
  - CHROME_CRASHPAD_PIPE_NAME: 
\\.\pipe\crashpad_7124_BMZRIYHKKPKHZLQK
  - CHROME_RESTART: NW.js|Whoa! NW.js has crashed. Relaunch now?|LEFT_TO_RIGHT
  - CommonProgramFiles: C:\Program Files\Common Files
  - CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
  - CommonProgramW6432: C:\Program Files\Common Files
  - COMPUTERNAME: DESKTOP-V5R1KTH
  - ComSpec: C:\WINDOWS\system32\cmd.exe
  - DriverData: C:\Windows\System32\Drivers\DriverData
  - FPS_BROWSER_APP_PROFILE_STRING: Internet Explorer
  - FPS_BROWSER_USER_PROFILE_STRING: Default
  - HOMEDRIVE: C:
  - HOMEPATH: \Users\Giacomo
  - LOCALAPPDATA: C:\Users\Giacomo\AppData\Local
  - LOGONSERVER: \\DESKTOP-V5R1KTH
  - NUMBER_OF_PROCESSORS: 16
  - OneDrive: C:\Users\Giacomo\OneDrive
  - OS: Windows_NT
  - Path: C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 
4\runtime;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Users\Giacomo\AppData\Local\Microsoft\WindowsApps;
  - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  - PGADMIN_INT_KEY: fcb10fa9-7b3c-46a6-ae06-4818e72a1f9e
  - PGADMIN_INT_PORT: 49859
  - PGADMIN_SERVER_MODE: OFF
  - PROCESSOR_ARCHITECTURE: AMD64
  - PROCESSOR_IDENTIFIER: AMD64 Family 23 Model 8 Stepping 2, AuthenticAMD
  - PROCESSOR_LEVEL: 23
  - PROCESSOR_REVISION: 0802
  - ProgramData: C:\ProgramData
  - ProgramFiles: C:\Program Files
  - ProgramFiles(x86): C:\Program Files (x86)
  - ProgramW6432: C:\Program Files
  - PSModulePath: C:\Program 
Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules;C:\Program
 Files\Intel\Wired Networking\
  - PUBLIC: C:\Users\Public
  - SESSIONNAME: Console
  - SystemDrive: C:
  - SystemRoot: C:\WINDOWS
  - TEMP: C:\Users\Giacomo\AppData\Local\Temp
  - TMP: C:\Users\Giacomo\AppData\Local\Temp
  - USERDOMAIN: DESKTOP-V5R1KTH
  - USERDOMAIN_ROAMINGPROFILE: DESKTOP-V5R1KTH
  - USERNAME: Giacomo
  - USERPROFILE: C:\Users\Giacomo
  - VBOX_MSI_INSTALL_PATH: C:\Program Files\Oracle\VirtualBox\
  - windir: C:\WINDOWS


Total spawn time to start the pgAdmin4 server: 0.007 Sec
2024-07-08 10:25:23,426: ERROR  pgadmin:Database migration failed

2024-07-08 10:25:23,436: ERROR  pgadmin:Traceback (most recent call 
last):
  File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 
4\web\pgadmin\__init__.py", line 386, in upgrade_db
db_upgrade(app)
  File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 
4\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
flask_migrate.upgrade(migration_folder)
  File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 
4\python\Lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped
f(*args, **kwargs)
  File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 
4\python\Lib\site-packages\flask_migrate\__init__.py", line 200, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
  File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 
4\python\Lib\site-packages\alembic\command.py", line 403, in upgrade
script.run_env()
  File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 
4\python\Lib\site-packages\alembic\script\base.py", line 583, in run_env
util.load_python_file(self.dir, "env.py")
  File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 
4\python\Lib\site-packages\alembic\util\pyfiles.py", line 95, in 
load_python_file
module = load_module_py(module_id, path)
 ^^^
  File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 
4\python\Lib\site-packages\alembic\util\pyfiles.py", line 113, in load_module_py
spec.loader.exec_module(module)  # type: ignore
^^^
  File "", line 995, in exec_module
  File "", line 488, in _call_with_frames_removed
  File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 
4\web\pgadmin\setup\..\..\migrations\env.py", line 95, in 
run_migrations_online()
  File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 
4\web\pgadmin\setup\..\..\migrations\env.py", line 87, in run_migrations_online
context.run_migrations()
  File "", line 8, in

Re: Re: Re: upgrade from version 4.28 to 8.8

[Aditya Toshniwal]

Hi Giacomo,

Then probably you need to remove the
C:\\Users\\Giacomo\\AppData\\Roaming\\pgAdmin
directory. Server configurations will be lost unfortunately.

On Mon, Jul 8, 2024 at 2:01 PM Bonafé, Giacomo 
wrote:

> Hi,
>
>
>
> i dont think so.
>
> I did try to start pgadmin4 8.8 after reboot or after killing any pgadmin
> processes, the log is always the same
>
>
>
> pgAdmin Runtime Environment
>
> 
>
> Python Path: "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\python.exe"
>
> Runtime Config File:
> "C:\Users\Giacomo\AppData\Roaming\pgadmin\runtime_config.json"
>
> pgAdmin Config File: "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\config.py"
>
> Webapp Path: "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\pgAdmin4.py"
>
> pgAdmin Command: "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\python.exe -s C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\pgAdmin4.py"
>
> Environment:
>
>   - ALLUSERSPROFILE: C:\ProgramData
>
>   - APPDATA: C:\Users\Giacomo\AppData\Roaming
>
>   - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_7124_BMZRIYHKKPKHZLQK
>
>   - CHROME_RESTART: NW.js|Whoa! NW.js has crashed. Relaunch
> now?|LEFT_TO_RIGHT
>
>   - CommonProgramFiles: C:\Program Files\Common Files
>
>   - CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
>
>   - CommonProgramW6432: C:\Program Files\Common Files
>
>   - COMPUTERNAME: DESKTOP-V5R1KTH
>
>   - ComSpec: C:\WINDOWS\system32\cmd.exe
>
>   - DriverData: C:\Windows\System32\Drivers\DriverData
>
>   - FPS_BROWSER_APP_PROFILE_STRING: Internet Explorer
>
>   - FPS_BROWSER_USER_PROFILE_STRING: Default
>
>   - HOMEDRIVE: C:
>
>   - HOMEPATH: \Users\Giacomo
>
>   - LOCALAPPDATA: C:\Users\Giacomo\AppData\Local
>
>   - LOGONSERVER: \\DESKTOP-V5R1KTH
>
>   - NUMBER_OF_PROCESSORS: 16
>
>   - OneDrive: C:\Users\Giacomo\OneDrive
>
>   - OS: Windows_NT
>
>   - Path: C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\runtime;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Users\Giacomo\AppData\Local\Microsoft\WindowsApps;
>
>   - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
>
>   - PGADMIN_INT_KEY: fcb10fa9-7b3c-46a6-ae06-4818e72a1f9e
>
>   - PGADMIN_INT_PORT: 49859
>
>   - PGADMIN_SERVER_MODE: OFF
>
>   - PROCESSOR_ARCHITECTURE: AMD64
>
>   - PROCESSOR_IDENTIFIER: AMD64 Family 23 Model 8 Stepping 2, AuthenticAMD
>
>   - PROCESSOR_LEVEL: 23
>
>   - PROCESSOR_REVISION: 0802
>
>   - ProgramData: C:\ProgramData
>
>   - ProgramFiles: C:\Program Files
>
>   - ProgramFiles(x86): C:\Program Files (x86)
>
>   - ProgramW6432: C:\Program Files
>
>   - PSModulePath: C:\Program
> Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules;C:\Program
> Files\Intel\Wired Networking\
>
>   - PUBLIC: C:\Users\Public
>
>   - SESSIONNAME: Console
>
>   - SystemDrive: C:
>
>   - SystemRoot: C:\WINDOWS
>
>   - TEMP: C:\Users\Giacomo\AppData\Local\Temp
>
>   - TMP: C:\Users\Giacomo\AppData\Local\Temp
>
>   - USERDOMAIN: DESKTOP-V5R1KTH
>
>   - USERDOMAIN_ROAMINGPROFILE: DESKTOP-V5R1KTH
>
>   - USERNAME: Giacomo
>
>   - USERPROFILE: C:\Users\Giacomo
>
>   - VBOX_MSI_INSTALL_PATH: C:\Program Files\Oracle\VirtualBox\
>
>   - windir: C:\WINDOWS
>
> 
>
>
>
> Total spawn time to start the pgAdmin4 server: 0.007 Sec
>
> 2024-07-08 10:25:23,426: ERROR pgadmin: Database migration failed
>
>
>
> 2024-07-08 10:25:23,436: ERROR pgadmin: Traceback (most recent call last):
>
>   File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\pgadmin\__init__.py", line 386, in upgrade_db
>
> db_upgrade(app)
>
>   File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
>
> flask_migrate.upgrade(migration_folder)
>
>   File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped
>
> f(*args, **kwargs)
>
>   File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\flask_migrate\__init__.py", line 200, in upgrade
>
> command.upgrade(config, revision, sql=sql, tag=tag)
>
>   File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\alembic\command.py", line 403, in upgrade
>
> script.run_env()
>
>   File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\alembic\script\base.py", line 583, in run_env
>
> util.load_python_file(self.dir, "env.py")
>
>   File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\alembic\util\pyfiles.py", line 95, in
> load_python_file
>
> module = load_module_py(module_id, path)
>
>  ^^^
>
>   File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\alembic\util\pyfiles.py", l

Disable PGadmin tools (backup / restore )

[MELIANI Fayçal]

Hello,

We are using pgAdmin in a Kubernetes environment and are looking to
restrict users from performing backup or restore operations from the
pgAdmin console. Performing a backup operation, for instance, from within
the pod could potentially crash the pod in case of an OOMKill or saturate
the PVC, thereby causing pgAdmin to stop.

We would like to inquire if there is a way to customize the pgAdmin Docker
image to enforce restrictions on these specific operations from the
console. Could you provide guidance or recommendations on how to configure
pgAdmin to meet these requirements ?

Thank you in advance for your assistance and advice.

Best regards,

Re: Disable PGadmin tools (backup / restore )

[Aditya Toshniwal]

Hi MELIANI,

Currently, you cannot do that. What you can do is remove the binary paths
location from preferences so that backup won't start.

On Mon, Jul 8, 2024 at 7:14 PM MELIANI Fayçal  wrote:

> Hello,
>
> We are using pgAdmin in a Kubernetes environment and are looking to
> restrict users from performing backup or restore operations from the
> pgAdmin console. Performing a backup operation, for instance, from within
> the pod could potentially crash the pod in case of an OOMKill or saturate
> the PVC, thereby causing pgAdmin to stop.
>
> We would like to inquire if there is a way to customize the pgAdmin Docker
> image to enforce restrictions on these specific operations from the
> console. Could you provide guidance or recommendations on how to configure
> pgAdmin to meet these requirements ?
>
> Thank you in advance for your assistance and advice.
>
> Best regards,
>


-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*

"Don't Complain about Heat, Plant a TREE"

Re: Issue with Viewing Created Table in pgAdmin

[Yogesh Mahajan]

Hi,

You need to write a query and click on the 'Execute query' button to get
output.
Please refer to pgadmin documentation from here
. You can also refer
to youtube videos which cover most of the modules of pgadmin from here
.


Thanks,
Yogesh Mahajan
EnterpriseDB


On Mon, Jul 8, 2024 at 8:25 PM Reuben Fraser 
wrote:

> Subject: Further Assistance Needed with Query Tool in pgAdmin
>
> Hi Yogesh,
>
> Thank you for your previous response. I have attempted to follow your
> instructions, but I am encountering persistent issues. Specifically, when I
> try to open the Query Tool, a brief appearance of a revolving circle icon
> is followed by a flash, and then the screen closes with the message "! No
> data output. Execute a query to get output."
>
> [image: 2024-07-09-Query_Error.png]
>
> I want to emphasize that I've been following guidance from ChatGPT
> throughout this process, ensuring that I'm taking the correct steps. The
> query tool is displaying unmistakable signs of something being seriously at
> fault.
>
> Additionally, I was unable to locate the Logging option as directed by
> ChatGPT:
> *Enable Query Tool Logging*
>
>- Open pgAdmin.
>- Go to File > Preferences > Logging.
>- Set the Log Level to Debug.
>- Try opening the Query Tool again and check the logs for any error
>messages.
>
> I wasn't able to find Logging in the File Preferences.
>
> Could you please provide detailed guidance on resolving this matter?
>
> It seems there may be a direct connection between the issue of no columns
> displaying when I view my database versus 29 columns visible when you
> access it, and the Query Tool malfunctioning. If this is indeed the case,
> then we are at least getting closer to identifying exactly what is wrong.
>
> I'm considering reinstalling pgAdmin, but since my initial setup was
> correct, I'm uncertain if this will resolve the issue.
>
> Your assistance in resolving this issue would be greatly appreciated.
>
> Best regards,
>
> Reuben
>
>>