Thread: pgadmin4/EnterpriseDB 9.0.4
Hello list,
I have problems using pgAdmin 4 in combination with EnterpriseDB 9.0.4. Connection works, but when clicking on any sub-items ("Schemas", "Catalogs") no details appear.
logfile excerpt:
-----------------------------------------------------------------------------------------------
2019-10-23 10:44:12,823: ERROR flask.app: schemas/ppas/#90004#/sql/properties.sql
Traceback (most recent call last):
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/app.py", line 1813, in full_dispatch_request
rv = self.dispatch_request()
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/app.py", line 1799, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/views.py", line 88, in view
return self.dispatch_request(*args, **kwargs)
File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/utils.py", line 310, in dispatch_request
return method(*args, **kwargs)
File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/server_groups/servers/databases/schemas/__init__.py", line 150, in wrap
return f(*args, **kwargs)
File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/server_groups/servers/databases/schemas/__init__.py", line 385, in list
show_sysobj=self.blueprint.show_system_objects
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/templating.py", line 134, in render_template
return _render(ctx.app.jinja_env.get_or_select_template(template_name_or_list),
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/jinja2/environment.py", line 869, in get_or_select_template
return self.get_template(template_name_or_list, parent, globals)
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/jinja2/environment.py", line 830, in get_template
return self._load_template(name, self.make_globals(globals))
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/jinja2/environment.py", line 804, in _load_template
template = self.loader.load(self, name, globals)
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/jinja2/loaders.py", line 113, in load
source, filename, uptodate = self.get_source(environment, name)
File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/utils/versioned_template_loader.py", line 39, in get_source
raise TemplateNotFound(template)
jinja2.exceptions.TemplateNotFound: schemas/ppas/#90004#/sql/properties.sql
-----------------------------------------------------------------------------------------------
Is pgAdmin designed to support EnterpriseDB 9.0.4?
I have problems using pgAdmin 4 in combination with EnterpriseDB 9.0.4. Connection works, but when clicking on any sub-items ("Schemas", "Catalogs") no details appear.
logfile excerpt:
-----------------------------------------------------------------------------------------------
2019-10-23 10:44:12,823: ERROR flask.app: schemas/ppas/#90004#/sql/properties.sql
Traceback (most recent call last):
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/app.py", line 1813, in full_dispatch_request
rv = self.dispatch_request()
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/app.py", line 1799, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/views.py", line 88, in view
return self.dispatch_request(*args, **kwargs)
File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/utils.py", line 310, in dispatch_request
return method(*args, **kwargs)
File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/server_groups/servers/databases/schemas/__init__.py", line 150, in wrap
return f(*args, **kwargs)
File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/server_groups/servers/databases/schemas/__init__.py", line 385, in list
show_sysobj=self.blueprint.show_system_objects
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/templating.py", line 134, in render_template
return _render(ctx.app.jinja_env.get_or_select_template(template_name_or_list),
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/jinja2/environment.py", line 869, in get_or_select_template
return self.get_template(template_name_or_list, parent, globals)
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/jinja2/environment.py", line 830, in get_template
return self._load_template(name, self.make_globals(globals))
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/jinja2/environment.py", line 804, in _load_template
template = self.loader.load(self, name, globals)
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/jinja2/loaders.py", line 113, in load
source, filename, uptodate = self.get_source(environment, name)
File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/utils/versioned_template_loader.py", line 39, in get_source
raise TemplateNotFound(template)
jinja2.exceptions.TemplateNotFound: schemas/ppas/#90004#/sql/properties.sql
-----------------------------------------------------------------------------------------------
Is pgAdmin designed to support EnterpriseDB 9.0.4?
Thanks for any help,
Peer
Nope this is not supported. We only support pgadmin4 on PG/EPAS 9.4 till version 12.
On Wed, Oct 23, 2019 at 1:49 PM Peer Sandtner <peer.bestellungen@me.com> wrote:
Hello list,
I have problems using pgAdmin 4 in combination with EnterpriseDB 9.0.4. Connection works, but when clicking on any sub-items ("Schemas", "Catalogs") no details appear.
logfile excerpt:
-----------------------------------------------------------------------------------------------
2019-10-23 10:44:12,823: ERROR flask.app: schemas/ppas/#90004#/sql/properties.sql
Traceback (most recent call last):
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/app.py", line 1813, in full_dispatch_request
rv = self.dispatch_request()
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/app.py", line 1799, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/views.py", line 88, in view
return self.dispatch_request(*args, **kwargs)
File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/utils.py", line 310, in dispatch_request
return method(*args, **kwargs)
File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/server_groups/servers/databases/schemas/__init__.py", line 150, in wrap
return f(*args, **kwargs)
File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/server_groups/servers/databases/schemas/__init__.py", line 385, in list
show_sysobj=self.blueprint.show_system_objects
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/templating.py", line 134, in render_template
return _render(ctx.app.jinja_env.get_or_select_template(template_name_or_list),
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/jinja2/environment.py", line 869, in get_or_select_template
return self.get_template(template_name_or_list, parent, globals)
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/jinja2/environment.py", line 830, in get_template
return self._load_template(name, self.make_globals(globals))
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/jinja2/environment.py", line 804, in _load_template
template = self.loader.load(self, name, globals)
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/site-packages/jinja2/loaders.py", line 113, in load
source, filename, uptodate = self.get_source(environment, name)
File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/utils/versioned_template_loader.py", line 39, in get_source
raise TemplateNotFound(template)
jinja2.exceptions.TemplateNotFound: schemas/ppas/#90004#/sql/properties.sql
-----------------------------------------------------------------------------------------------
Is pgAdmin designed to support EnterpriseDB 9.0.4?Thanks for any help,Peer
--
Fahar Abbas
![](https://drive.google.com/a/enterprisedb.com/uc?id=0B3A76rNrVTJVNkdxY3hCTU1KUEk&export=download)
QMG
EnterpriseDB Corporation
Phone Office: +92-51-835-8874Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.enterprisedb.com