date:20210517

Re: Fatal error starting PgAdmin 4

2021-05-17 Thread Akshay Joshi

Hi Sumedh

Can you please specify the exact version of PostgreSQL 12 that you have
installed? For example 12.x.x
The "pgadmin4.db" file can be found in the "%AppData%\Roaming\pgadmin"
folder.

On Tue, May 18, 2021 at 12:01 PM Balapure, Sumedh <
sumedh.balap...@contractor.tranetechnologies.com> wrote:

> Hi Akshay,
> It's a fresh installation. I am using it for the first time.
>
> I cannot find file *pgadmin4.db*
>
>
> Regards,
>
> Sumedh R. Balapure,
>
> Cell: +91-7770063134
>
> --
> *From:* Akshay Joshi 
> *Sent:* Tuesday, May 18, 2021 9:26 AM
> *To:* Balapure, Sumedh 
> *Cc:* pgadmin-supp...@postgresql.org 
> *Subject:* Re: Fatal error starting PgAdmin 4
>
>
> Alert: This is an external email.
> Hi Sumedh
>
> You can do the following to get rid of the error:
>
>- Take the backup of the '*pgadmin4.db*' file and then delete it.
>- Restart the pgAdmin4
>
> Have you upgraded your existing pgAdmin setup or it's a fresh installation?
>
> On Mon, May 17, 2021 at 9:31 PM Balapure, Sumedh <
> sumedh.balap...@contractor.tranetechnologies.com> wrote:
>
> Hi Team,
> I have installed PostgreSQL 12 and while starting PgAdmin 4 I am getting
> Fatal error. Below is screenshot of error and details. Please help asap.
>
>
>
> pgAdmin Runtime Environment
> 
> Python Path: "C:\Program Files\PostgreSQL\12\pgAdmin 4\python\python.exe"
> Runtime Config File:
> "C:\Users\Sumedh\AppData\Roaming\pgadmin\runtime_config.json"
> pgAdmin Config File: "C:\Program Files\PostgreSQL\12\pgAdmin
> 4\web\config.py"
> Webapp Path: "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgAdmin4.py"
> pgAdmin Command: "C:\Program Files\PostgreSQL\12\pgAdmin
> 4\python\python.exe -s C:\Program Files\PostgreSQL\12\pgAdmin
> 4\web\pgAdmin4.py"
> Environment:
>   - ALLUSERSPROFILE: C:\ProgramData
>   - APPDATA: C:\Users\Sumedh\AppData\Roaming
>   - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_5952_XBAUMQEIPHMCHBHF
>   - 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: SUMEDH-PC
>   - ComSpec: C:\WINDOWS\system32\cmd.exe
>   - C_EM64T_REDIST11: C:\Program Files (x86)\Common Files\Intel\Shared
> Files\cpp\
>   - DriverData: C:\Windows\System32\Drivers\DriverData
>   - FP_NO_HOST_CHECK: NO
>   - HOMEDRIVE: C:
>   - HOMEPATH: \Users\Sumedh
>   - LOCALAPPDATA: C:\Users\Sumedh\AppData\Local
>   - LOGONSERVER: \\SUMEDH-PC
>   - NUMBER_OF_PROCESSORS: 4
>   - OneDrive: C:\Users\Sumedh\OneDrive
>   - OneDriveConsumer: C:\Users\Sumedh\OneDrive
>   - OS: Windows_NT
>   - Path: C:\Program Files (x86)\Common Files\Intel\Shared
> Files\cpp\bin\Intel64;C:\ProgramData\Oracle\Java\javapath;C:\orant\bin;C:\oracle\product\10.2.0\client_1\bin;c:\Program
> Files (x86)\Intel\iCLS Client\;c:\Program Files\Intel\iCLS
> Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program
> Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program
> Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files
> (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files
> (x86)\Intel\Intel(R) Management Engine
> Components\IPT;C:\orant\jdk\bin;C:\WINDOWS\System32\OpenSSH\;C:\Program
> Files\PostgreSQL\12\bin;C:\Users\Sumedh\AppData\Local\Microsoft\WindowsApps
>   - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
>   - PGADMIN_INT_KEY: 9dfe100a-97fe-41d8-b556-865e213bed55
>   - PGADMIN_INT_PORT: 50584
>   - PGADMIN_SERVER_MODE: OFF
>   - PROCESSOR_ARCHITECTURE: AMD64
>   - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 69 Stepping 1,
> GenuineIntel
>   - PROCESSOR_LEVEL: 6
>   - PROCESSOR_REVISION: 4501
>   - ProgramData: C:\ProgramData
>   - ProgramFiles: C:\Program Files
>   - ProgramFiles(x86): C:\Program Files (x86)
>   - ProgramW6432: C:\Program Files
>   - PSModulePath: C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\
>   - PUBLIC: C:\Users\Public
>   - SynaProgDir: Synaptics\SynTP
>   - SystemDrive: C:
>   - SystemRoot: C:\WINDOWS
>   - TEMP: C:\Users\Sumedh\AppData\Local\Temp
>   - TMP: C:\Users\Sumedh\AppData\Local\Temp
>   - USERDOMAIN: Sumedh-PC
>   - USERDOMAIN_ROAMINGPROFILE: Sumedh-PC
>   - USERNAME: Sumedh
>   - USERPROFILE: C:\Users\Sumedh
>   - windir: C:\WINDOWS
>   - windows_tracing_flags: 3
>   - windows_tracing_logfile: C:\BVTBin\Tests\installpackage\csilogfile.log
> 
>
> Traceback (most recent call last):
>   File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgAdmin4.py", line
> 98, in 
> app = create_app()
>   File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgadmin\__init__.py",
> line 347, in create_app
> if not os.path.exists(SQLITE_PATH) or get_version() == -1:
>   File "C:\Program Files

Re: Fatal Error

2021-05-17 Thread Akshay Joshi

Hi Durai

You can do the following to get rid of the error:

   - Take the backup of the '*pgadmin4.db*' file and then delete it.
   - Restart the pgAdmin4

Have you upgraded your existing pgAdmin setup or it's a fresh installation?

On Mon, May 17, 2021 at 9:31 PM Durai Raj  wrote:

> Hi Support Team,
>
> Am facing an error below, when I am trying to open a pgAdmin application
> upon installation. Please find a Traceback and help me to resolve the issue
> asap.
>
> Fatal Error
> ---
>
> The pgAdmin 4 server could not be contacted:
>
> pgAdmin Runtime Environment
> 
> Python Path: "C:\Program Files\pgAdmin 4\v5\python\python.exe"
> Runtime Config File:
> "C:\Users\user\AppData\Roaming\pgadmin\runtime_config.json"
> pgAdmin Config File: "C:\Program Files\pgAdmin 4\v5\web\config.py"
> Webapp Path: "C:\Program Files\pgAdmin 4\v5\web\pgAdmin4.py"
> pgAdmin Command: "C:\Program Files\pgAdmin 4\v5\python\python.exe -s
> C:\Program Files\pgAdmin 4\v5\web\pgAdmin4.py"
> Environment:
>   - ALLUSERSPROFILE: C:\ProgramData
>   - APPDATA: C:\Users\user\AppData\Roaming
>   - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_7784_RLPSVXJGZLPKGNHB
>   - 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: OMLT0009
>   - ComSpec: C:\Windows\system32\cmd.exe
>   - DriverData: C:\Windows\System32\Drivers\DriverData
>   - HOMEDRIVE: C:
>   - HOMEPATH: \Users\user
>   - LOCALAPPDATA: C:\Users\user\AppData\Local
>   - LOGONSERVER: \\OMLT0009
>   - NUMBER_OF_PROCESSORS: 8
>   - OneDrive: C:\Users\user\OneDrive
>   - OneDriveConsumer: C:\Users\user\OneDrive
>   - OS: Windows_NT
>   - Path:
> C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program
> Files\dotnet\;C:\Program Files\Microsoft SQL
> Server\130\Tools\Binn\;C:\Program Files\Microsoft SQL Server\Client
> SDK\ODBC\170\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL
> Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL
> Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL
> Server\150\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL
> Server\150\DTS\Binn\;C:\Program Files\Azure Data
> Studio\bin;C:\Users\user\AppData\Local\Programs\Python\Python39\Scripts\;C:\Users\user\AppData\Local\Programs\Python\Python39\;C:\Users\user\AppData\Local\Microsoft\WindowsApps;C:\Users\user\.dotnet\tools;C:\Program
> Files\Azure Data Studio\bin
>   - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
>   - PGADMIN_INT_KEY: f2718e3f-e66a-47e0-ba1c-4e4020105e4d
>   - PGADMIN_INT_PORT: 56458
>   - 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: C:\Program
> Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules;C:\Program
> Files (x86)\Microsoft SQL Server\150\Tools\PowerShell\Modules\
>   - PUBLIC: C:\Users\Public
>   - SESSIONNAME: Console
>   - SystemDrive: C:
>   - SystemRoot: C:\Windows
>   - TEMP: C:\Users\user\AppData\Local\Temp
>   - TMP: C:\Users\user\AppData\Local\Temp
>   - USERDOMAIN: OMLT0009
>   - USERDOMAIN_ROAMINGPROFILE: OMLT0009
>   - USERNAME: user
>   - USERPROFILE: C:\Users\user
>   - windir: C:\Windows
> 
>
> Traceback (most recent call last):
>   File "C:\Program Files\pgAdmin 4\v5\web\pgAdmin4.py", line 98, in
> 
> app = create_app()
>   File "C:\Program Files\pgAdmin 4\v5\web\pgadmin\__init__.py", line 347,
> in create_app
> if not os.path.exists(SQLITE_PATH) or get_version() == -1:
>   File "C:\Program Files\pgAdmin 4\v5\web\pgadmin\setup\db_version.py",
> line 19, in get_version
> return version.value
> AttributeError: 'NoneType' object has no attribute 'value'
>
>
> Regards,
> Durai Raj G
> Cell: +91 99 44 225432
>
>

-- 
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres *

*Mobile: +91 976-788-8246*

Re: Problemas.

2021-05-17 Thread Akshay Joshi

Hi Hallison

You can do the following to get rid of the error:

   - Take the backup of the '*pgadmin4.db*' file and then delete it.
   - Restart the pgAdmin4

Have you upgraded your existing pgAdmin setup or it's a fresh installation?

On Mon, May 17, 2021 at 9:31 PM Hallison Rangel Silva <
hallisonrang...@hotmail.com> wrote:

> Boa noite!
> Estou com problemas ao tentar rodar o meu PgAdmin 4.
>
>
> pgAdmin Runtime Environment
> 
> Python Path: "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\python.exe"
> Runtime Config File:
> "C:\Users\halli\AppData\Roaming\pgadmin\runtime_config.json"
> pgAdmin Config File: "C:\Program Files\PostgreSQL\13\pgAdmin
> 4\web\config.py"
> Webapp Path: "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgAdmin4.py"
> pgAdmin Command: "C:\Program Files\PostgreSQL\13\pgAdmin
> 4\python\python.exe -s C:\Program Files\PostgreSQL\13\pgAdmin
> 4\web\pgAdmin4.py"
> Environment:
>   - ALLUSERSPROFILE: C:\ProgramData
>   - APPDATA: C:\Users\halli\AppData\Roaming
>   - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_3140_YTOHJJAUTIWKVDBH
>   - CHROME_RESTART: NW.js|O NW.js travou. Reiniciar agora?|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-R10034R
>   - 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\halli
>   - LOCALAPPDATA: C:\Users\halli\AppData\Local
>   - LOGONSERVER: \\DESKTOP-R10034R
>   - NUMBER_OF_PROCESSORS: 8
>   - OneDrive: C:\Users\halli\OneDrive
>   - OS: Windows_NT
>   - Path:
> C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program
> Files\Git\cmd;C:\Users\halli\AppData\Local\Programs\Python\Python39\Scripts\;C:\Users\halli\AppData\Local\Programs\Python\Python39\;%USERPROFILE%\AppData\Local\Microsoft\WindowsApps;C:\Exercism
>   - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
>   - PGADMIN_INT_KEY: ad7ab709-8bda-48ab-8883-63f6306bb4ae
>   - PGADMIN_INT_PORT: 62085
>   - PGADMIN_SERVER_MODE: OFF
>   - PROCESSOR_ARCHITECTURE: AMD64
>   - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 140 Stepping 1,
> GenuineIntel
>   - PROCESSOR_LEVEL: 6
>   - PROCESSOR_REVISION: 8c01
>   - 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
>   - PUBLIC: C:\Users\Public
>   - SESSIONNAME: Console
>   - SystemDrive: C:
>   - SystemRoot: C:\Windows
>   - TEMP: C:\Users\halli\AppData\Local\Temp
>   - TMP: C:\Users\halli\AppData\Local\Temp
>   - USERDOMAIN: DESKTOP-R10034R
>   - USERDOMAIN_ROAMINGPROFILE: DESKTOP-R10034R
>   - USERNAME: halli
>   - USERPROFILE: C:\Users\halli
>   - windir: C:\Windows
> 
>
> Traceback (most recent call last):
>   File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgAdmin4.py", line
> 98, in 
> app = create_app()
>   File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgadmin\__init__.py",
> line 347, in create_app
> if not os.path.exists(SQLITE_PATH) or get_version() == -1:
>   File "C:\Program Files\PostgreSQL\13\pgAdmin
> 4\web\pgadmin\setup\db_version.py", line 19, in get_version
> return version.value
> AttributeError: 'NoneType' object has no attribute 'value'
>
>
> Poderia me ajudar ?
>


-- 
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres *

*Mobile: +91 976-788-8246*

Re: Fatal error starting PgAdmin 4

2021-05-17 Thread Akshay Joshi

Hi Sumedh

You can do the following to get rid of the error:

   - Take the backup of the '*pgadmin4.db*' file and then delete it.
   - Restart the pgAdmin4

Have you upgraded your existing pgAdmin setup or it's a fresh installation?

On Mon, May 17, 2021 at 9:31 PM Balapure, Sumedh <
sumedh.balap...@contractor.tranetechnologies.com> wrote:

> Hi Team,
> I have installed PostgreSQL 12 and while starting PgAdmin 4 I am getting
> Fatal error. Below is screenshot of error and details. Please help asap.
>
>
>
> pgAdmin Runtime Environment
> 
> Python Path: "C:\Program Files\PostgreSQL\12\pgAdmin 4\python\python.exe"
> Runtime Config File:
> "C:\Users\Sumedh\AppData\Roaming\pgadmin\runtime_config.json"
> pgAdmin Config File: "C:\Program Files\PostgreSQL\12\pgAdmin
> 4\web\config.py"
> Webapp Path: "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgAdmin4.py"
> pgAdmin Command: "C:\Program Files\PostgreSQL\12\pgAdmin
> 4\python\python.exe -s C:\Program Files\PostgreSQL\12\pgAdmin
> 4\web\pgAdmin4.py"
> Environment:
>   - ALLUSERSPROFILE: C:\ProgramData
>   - APPDATA: C:\Users\Sumedh\AppData\Roaming
>   - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_5952_XBAUMQEIPHMCHBHF
>   - 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: SUMEDH-PC
>   - ComSpec: C:\WINDOWS\system32\cmd.exe
>   - C_EM64T_REDIST11: C:\Program Files (x86)\Common Files\Intel\Shared
> Files\cpp\
>   - DriverData: C:\Windows\System32\Drivers\DriverData
>   - FP_NO_HOST_CHECK: NO
>   - HOMEDRIVE: C:
>   - HOMEPATH: \Users\Sumedh
>   - LOCALAPPDATA: C:\Users\Sumedh\AppData\Local
>   - LOGONSERVER: \\SUMEDH-PC
>   - NUMBER_OF_PROCESSORS: 4
>   - OneDrive: C:\Users\Sumedh\OneDrive
>   - OneDriveConsumer: C:\Users\Sumedh\OneDrive
>   - OS: Windows_NT
>   - Path: C:\Program Files (x86)\Common Files\Intel\Shared
> Files\cpp\bin\Intel64;C:\ProgramData\Oracle\Java\javapath;C:\orant\bin;C:\oracle\product\10.2.0\client_1\bin;c:\Program
> Files (x86)\Intel\iCLS Client\;c:\Program Files\Intel\iCLS
> Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program
> Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program
> Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files
> (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files
> (x86)\Intel\Intel(R) Management Engine
> Components\IPT;C:\orant\jdk\bin;C:\WINDOWS\System32\OpenSSH\;C:\Program
> Files\PostgreSQL\12\bin;C:\Users\Sumedh\AppData\Local\Microsoft\WindowsApps
>   - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
>   - PGADMIN_INT_KEY: 9dfe100a-97fe-41d8-b556-865e213bed55
>   - PGADMIN_INT_PORT: 50584
>   - PGADMIN_SERVER_MODE: OFF
>   - PROCESSOR_ARCHITECTURE: AMD64
>   - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 69 Stepping 1,
> GenuineIntel
>   - PROCESSOR_LEVEL: 6
>   - PROCESSOR_REVISION: 4501
>   - ProgramData: C:\ProgramData
>   - ProgramFiles: C:\Program Files
>   - ProgramFiles(x86): C:\Program Files (x86)
>   - ProgramW6432: C:\Program Files
>   - PSModulePath: C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\
>   - PUBLIC: C:\Users\Public
>   - SynaProgDir: Synaptics\SynTP
>   - SystemDrive: C:
>   - SystemRoot: C:\WINDOWS
>   - TEMP: C:\Users\Sumedh\AppData\Local\Temp
>   - TMP: C:\Users\Sumedh\AppData\Local\Temp
>   - USERDOMAIN: Sumedh-PC
>   - USERDOMAIN_ROAMINGPROFILE: Sumedh-PC
>   - USERNAME: Sumedh
>   - USERPROFILE: C:\Users\Sumedh
>   - windir: C:\WINDOWS
>   - windows_tracing_flags: 3
>   - windows_tracing_logfile: C:\BVTBin\Tests\installpackage\csilogfile.log
> 
>
> Traceback (most recent call last):
>   File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgAdmin4.py", line
> 98, in 
> app = create_app()
>   File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgadmin\__init__.py",
> line 347, in create_app
> if not os.path.exists(SQLITE_PATH) or get_version() == -1:
>   File "C:\Program Files\PostgreSQL\12\pgAdmin
> 4\web\pgadmin\setup\db_version.py", line 19, in get_version
> return version.value
> AttributeError: 'NoneType' object has no attribute 'value'
>
>
>
>
> Regards,
>
> Sumedh R. Balapure,
>
> Cell: +91-7770063134
>


-- 
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres *

*Mobile: +91 976-788-8246*

Re: PgAdmin Fatal Error

2021-05-17 Thread Akshay Joshi

Hi

Follow the steps suggested by Khushboo in her previous email.

On Mon, May 17, 2021 at 9:31 PM shubhj_45  wrote:

> i am getting the same error, i tried going to the local and roaming folder
> and deleting it, that didn't work.
> i have installed different versions also, no one works, this same error
> comes up every time.
> please help me figure it out.
>
>
>
> --
> Sent from:
> https://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html
>
>
>

-- 
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres *

*Mobile: +91 976-788-8246*

Re: The pgAdmin 4 server could not be contacted:

2021-05-17 Thread CHALLAHEMANTH

I am trying to install Postgre SQl on windows 10 but after installation, I am
getting a window named

The pgAdmin 4 server could not be contacted:

The details inside the window are

pgAdmin Runtime Environment

Python Path: "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\python.exe"
Runtime Config File:
"C:\Users\hp\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Program Files\PostgreSQL\13\pgAdmin
4\web\config.py"
Webapp Path: "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\python.exe
-s C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgAdmin4.py"
Environment: 
  - ALLUSERSPROFILE: C:\ProgramData
  - APPDATA: C:\Users\hp\AppData\Roaming
  - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_5852_YIMDLVLENKCBOENT
  - 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-TK8J1MC
  - 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\hp
  - LOCALAPPDATA: C:\Users\hp\AppData\Local
  - LOGONSERVER: \\DESKTOP-TK8J1MC
  - NUMBER_OF_PROCESSORS: 4
  - OneDrive: C:\Users\hp\OneDrive
  - OS: Windows_NT
  - Path:
C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\OpenSSH\;C:\Program
Files\Java\jdk\bin;C:\Program
Files\Java\jre\bin;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program
Files\Microsoft SQL
Server\130\Tools\Binn\;G:\MATLAB\R2021a\bin;C:\Users\hp\AppData\Local\Programs\Python\Python38\Scripts\;C:\Users\hp\AppData\Local\Programs\Python\Python38\;C:\Python27;C:\Python27\Scripts;C:\Program
Files\JetBrains\PyCharm Community Edition
2020.2\bin;;C:\Users\hp\AppData\Local\Microsoft\WindowsApps;;C:\Users\hp\AppData\Local\Programs\Microsoft
VS Code\bin
  - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  - PGADMIN_INT_KEY: 4f99a0f6-11d8-4b90-8d64-96f9d2eda282
  - PGADMIN_INT_PORT: 51575
  - PGADMIN_SERVER_MODE: OFF
  - PROCESSOR_ARCHITECTURE: AMD64
  - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 78 Stepping 3, GenuineIntel
  - PROCESSOR_LEVEL: 6
  - PROCESSOR_REVISION: 4e03
  - 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
  - PUBLIC: C:\Users\Public
  - PyCharm Community Edition: C:\Program Files\JetBrains\PyCharm Community
Edition 2020.2\bin;
  - SESSIONNAME: Console
  - SystemDrive: C:
  - SystemRoot: C:\WINDOWS
  - TEMP: C:\Users\hp\AppData\Local\Temp
  - TMP: C:\Users\hp\AppData\Local\Temp
  - USERDOMAIN: DESKTOP-TK8J1MC
  - USERDOMAIN_ROAMINGPROFILE: DESKTOP-TK8J1MC
  - USERNAME: hp
  - USERPROFILE: C:\Users\hp
  - VBOX_MSI_INSTALL_PATH: C:\Program Files\Oracle\VirtualBox\
  - windir: C:\WINDOWS


Traceback (most recent call last):
  File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgAdmin4.py", line 98,
in 
app = create_app()
  File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgadmin\__init__.py",
line 347, in create_app
if not os.path.exists(SQLITE_PATH) or get_version() == -1:
  File "C:\Program Files\PostgreSQL\13\pgAdmin
4\web\pgadmin\setup\db_version.py", line 19, in get_version
return version.value
AttributeError: 'NoneType' object has no attribute 'value'




I am unable to even understand whats the thing that I can do. I am hoping
for help from you. Please look into this.




--
Sent from: 
https://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

Fatal Error

2021-05-17 Thread Durai Raj

Hi Support Team,

Am facing an error below, when I am trying to open a pgAdmin application
upon installation. Please find a Traceback and help me to resolve the issue
asap.

Fatal Error
---

The pgAdmin 4 server could not be contacted:

pgAdmin Runtime Environment

Python Path: "C:\Program Files\pgAdmin 4\v5\python\python.exe"
Runtime Config File:
"C:\Users\user\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Program Files\pgAdmin 4\v5\web\config.py"
Webapp Path: "C:\Program Files\pgAdmin 4\v5\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\pgAdmin 4\v5\python\python.exe -s
C:\Program Files\pgAdmin 4\v5\web\pgAdmin4.py"
Environment:
  - ALLUSERSPROFILE: C:\ProgramData
  - APPDATA: C:\Users\user\AppData\Roaming
  - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_7784_RLPSVXJGZLPKGNHB
  - 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: OMLT0009
  - ComSpec: C:\Windows\system32\cmd.exe
  - DriverData: C:\Windows\System32\Drivers\DriverData
  - HOMEDRIVE: C:
  - HOMEPATH: \Users\user
  - LOCALAPPDATA: C:\Users\user\AppData\Local
  - LOGONSERVER: \\OMLT0009
  - NUMBER_OF_PROCESSORS: 8
  - OneDrive: C:\Users\user\OneDrive
  - OneDriveConsumer: C:\Users\user\OneDrive
  - OS: Windows_NT
  - Path:
C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program
Files\dotnet\;C:\Program Files\Microsoft SQL
Server\130\Tools\Binn\;C:\Program Files\Microsoft SQL Server\Client
SDK\ODBC\170\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL
Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL
Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL
Server\150\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL
Server\150\DTS\Binn\;C:\Program Files\Azure Data
Studio\bin;C:\Users\user\AppData\Local\Programs\Python\Python39\Scripts\;C:\Users\user\AppData\Local\Programs\Python\Python39\;C:\Users\user\AppData\Local\Microsoft\WindowsApps;C:\Users\user\.dotnet\tools;C:\Program
Files\Azure Data Studio\bin
  - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  - PGADMIN_INT_KEY: f2718e3f-e66a-47e0-ba1c-4e4020105e4d
  - PGADMIN_INT_PORT: 56458
  - 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: C:\Program
Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules;C:\Program
Files (x86)\Microsoft SQL Server\150\Tools\PowerShell\Modules\
  - PUBLIC: C:\Users\Public
  - SESSIONNAME: Console
  - SystemDrive: C:
  - SystemRoot: C:\Windows
  - TEMP: C:\Users\user\AppData\Local\Temp
  - TMP: C:\Users\user\AppData\Local\Temp
  - USERDOMAIN: OMLT0009
  - USERDOMAIN_ROAMINGPROFILE: OMLT0009
  - USERNAME: user
  - USERPROFILE: C:\Users\user
  - windir: C:\Windows


Traceback (most recent call last):
  File "C:\Program Files\pgAdmin 4\v5\web\pgAdmin4.py", line 98, in 
app = create_app()
  File "C:\Program Files\pgAdmin 4\v5\web\pgadmin\__init__.py", line 347,
in create_app
if not os.path.exists(SQLITE_PATH) or get_version() == -1:
  File "C:\Program Files\pgAdmin 4\v5\web\pgadmin\setup\db_version.py",
line 19, in get_version
return version.value
AttributeError: 'NoneType' object has no attribute 'value'


Regards,
Durai Raj G
Cell: +91 99 44 225432

Problemas.

2021-05-17 Thread Hallison Rangel Silva

Boa noite!
Estou com problemas ao tentar rodar o meu PgAdmin 4.


pgAdmin Runtime Environment

Python Path: "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\python.exe"
Runtime Config File: 
"C:\Users\halli\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\config.py"
Webapp Path: "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\python.exe -s 
C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgAdmin4.py"
Environment:
  - ALLUSERSPROFILE: C:\ProgramData
  - APPDATA: C:\Users\halli\AppData\Roaming
  - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_3140_YTOHJJAUTIWKVDBH
  - CHROME_RESTART: NW.js|O NW.js travou. Reiniciar agora?|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-R10034R
  - 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\halli
  - LOCALAPPDATA: C:\Users\halli\AppData\Local
  - LOGONSERVER: \\DESKTOP-R10034R
  - NUMBER_OF_PROCESSORS: 8
  - OneDrive: C:\Users\halli\OneDrive
  - OS: Windows_NT
  - Path: 
C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program
 
Files\Git\cmd;C:\Users\halli\AppData\Local\Programs\Python\Python39\Scripts\;C:\Users\halli\AppData\Local\Programs\Python\Python39\;%USERPROFILE%\AppData\Local\Microsoft\WindowsApps;C:\Exercism
  - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  - PGADMIN_INT_KEY: ad7ab709-8bda-48ab-8883-63f6306bb4ae
  - PGADMIN_INT_PORT: 62085
  - PGADMIN_SERVER_MODE: OFF
  - PROCESSOR_ARCHITECTURE: AMD64
  - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 140 Stepping 1, GenuineIntel
  - PROCESSOR_LEVEL: 6
  - PROCESSOR_REVISION: 8c01
  - 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
  - PUBLIC: C:\Users\Public
  - SESSIONNAME: Console
  - SystemDrive: C:
  - SystemRoot: C:\Windows
  - TEMP: C:\Users\halli\AppData\Local\Temp
  - TMP: C:\Users\halli\AppData\Local\Temp
  - USERDOMAIN: DESKTOP-R10034R
  - USERDOMAIN_ROAMINGPROFILE: DESKTOP-R10034R
  - USERNAME: halli
  - USERPROFILE: C:\Users\halli
  - windir: C:\Windows


Traceback (most recent call last):
  File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgAdmin4.py", line 98, in 

app = create_app()
  File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgadmin\__init__.py", line 
347, in create_app
if not os.path.exists(SQLITE_PATH) or get_version() == -1:
  File "C:\Program Files\PostgreSQL\13\pgAdmin 
4\web\pgadmin\setup\db_version.py", line 19, in get_version
return version.value
AttributeError: 'NoneType' object has no attribute 'value'


Poderia me ajudar ?

Fatal error starting PgAdmin 4

2021-05-17 Thread Balapure, Sumedh

Hi Team,
I have installed PostgreSQL 12 and while starting PgAdmin 4 I am getting Fatal 
error. Below is screenshot of error and details. Please help asap.

[cid:60394b54-9a08-4058-878d-ec513b51e332]

pgAdmin Runtime Environment

Python Path: "C:\Program Files\PostgreSQL\12\pgAdmin 4\python\python.exe"
Runtime Config File: 
"C:\Users\Sumedh\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\config.py"
Webapp Path: "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\PostgreSQL\12\pgAdmin 4\python\python.exe -s 
C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgAdmin4.py"
Environment:
  - ALLUSERSPROFILE: C:\ProgramData
  - APPDATA: C:\Users\Sumedh\AppData\Roaming
  - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_5952_XBAUMQEIPHMCHBHF
  - 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: SUMEDH-PC
  - ComSpec: C:\WINDOWS\system32\cmd.exe
  - C_EM64T_REDIST11: C:\Program Files (x86)\Common Files\Intel\Shared 
Files\cpp\
  - DriverData: C:\Windows\System32\Drivers\DriverData
  - FP_NO_HOST_CHECK: NO
  - HOMEDRIVE: C:
  - HOMEPATH: \Users\Sumedh
  - LOCALAPPDATA: C:\Users\Sumedh\AppData\Local
  - LOGONSERVER: \\SUMEDH-PC
  - NUMBER_OF_PROCESSORS: 4
  - OneDrive: C:\Users\Sumedh\OneDrive
  - OneDriveConsumer: C:\Users\Sumedh\OneDrive
  - OS: Windows_NT
  - Path: C:\Program Files (x86)\Common Files\Intel\Shared 
Files\cpp\bin\Intel64;C:\ProgramData\Oracle\Java\javapath;C:\orant\bin;C:\oracle\product\10.2.0\client_1\bin;c:\Program
 Files (x86)\Intel\iCLS Client\;c:\Program Files\Intel\iCLS 
Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program
 Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program 
Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files 
(x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files 
(x86)\Intel\Intel(R) Management Engine 
Components\IPT;C:\orant\jdk\bin;C:\WINDOWS\System32\OpenSSH\;C:\Program 
Files\PostgreSQL\12\bin;C:\Users\Sumedh\AppData\Local\Microsoft\WindowsApps
  - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  - PGADMIN_INT_KEY: 9dfe100a-97fe-41d8-b556-865e213bed55
  - PGADMIN_INT_PORT: 50584
  - PGADMIN_SERVER_MODE: OFF
  - PROCESSOR_ARCHITECTURE: AMD64
  - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 69 Stepping 1, GenuineIntel
  - PROCESSOR_LEVEL: 6
  - PROCESSOR_REVISION: 4501
  - ProgramData: C:\ProgramData
  - ProgramFiles: C:\Program Files
  - ProgramFiles(x86): C:\Program Files (x86)
  - ProgramW6432: C:\Program Files
  - PSModulePath: C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\
  - PUBLIC: C:\Users\Public
  - SynaProgDir: Synaptics\SynTP
  - SystemDrive: C:
  - SystemRoot: C:\WINDOWS
  - TEMP: C:\Users\Sumedh\AppData\Local\Temp
  - TMP: C:\Users\Sumedh\AppData\Local\Temp
  - USERDOMAIN: Sumedh-PC
  - USERDOMAIN_ROAMINGPROFILE: Sumedh-PC
  - USERNAME: Sumedh
  - USERPROFILE: C:\Users\Sumedh
  - windir: C:\WINDOWS
  - windows_tracing_flags: 3
  - windows_tracing_logfile: C:\BVTBin\Tests\installpackage\csilogfile.log


Traceback (most recent call last):
  File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgAdmin4.py", line 98, in 

app = create_app()
  File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgadmin\__init__.py", line 
347, in create_app
if not os.path.exists(SQLITE_PATH) or get_version() == -1:
  File "C:\Program Files\PostgreSQL\12\pgAdmin 
4\web\pgadmin\setup\db_version.py", line 19, in get_version
return version.value
AttributeError: 'NoneType' object has no attribute 'value'





Regards,

Sumedh R. Balapure,

Cell: +91-7770063134

Re: PgAdmin Fatal Error

2021-05-17 Thread shubhj_45

i am getting the same error, i tried going to the local and roaming folder
and deleting it, that didn't work.
i have installed different versions also, no one works, this same error
comes up every time.
please help me figure it out.



--
Sent from: 
https://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

Re: sequence current value

2021-05-17 Thread Dave Page

On Fri, May 14, 2021 at 5:32 PM Michael Shapiro 
wrote:

> I tried this. I created a sequence, and ran last_value, then nextval,
> repeatedly. last_value always returned 20 until nextval returned 21, then
> last_value returned 40 and kept returning 40 until nextval returned 41, etc.
>

Weird things can happen with sequences (well, they look weird sometimes -
actually they're the behaviour people want in real world applications), due
to caching and different sessions. What does "select * from "
show? And how were you running those queries, both in terms of pgAdmin vs.
psql etc. and transaction control?

>
>
> On Fri, May 14, 2021 at 9:39 AM Dave Page  wrote:
>
>>
>>
>> On Fri, May 14, 2021 at 3:33 PM Michael Shapiro 
>> wrote:
>>
>>> How does PgAdmin get the current value of a sequence when showing the
>>> sequence properties?
>>>
>>
>> SELECT last_value FROM ;
>>
>> (essentially. It gets a few other things as well)
>>
>> --
>> Dave Page
>> Blog: https://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EDB: https://www.enterprisedb.com
>>
>>

-- 
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: https://www.enterprisedb.com

Re: Fatal error starting PgAdmin 4

Re: Fatal Error

Re: Problemas.

Re: Fatal error starting PgAdmin 4

Re: PgAdmin Fatal Error

Re: The pgAdmin 4 server could not be contacted:

Fatal Error

Problemas.

Fatal error starting PgAdmin 4

Re: PgAdmin Fatal Error

Re: sequence current value

11 matches

Site Navigation

Mail list logo

Footer information