RE: PgAdmin 4 v.30 on WIN10

[Igor Neyman]

From: Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
Sent: Wednesday, June 06, 2018 1:15 PM
To: Igor Neyman 
Cc: pgadmin-support@lists.postgresql.org
Subject: Re: PgAdmin 4 v.30 on WIN10

Hi,

Can you try renaming existing pgAdmin4.db to pgAdmin4.db_OLD which is located 
at C:\Users\\AppData\Roaming\pgAdmin\
And try to start pgAdmin4 again.


--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
[https://drive.google.com/a/enterprisedb.com/uc?id=0B6jGeB3BfKRMV0t4MEp0YnZCTTA=download]

On Wed, Jun 6, 2018 at 9:48 PM, Igor Neyman 
mailto:iney...@perceptron.com>> wrote:
Hello,

After installing PgAdmin 4 v.30 on Windows 10 when Trying to start it, I’m 
getting “Fatal Error” message box:

“The application server could not be contacted”.

Here is the what’s in PgAdmin log file:

Traceback (most recent call last):
  File "D:/Postgres/10/v3/web/pgAdmin4.py", line 70, in 
app = create_app()
  File "D:\Postgres\10\v3\web\pgadmin\__init__.py", line 315, in create_app
db_upgrade(app)
  File "D:\Postgres\10\v3\web\pgadmin\setup\db_upgrade.py", line 25, in 
db_upgrade
flask_migrate.upgrade(migration_folder)
  File "D:/Postgres/10/v3/venv/Lib/site-packages\flask_migrate\__init__.py", 
line 259, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\command.py", line 254, 
in upgrade
script.run_env()
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 
427, in run_env
util.load_python_file(self.dir, 'env.py')
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\util\pyfiles.py", line 
81, in load_python_file
module = load_module_py(module_id, path)
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\util\compat.py", line 
141, in load_module_py
mod = imp.load_source(module_id, path, fp)
  File "D:\Postgres\10\v3\web\pgadmin\setup\..\..\migrations\env.py", line 94, 
in 
run_migrations_online()
  File "D:\Postgres\10\v3\web\pgadmin\setup\..\..\migrations\env.py", line 87, 
in run_migrations_online
context.run_migrations()
  File "", line 8, in run_migrations
  File 
"D:/Postgres/10/v3/venv/Lib/site-packages\alembic\runtime\environment.py", line 
836, in run_migrations
self.get_context().run_migrations(**kw)
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\runtime\migration.py", 
line 321, in run_migrations
for step in self._migrations_fn(heads, self):
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\command.py", line 243, 
in upgrade
return script._upgrade_revs(revision, rev)
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 
340, in _upgrade_revs
for script in reversed(list(revs))
  File "D:/Postgres/10/v3/venv\lib\contextlib.py", line 35, in __exit__
self.gen.throw(type, value, traceback)
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 
176, in _catch_revision_errors
compat.raise_from_cause(util.CommandError(err.args[0]))
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\util\compat.py", line 
205, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 
143, in _catch_revision_errors
yield
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 
336, in _upgrade_revs
revs = list(revs)
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\revision.py", 
line 698, in _iterate_revisions
select_for_downgrade and requested_lowers
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\revision.py", 
line 694, in 
rev.revision for rev
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\revision.py", 
line 631, in _iterate_related_revisions
", ".join(r.revision for r in overlaps)
alembic.util.exc.CommandError: Requested revision fdc58d9bd449 overlaps with 
other requested revisions 02b9dccdcfcb
Exception KeyError: KeyError(8304,) in  ignored

Regards,
Igor Neyman

Thank you, that fixed it.
Regards,
Igor Neyman

PgAdmin 4 v.30 on WIN10

[Igor Neyman]

Hello,

After installing PgAdmin 4 v.30 on Windows 10 when Trying to start it, I'm 
getting "Fatal Error" message box:

"The application server could not be contacted".

Here is the what's in PgAdmin log file:

Traceback (most recent call last):
  File "D:/Postgres/10/v3/web/pgAdmin4.py", line 70, in 
app = create_app()
  File "D:\Postgres\10\v3\web\pgadmin\__init__.py", line 315, in create_app
db_upgrade(app)
  File "D:\Postgres\10\v3\web\pgadmin\setup\db_upgrade.py", line 25, in 
db_upgrade
flask_migrate.upgrade(migration_folder)
  File "D:/Postgres/10/v3/venv/Lib/site-packages\flask_migrate\__init__.py", 
line 259, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\command.py", line 254, 
in upgrade
script.run_env()
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 
427, in run_env
util.load_python_file(self.dir, 'env.py')
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\util\pyfiles.py", line 
81, in load_python_file
module = load_module_py(module_id, path)
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\util\compat.py", line 
141, in load_module_py
mod = imp.load_source(module_id, path, fp)
  File "D:\Postgres\10\v3\web\pgadmin\setup\..\..\migrations\env.py", line 94, 
in 
run_migrations_online()
  File "D:\Postgres\10\v3\web\pgadmin\setup\..\..\migrations\env.py", line 87, 
in run_migrations_online
context.run_migrations()
  File "", line 8, in run_migrations
  File 
"D:/Postgres/10/v3/venv/Lib/site-packages\alembic\runtime\environment.py", line 
836, in run_migrations
self.get_context().run_migrations(**kw)
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\runtime\migration.py", 
line 321, in run_migrations
for step in self._migrations_fn(heads, self):
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\command.py", line 243, 
in upgrade
return script._upgrade_revs(revision, rev)
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 
340, in _upgrade_revs
for script in reversed(list(revs))
  File "D:/Postgres/10/v3/venv\lib\contextlib.py", line 35, in __exit__
self.gen.throw(type, value, traceback)
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 
176, in _catch_revision_errors
compat.raise_from_cause(util.CommandError(err.args[0]))
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\util\compat.py", line 
205, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 
143, in _catch_revision_errors
yield
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 
336, in _upgrade_revs
revs = list(revs)
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\revision.py", 
line 698, in _iterate_revisions
select_for_downgrade and requested_lowers
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\revision.py", 
line 694, in 
rev.revision for rev
  File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\revision.py", 
line 631, in _iterate_related_revisions
", ".join(r.revision for r in overlaps)
alembic.util.exc.CommandError: Requested revision fdc58d9bd449 overlaps with 
other requested revisions 02b9dccdcfcb
Exception KeyError: KeyError(8304,) in  ignored

Regards,
Igor Neyman

Re: Is there any way to get pgadmin4-v3 to work on a non-gnome linux platform

[Cherio]

It has no issues running in xfce. I did a standard python wheel set up on 2
xfce workstations. It runs in Chrome well. As often happens it had issues
converting configuration from the previous version but has no issues
specific to graphic environment.

On Wed, Jun 6, 2018 at 6:15 AM Raymond O'Donnell  wrote:

> On 06/06/18 06:08, Darren Duncan wrote:
> > On 2018-06-05 11:05 AM, Mike Martin wrote:
> >> Hi
> >> I have hit a brick wall trying to run pgadmin4-v3 on my Linux box
> >> running xfce. It insists on a gnome-specific chrome/firefox extension,
> >> which then insists on a running copy of gnome shell
> >
> > That seems strange to me.  I thought PgAdmin4-v3 ran in stock web
> > browsers without needing any browser extensions. -- Darren Duncan
>
> I run it in Firefox 60 on KDE (Debian 8) without any extensions.
>
> Ray.
>
> --
> Raymond O'Donnell :: Galway :: Ireland
> r...@iol.ie
>
>

Re: Is there any way to get pgadmin4-v3 to work on a non-gnome linux platform

[Raymond O'Donnell]

On 06/06/18 06:08, Darren Duncan wrote:

On 2018-06-05 11:05 AM, Mike Martin wrote:

Hi
I have hit a brick wall trying to run pgadmin4-v3 on my Linux box 
running xfce. It insists on a gnome-specific chrome/firefox extension, 
which then insists on a running copy of gnome shell


That seems strange to me.  I thought PgAdmin4-v3 ran in stock web 
browsers without needing any browser extensions. -- Darren Duncan


I run it in Firefox 60 on KDE (Debian 8) without any extensions.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie