Postgres Pro
Downloads
Home   >   mailing lists

Re: URGENT ACTION : Fatal Error with launching pgAdmn - Mailing list pgadmin-support

From Akshay Joshi
Subject Re: URGENT ACTION : Fatal Error with launching pgAdmn
Date
Msg-id CANxoLDd3UOcjFQOqtKnLk9EWHHh2Sq_FwXAR7x9mSeJsZA-5zg@mail.gmail.com
Whole thread Raw
In response to Re: URGENT ACTION : Fatal Error with launching pgAdmn  (EGHANA MARREDDY <180050016@kluniversity.in>)
List pgadmin-support
Tree view
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]

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,
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
 
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 issue

Thanks,
Meghana


--
Thanks & Regards
Akshay Joshi
pgAdmin Hacker | Sr. Software Architect
EDB Postgres
Mobile: +91 976-788-8246



--
Thanks & Regards
Akshay Joshi
pgAdmin Hacker | Sr. Software Architect
EDB Postgres
Mobile: +91 976-788-8246

pgadmin-support by date:

Previous
From: EGHANA MARREDDY
Date:
Subject: Re: URGENT ACTION : Fatal Error with launching pgAdmn
Next
From: Dave Page
Date:
Subject: Re: Having trouble with connecting to database via kerberos