From: | Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com> |
---|---|
To: | EGHANA MARREDDY <180050016(at)kluniversity(dot)in> |
Cc: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: URGENT ACTION : Fatal Error with launching pgAdmn |
Date: | 2020-08-28 09:36:35 |
Message-ID: | CANxoLDd3UOcjFQOqtKnLk9EWHHh2Sq_FwXAR7x9mSeJsZA-5zg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(at)kluniversity(dot)in>
wrote:
> Hi Akshay,
>
> Thanks for reaching out!
>
> Here are the log files as advised.
>
> Thanks,
> Meghana
> ------------------------------
> *From:* Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
> *Sent:* 28 August 2020 09:04
> *To:* EGHANA MARREDDY <180050016(at)kluniversity(dot)in>
> *Cc:* pgadmin-support(at)postgresql(dot)org <pgadmin-support(at)postgresql(dot)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(at)kluniversity(dot)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 <http://edbpostgres.com>*
>
> *Mobile: +91 976-788-8246 *
>
--
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Sr. Software Architect*
*EDB Postgres <http://edbpostgres.com>*
*Mobile: +91 976-788-8246*
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2020-08-28 10:03:09 | Re: Having trouble with connecting to database via kerberos |
Previous Message | EGHANA MARREDDY | 2020-08-28 09:02:03 | Re: URGENT ACTION : Fatal Error with launching pgAdmn |