Thread: URGENT ACTION : Fatal Error with launching pgAdmn
Hi Team,
I am facing issues with launching the pgAdmn 4 from Postgresql 12. I am using a windows 64bit laptop with Windows 10 OS.
I have tried launching as administrator also tried installing lower versions of the postgresql to verify if that works, with no luck so far.
Please can you help me what would be the potential troubleshooting that I can perform to resolve the issue
Thanks,
Meghana
Attachment
Hi EGHANA
Can you please provide the pgAdmin4 log file available at "C:\Users\<user_name>\AppData\Local" folder.
On Thu, Aug 27, 2020 at 7:54 PM EGHANA MARREDDY <180050016@kluniversity.in> wrote:
Hi Team,I am facing issues with launching the pgAdmn 4 from Postgresql 12. I am using a windows 64bit laptop with Windows 10 OS.I have tried launching as administrator also tried installing lower versions of the postgresql to verify if that works, with no luck so far.Please can you help me what would be the potential troubleshooting that I can perform to resolve the issueThanks,Meghana
--
Thanks & Regards
Akshay Joshi
pgAdmin Hacker | Sr. Software Architect
EDB PostgresMobile: +91 976-788-8246
Hi Akshay,
Thanks for reaching out!
Here are the log files as advised.
Thanks,
Meghana
From: Akshay Joshi <akshay.joshi@enterprisedb.com>
Sent: 28 August 2020 09:04
To: EGHANA MARREDDY <180050016@kluniversity.in>
Cc: pgadmin-support@postgresql.org <pgadmin-support@postgresql.org>
Subject: Re: URGENT ACTION : Fatal Error with launching pgAdmn
Sent: 28 August 2020 09:04
To: EGHANA MARREDDY <180050016@kluniversity.in>
Cc: pgadmin-support@postgresql.org <pgadmin-support@postgresql.org>
Subject: Re: URGENT ACTION : Fatal Error with launching pgAdmn
Hi EGHANA
Can you please provide the pgAdmin4 log file available at "C:\Users\<user_name>\AppData\Local" folder.
On Thu, Aug 27, 2020 at 7:54 PM EGHANA MARREDDY <180050016@kluniversity.in> wrote:
Hi Team,I am facing issues with launching the pgAdmn 4 from Postgresql 12. I am using a windows 64bit laptop with Windows 10 OS.I have tried launching as administrator also tried installing lower versions of the postgresql to verify if that works, with no luck so far.Please can you help me what would be the potential troubleshooting that I can perform to resolve the issueThanks,Meghana
--
Thanks & Regards
Akshay Joshi
pgAdmin Hacker | Sr. Software Architect
EDB PostgresMobile: +91 976-788-8246
Attachment
Hi EGHANA
After checking the logs it is showing below error:
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) duplicate column name: connect_timeout
[SQL: ALTER TABLE server ADD COLUMN connect_timeout INTEGER DEFAULT 0]
[SQL: ALTER TABLE server ADD COLUMN connect_timeout INTEGER DEFAULT 0]
It seems that problem with the database file when you did upgrade/downgrade the PostgreSQL.
I would suggest performing the following steps:
- Take the backup of the 'pgadmin4.db' file and delete it. You may find the file at "C:\Users\<user_name>\.pgadmin" folder.
- Restart the pgAdmin4
On Fri, Aug 28, 2020 at 2:32 PM EGHANA MARREDDY <180050016@kluniversity.in> wrote:
Hi Akshay,Thanks for reaching out!Here are the log files as advised.Thanks,MeghanaFrom: Akshay Joshi <akshay.joshi@enterprisedb.com>
Sent: 28 August 2020 09:04
To: EGHANA MARREDDY <180050016@kluniversity.in>
Cc: pgadmin-support@postgresql.org <pgadmin-support@postgresql.org>
Subject: Re: URGENT ACTION : Fatal Error with launching pgAdmnHi EGHANACan you please provide the pgAdmin4 log file available at "C:\Users\<user_name>\AppData\Local" folder.On Thu, Aug 27, 2020 at 7:54 PM EGHANA MARREDDY <180050016@kluniversity.in> wrote:Hi Team,I am facing issues with launching the pgAdmn 4 from Postgresql 12. I am using a windows 64bit laptop with Windows 10 OS.I have tried launching as administrator also tried installing lower versions of the postgresql to verify if that works, with no luck so far.Please can you help me what would be the potential troubleshooting that I can perform to resolve the issueThanks,Meghana
--Thanks & RegardsAkshay JoshipgAdmin Hacker | Sr. Software ArchitectEDB PostgresMobile: +91 976-788-8246
--
Thanks & Regards
Akshay Joshi
pgAdmin Hacker | Sr. Software Architect
EDB PostgresMobile: +91 976-788-8246