Re: URGENT ACTION : Fatal Error with launching pgAdmn

Поиск
Список
Период
Сортировка
От Akshay Joshi
Тема Re: URGENT ACTION : Fatal Error with launching pgAdmn
Дата
Msg-id CANxoLDd3UOcjFQOqtKnLk9EWHHh2Sq_FwXAR7x9mSeJsZA-5zg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: URGENT ACTION : Fatal Error with launching pgAdmn  (EGHANA MARREDDY <180050016@kluniversity.in>)
Список 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@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 по дате отправления:

Предыдущее
От: EGHANA MARREDDY
Дата:
Сообщение: Re: URGENT ACTION : Fatal Error with launching pgAdmn
Следующее
От: Dave Page
Дата:
Сообщение: Re: Having trouble with connecting to database via kerberos