Re: Access issues with pgAdmin 4
This issue has been fixed, Can you please upgrade the PostgreSQL installer from the EDB website? On Tue, Aug 1, 2023 at 12:02 PM wrote: > Hi, > > > > I’m having issues with accessing pgAdmin 4 and I need it for my university > coursework. > > When I open the software, the screen just gets stuck on a blank screen and > wouldn’t load. > > Please advise a fix for this issue. > > > > > > Kind regards > > From Yizhou > -- Fahar Abbas pgAdmin4 team EnterpriseDB Corporation Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Facing Issue While Opening PgAdmin 4
Kindly follow the steps below and share the results: --- 1. Remove complete PostgreSQL 15 from the Control panel 2. Remove pgadmin4 from the Control panel 3. Remove the pgadmin4.db file 4. Download and install pgadmin4 from https://www.pgadmin.org/download/ 5. Now Again open PostgreSQL 15 installer on the features selection screen, deselect pgadmin4(*the EDB Packager team is already working on the issue*) and complete the installations. 6. Now launch the pgadmin4 Kind Regards, On Mon, Jul 17, 2023 at 11:42 AM Chaitanya Kumar < chaitanyachaudhary...@gmail.com> wrote: > Just deleted that file and again launch the pgadmin 4 but same problem. > > On Mon, 17 Jul, 2023, 11:30 Fahar Abbas, > wrote: > >> Just delete that db file that is selected on the screenshot and try again. >> >> On Mon, Jul 17, 2023 at 10:26 AM Chaitanya Kumar < >> chaitanyachaudhary...@gmail.com> wrote: >> >>> Please check there is no such file as per given by you. >>> >>> [image: image.png] >>> >>> On Mon, Jul 17, 2023 at 10:16 AM Fahar Abbas < >>> fahar.ab...@enterprisedb.com> wrote: >>> >>>> Hi, >>>> >>>> Please remove pgadmin4.db file under the location >>>> :C:\Users\home\AppData\Roaming\pgadmin and Relaunch pgadmin4. >>>> >>>> On Mon, Jul 17, 2023 at 9:29 AM Chaitanya Kumar < >>>> chaitanyachaudhary...@gmail.com> wrote: >>>> >>>>> I have uninstalled completely from my system and even reset my laptop. >>>>> After that I download and install but I'm facing the same issue. >>>>> >>>>> On Mon, Jul 17, 2023 at 9:44 AM Fahar Abbas < >>>>> fahar.ab...@enterprisedb.com> wrote: >>>>> >>>>>> Hi Chaitanya, >>>>>> >>>>>> Meanwhile, you can uninstall pgAdmin using Postgresql >>>>>> uninstaller(since it is shipped with it) and download it separately from >>>>>> https://www.pgadmin.org/download/ >>>>>> >>>>>> On Sun, Jul 16, 2023 at 5:49 PM Chaitanya Kumar < >>>>>> chaitanyachaudhary...@gmail.com> wrote: >>>>>> >>>>>>> Please revert >>>>>>> >>>>>>> On Sat, 15 Jul, 2023, 15:19 Chaitanya Kumar, < >>>>>>> chaitanyachaudhary...@gmail.com> wrote: >>>>>>> >>>>>>>> Hey, >>>>>>>> Please provide the solution on top priority. >>>>>>>> >>>>>>>> [image: image.png] >>>>>>>> >>>>>>>> -- >>>>>>>> >>>>>>>> *Thanks & Regards* >>>>>>>> *Chaitanya* >>>>>>>> >>>>>>> >>>>>> >>>>>> -- >>>>>> Fahar Abbas >>>>>> pgAdmin4 team >>>>>> EnterpriseDB Corporation >>>>>> Mobile: +92-333-5409707 >>>>>> Skype ID: *live:fahar.abbas* >>>>>> Website: www.enterprisedb.com >>>>>> >>>>> >>>>> >>>>> -- >>>>> >>>>> *Thanks & Regards* >>>>> *Chaitanya* >>>>> >>>> >>>> >>>> -- >>>> Fahar Abbas >>>> pgAdmin4 team >>>> EnterpriseDB Corporation >>>> Mobile: +92-333-5409707 >>>> Skype ID: *live:fahar.abbas* >>>> Website: www.enterprisedb.com >>>> >>> >>> >>> -- >>> >>> *Thanks & Regards* >>> *Chaitanya* >>> >> >> >> -- >> Fahar Abbas >> pgAdmin4 team >> EnterpriseDB Corporation >> Mobile: +92-333-5409707 >> Skype ID: *live:fahar.abbas* >> Website: www.enterprisedb.com >> > -- Fahar Abbas pgAdmin4 team EnterpriseDB Corporation Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Facing Issue While Opening PgAdmin 4
Just delete that db file that is selected on the screenshot and try again. On Mon, Jul 17, 2023 at 10:26 AM Chaitanya Kumar < chaitanyachaudhary...@gmail.com> wrote: > Please check there is no such file as per given by you. > > [image: image.png] > > On Mon, Jul 17, 2023 at 10:16 AM Fahar Abbas > wrote: > >> Hi, >> >> Please remove pgadmin4.db file under the location >> :C:\Users\home\AppData\Roaming\pgadmin and Relaunch pgadmin4. >> >> On Mon, Jul 17, 2023 at 9:29 AM Chaitanya Kumar < >> chaitanyachaudhary...@gmail.com> wrote: >> >>> I have uninstalled completely from my system and even reset my laptop. >>> After that I download and install but I'm facing the same issue. >>> >>> On Mon, Jul 17, 2023 at 9:44 AM Fahar Abbas < >>> fahar.ab...@enterprisedb.com> wrote: >>> >>>> Hi Chaitanya, >>>> >>>> Meanwhile, you can uninstall pgAdmin using Postgresql uninstaller(since >>>> it is shipped with it) and download it separately from >>>> https://www.pgadmin.org/download/ >>>> >>>> On Sun, Jul 16, 2023 at 5:49 PM Chaitanya Kumar < >>>> chaitanyachaudhary...@gmail.com> wrote: >>>> >>>>> Please revert >>>>> >>>>> On Sat, 15 Jul, 2023, 15:19 Chaitanya Kumar, < >>>>> chaitanyachaudhary...@gmail.com> wrote: >>>>> >>>>>> Hey, >>>>>> Please provide the solution on top priority. >>>>>> >>>>>> [image: image.png] >>>>>> >>>>>> -- >>>>>> >>>>>> *Thanks & Regards* >>>>>> *Chaitanya* >>>>>> >>>>> >>>> >>>> -- >>>> Fahar Abbas >>>> pgAdmin4 team >>>> EnterpriseDB Corporation >>>> Mobile: +92-333-5409707 >>>> Skype ID: *live:fahar.abbas* >>>> Website: www.enterprisedb.com >>>> >>> >>> >>> -- >>> >>> *Thanks & Regards* >>> *Chaitanya* >>> >> >> >> -- >> Fahar Abbas >> pgAdmin4 team >> EnterpriseDB Corporation >> Mobile: +92-333-5409707 >> Skype ID: *live:fahar.abbas* >> Website: www.enterprisedb.com >> > > > -- > > *Thanks & Regards* > *Chaitanya* > -- Fahar Abbas pgAdmin4 team EnterpriseDB Corporation Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Facing Issue While Opening PgAdmin 4
Hi, Please remove pgadmin4.db file under the location :C:\Users\home\AppData\Roaming\pgadmin and Relaunch pgadmin4. On Mon, Jul 17, 2023 at 9:29 AM Chaitanya Kumar < chaitanyachaudhary...@gmail.com> wrote: > I have uninstalled completely from my system and even reset my laptop. > After that I download and install but I'm facing the same issue. > > On Mon, Jul 17, 2023 at 9:44 AM Fahar Abbas > wrote: > >> Hi Chaitanya, >> >> Meanwhile, you can uninstall pgAdmin using Postgresql uninstaller(since >> it is shipped with it) and download it separately from >> https://www.pgadmin.org/download/ >> >> On Sun, Jul 16, 2023 at 5:49 PM Chaitanya Kumar < >> chaitanyachaudhary...@gmail.com> wrote: >> >>> Please revert >>> >>> On Sat, 15 Jul, 2023, 15:19 Chaitanya Kumar, < >>> chaitanyachaudhary...@gmail.com> wrote: >>> >>>> Hey, >>>> Please provide the solution on top priority. >>>> >>>> [image: image.png] >>>> >>>> -- >>>> >>>> *Thanks & Regards* >>>> *Chaitanya* >>>> >>> >> >> -- >> Fahar Abbas >> pgAdmin4 team >> EnterpriseDB Corporation >> Mobile: +92-333-5409707 >> Skype ID: *live:fahar.abbas* >> Website: www.enterprisedb.com >> > > > -- > > *Thanks & Regards* > *Chaitanya* > -- Fahar Abbas pgAdmin4 team EnterpriseDB Corporation Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Facing Issue While Opening PgAdmin 4
Hi Chaitanya, Meanwhile, you can uninstall pgAdmin using Postgresql uninstaller(since it is shipped with it) and download it separately from https://www.pgadmin.org/download/ On Sun, Jul 16, 2023 at 5:49 PM Chaitanya Kumar < chaitanyachaudhary...@gmail.com> wrote: > Please revert > > On Sat, 15 Jul, 2023, 15:19 Chaitanya Kumar, < > chaitanyachaudhary...@gmail.com> wrote: > >> Hey, >> Please provide the solution on top priority. >> >> [image: image.png] >> >> -- >> >> *Thanks & Regards* >> *Chaitanya* >> > -- Fahar Abbas pgAdmin4 team EnterpriseDB Corporation Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: pgAdmin 4 v7.4 Released
Hi, On Wed, Jul 5, 2023 at 12:31 PM Roberto Tagliaferri - Tosnet srl < r.tagliafe...@tosnet.it> wrote: > Il 29/06/23 08:17, Akshay Joshi ha scritto: > > The pgAdmin Development Team is pleased to announce pgAdmin 4 version 7.4. > > This release of pgAdmin 4 includes 16 bug fixes and new features. For more > details please see the release notes at: > > https://www.pgadmin.org/docs/pgadmin4/7.4/release_notes_7_4.html > > pgAdmin is the leading Open Source graphical management tool for > PostgreSQL. For more information, please see: > > https://www.pgadmin.org/ > > Notable changes in this release include: > > Features: > >- > >Added support to drop databases using the 'WITH (FORCE)' option. >- > >Add '[ NULLS [ NOT ] DISTINCT ]' option while creating an Index. >- > >Added 'OR REPLACE' clause while creating a trigger. >- > >Added security_invoker option while creating a view. > > > Bugs/Housekeeping: > >- > >Fix an issue where the object explorer tree crashes occasionally. >- > >Ensure that query tool shortcuts are working properly. >- > >Add Password exec command and Expiration time to server export JSON >and also allow them to import. >- > >When opening pgAdmin the layout should be auto reset if it is >corrupted. Reset layout menu should work if layout is corrupted while using >pgAdmin. >- > >Fixed an issue where queries with temporary tables in the same >transaction are not working. >- > >Fix raise notice from func/proc or code blocks are no longer displayed >live. >- > >Fix an issue where PSQL is not working if the database name has quotes >or double quotes. >- > >Fix an encoding error when connecting through Pgbouncer. >- > >Fix an issue where explain plan details are showing HTML escaped >characters. >- > >Fixed an issue where preview images for themes were not loading. > > > > Builds for Windows and macOS are available now, along with a Python Wheel, > > Docker Container, RPM, DEB Package, and source code tarball from: > > https://www.pgadmin.org/download/ > > -- > > Akshay Joshi > > pgAdmin Project > > Hi, in the download page fedora 36 has no data in last supported release, > but in repository 7.4 appear from fedora37, not 36 > Yes Fedora 36 support ended on 2023-05-16 as per https://docs.fedoraproject.org/en-US/releases/eol/ and pgAdmin4 v7.3 is the last supported version and we have also reflected this change in the website. Thanks for your reminder. > > > -- > *Roberto Tagliaferri* > *Amministrazione di sistema * | TosNet s.r.l. Internet Service Provider > Via F.lli Giachetti, 28/3 > 59100 Prato (PO) > www.tosnet.it > Office: *+39 0574 875 100 * > Mobile: *+39 329 591 3899* > Skype: *ilrobyt* > <https://www.ftpa.it/> <http://www.c-posta.it/> <http://www.ftpec.it/> > <http://pecstorage.it/> <http://www.ftcloud.it/> > <https://www.ftpa.it/nso.php> <https://www.ftpa.it/spid.php> > <http://www.dgtsign.it/> <http://www.timecert.it/> > <https://www.tosnet.it/> <http://www.miglioresistemaantivirus.it/> > <http://www.antivirusgdata.it/> > > > > > > > > * Ai sensi del Reg. EU n. 679/16 (GDPR) si precisa che le informazioni > contenute nella presente mail, nonché gli eventuali allegati, sono > riservate e ad uso esclusivo dei destinatari. Stai ricevendo la presente > mail in quanto sei cliente di TosNet S.r.l., utilizzi uno o più dei nostri > servizi o semplicemente perchè stiamo dando ad una tua richiesta che ci è > pervenuta per iscritto, tramite una procedura, di persona o > telefonicamente. Qualora la presente mail ti fosse pervenuta per errore, ti > preghiamo di eliminarla (senza diffusione a terzi o copiatura delle > informazioni/documenti trasmessi, anche solo parziale), dandocene > gentilmente comunicazione immediata. * > -- Fahar Abbas pgAdmin4 team EnterpriseDB Corporation Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: pgAdmin4 v6.21 on RHEL7.9 with FIPS enabled
Hi,
We have dropped the support for Rhel 7 (
https://www.pgadmin.org/download/pgadmin-4-rpm/), Can you please upgrade
your platform and version 7.1 and try again?
On Fri, May 26, 2023 at 8:17 PM Daxu Yin wrote:
> Hi,
>
> I am new to this list, please forgive me if I am submitting the following
> to the wrong place.
>
> We've just installed pgAdmin4 web mode on RHEL7.9.
> Once we started the httpd service, we couldn't login the system, the
> webpage spins forever.
> The error message is attached below.
> The RHEL 7.9 we use has FIPS enabled, e.g. cat
> /proc/sys/crypto/fips_enabled has a value of 1.
>
> It seems the version of pgAdmin4, 6.21, still uses MD5, which is not
> allowed by FIPS.
>
> I'd highly appreciate if anyone could let us know:
>
> 1. Is there a version of pgAdmin4 on RHEL 7.9 that supports FIPS?
> 2. Is there any plan down the road that pgAdmin4 would support FIPS on
> RHEL 7.9?
> 3. Is there any way to get around the issue?
>
> Many thanks in advance,
>
> ==Error msg in pgadmin log file =
> 2023-05-16 03:04:13,593: ERROR pgadmin:[digital envelope
> routines: EVP_DigestInit_ex] disabled for fips
> Traceback (most recent call last):
> File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/app.py",
> line 1516, in full_dispatch_request
> rv = self.dispatch_request()
> File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/app.py",
> line 1502, in dispatch_request
> Connection to 10.138.182.10 closed by remote
> host.le.endpoint])(**req.view_args)
> Connection to 10.138.182.10
> closed.thon3.6/site-packages/flask_login/utils.py", line 272, in
> decorated_view
> [daxu@ip-192-168-40-129 ~]$ rgs)
> File "/usr/pgadmin4/web/pgadmin/browser/__init__.py", line 634, in utils
> current_ui_lock=current_ui_lock
> File
> "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/templating.py",
> line 150, in render_template
> ctx.app,
> File
> "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/templating.py",
> line 128, in _render
> rv = template.render(context)
> File
> "/usr/pgadmin4/venv/lib64/python3.6/site-packages/jinja2/environment.py",
> line 1291, in render
> self.environment.handle_exception()
> File
> "/usr/pgadmin4/venv/lib64/python3.6/site-packages/jinja2/environment.py",
> line 925, in handle_exception
> raise rewrite_traceback_stack(source=source)
> File "/usr/pgadmin4/web/pgadmin/browser/templates/browser/js/utils.js",
> line 119, in top-level template code
> gravatar: {% if config.SHOW_GRAVATAR_IMAGE %}'{{ username | gravatar
> }}'{% else %}''{% endif %},
> File
> "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask_gravatar/__init__.py",
> line 151, in __call__
> hash = hashlib.md5(email.encode('utf-8')).hexdigest()
> ValueError: [digital envelope routines: EVP_DigestInit_ex] disabled for
> fips
>
>
>
> Daxu Yin
> 410-340-5842
>
--
Fahar Abbas
pgAdmin4 team
EnterpriseDB Corporation
Mobile: +92-333-5409707
Skype ID: *live:fahar.abbas*
Website: www.enterprisedb.com
Re: Two version
Hi, We don't support PostgreSQL 9.5 and the supported versions are PostgreSQL-10 to PostgreSQL 15 for pgadmin4. Kindly upgrade to any supported version. We recommend updating the latest version of pgadmin4 at https://www.pgadmin.org/download/pgadmin-4-windows/. Yes, it is possible on windows to keep pgadmin4v5 and pgadmin4v6 but it is not recommended. Kind Regards, On Tue, Dec 6, 2022 at 9:39 PM Leandro Bugalho wrote: > Hello guys! I need access to two versions of postgresql. I have a > server with 9.5 and another with 14. But the latest version of > pgadmin does not support the postgresql 9.5. How can I access these > two versions, if it is not possible to install two versions of > pgadmin in the same machine? Does anybody have a suggestion? > > thanks > > Leandro > > > -- Fahar Abbas pgAdmin4 team EnterpriseDB Corporation Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Pgadmin 4.15 Upgrade
Hi, Currently, we are using v6.14 and next week are releasing v6.15. Can you please share the steps, snapshot and the platform you are using for more detail? https://www.pgadmin.org/download/ On Tue, Oct 11, 2022 at 11:39 AM Artner Michael < michael.artner@wien.gv.at> wrote: > Hello > > > > > > I need to update my Pgadmin 4.15 web version to a current one. > > I have already started some upgrade attempts, but afterwards I always had > the problem that the existing users (~30) could no longer work with their > accounts > > > there were many error messages when logging in and no connection data was > visible anymore. > > > > How do I have to proceed > Can I install a new Pgadmin computer and > migrate the user data (database) to the new one? > > > > > > Thanks for any help. > > > > Michael > > > > > > > *Mit freundlichen Grüßen Michael Artner * > > * BDC4 Datenbanken *Magistratsabteilung 01 > Wien Digital > Tel.: +43 1 4000 71428 > Mobil: +43 676 8118 71428 > E-Mail: michael.artner@wien.gv.at > www.wien.at > www.wien.at/kontakte/ma01 > > *[image: cid:image001.gif@01D501D0.232FFAF0]* > > > > > -- Fahar Abbas pgAdmin4 team EnterpriseDB Corporation Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: installlization issues
Hi Siva! Can you please share the steps to reproduce and screenshot? On Wed, Jun 15, 2022 at 4:32 PM Siva Narendra V wrote: > > > > > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for > Windows > > Im to install to 117149_PE_8.7. to my pc > > > -- Fahar Abbas pgAdmin4 team EnterpriseDB Corporation Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Unable to connect with password protected ssl key file
Sure, I will try. Thanks On Mon, May 16, 2022 at 2:40 PM Merkel, Christian < christian.mer...@allegion.com> wrote: > Hi Fahar, > > > > for a proper ssl connection (with verify-full) to a postgres server you > need proper certificates. > > Get a copy of easy-rsa from here: https://github.com/OpenVPN/easy-rsa > > > > Execute: > > ./easyrsa init-pki > > ./easyrsa build-ca nopass > > ./easyrsa gen-req pguser > > ./easyrsa gen-req pguser-pw > > (when prompted for Common Name enter pguser, without -pw!) > > > > ./easyrsa gen-req pgserver > > (when prompted for Common Name enter the EXACT same hostname, which is > used by your clients to connect) > > > > ./easyrsa sign-req client pguser > > ./easyrsa sign-req client pguser-pw > > ./easyrsa sign-req server pgserver > > > > Now you have all certificates in a directory named pki, but you need to > move them in place. > > > > Edit your postgresql.conf of your server and set: > > ssl = on > > ssl_ca_file = 'must point to your pki/ca.crt' > > ssl_cert_file = ' must point to your pki/issued/pgserver.crt' > > ssl_key_file = ' must point to your pki/private/pgserver.key' > > > > Edit and add to your pg_hba.conf: > > # TYPE DATABASEUSERADDRESS METHOD > > hostssl all all all cert > > > > Open the properties of the connection in pgAdmin4 and set in the SSL tab: > > SSL mode: Verify-Full > > Client certificate: pki/issued/pgclient.crt > > Client certificate key: pki/private/pgclient.key > > Root certificate: pki/ca.crt > > > > Make sure a user called pgclient EXISTS on your postgres server, then you > should now be able to connect. > > > > And now to the problem, change the following in your connection properties: > > Client certificate: pki/issued/pgclient-pw.crt > > Client certificate key: pki/private/pgclient-pw.key > > > > And see how you won’t be able to connect to the server and that there is > no prompt shown to enter the password for the pgclient-pw.key > > > > > > Best regards, > > Christian > > > > *From:* Fahar Abbas > *Sent:* Montag, 16. Mai 2022 10:37 > *To:* Merkel, Christian > *Cc:* pgadmin-support@lists.postgresql.org > *Subject:* Re: Unable to connect with password protected ssl key file > > > > *EXTERNE MITTEILUNG: Seien sie vorsichtig mit Antworten, Links und > Anhängen.* > > Hi Merkel, > > > > Can you please share the exact steps to reproduce and screenshot? > > > > I am getting the following error message on psql (command-line tool for > PostgreSQL) for verify-full option: > > > > psql.bin: root certificate file "/root/.postgresql/root.crt" does not exist > Either provide the file or change sslmode to disable server certificate > verification. > > > > Can you please try your error message through psql > > > > Steps > > 1.go into PostgreSQL binary path and execute this command > > > > export PGSSLMODE=verify-full > > 2. no connect with psql > > [root@localhost bin]# ./psql -U postgres -h localhost -p 5432 -d postgres > psql.bin: root certificate file "/root/.postgresql/root.crt" does not exist > Either provide the file or change sslmode to disable server certificate > verification. > > > > If you are getting the same error message through psql then it is not an > issue with pgadmin4. > > > > On Wed, May 11, 2022 at 4:23 PM Merkel, Christian < > christian.mer...@allegion.com> wrote: > > Hello, > > > > the pgadmin 6.8 software does support SSL mode Verify-Full on connect. > > But how is it possible to use a password protected client certificate key > file to connect? (without password works) > > > > There is no prompt shown on connect nor could I find any other way to > provide the password for the key. > > The whole application gets stuck in “connecting” to server for forever, so > it’s also kind of a bug here(?) > > > > Best regards, > > Christian Merkel > > > > > > -- > > Fahar Abbas > > pgAdmin4 team > > EnterpriseDB Corporation > > Mobile: +92-333-5409707 > Skype ID: *live:fahar.abbas* > Website: www.enterprisedb.com > -- Fahar Abbas pgAdmin4 team EnterpriseDB Corporation Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Problem related to volume creation to pgadmin 4 Docker image
t;, line >>>>>>>>> 359, in import_app >>>>>>>>> mod = importlib.import_module(module) >>>>>>>>> File "/usr/lib/python3.8/importlib/__init__.py", line 127, in >>>>>>>>> import_module >>>>>>>>> return _bootstrap._gcd_import(name[level:], package, level) >>>>>>>>> File "", line 1014, in _gcd_import >>>>>>>>> File "", line 991, in _find_and_load >>>>>>>>> File "", line 975, in >>>>>>>>> _find_and_load_unlocked >>>>>>>>> File "", line 671, in _load_unlocked >>>>>>>>> File "", line 848, in >>>>>>>>> exec_module >>>>>>>>> File "", line 219, in >>>>>>>>> _call_with_frames_removed >>>>>>>>> File "/pgadmin4/run_pgadmin.py", line 4, in >>>>>>>>> from pgAdmin4 import app >>>>>>>>> File "/pgadmin4/pgAdmin4.py", line 98, in >>>>>>>>> app = create_app() >>>>>>>>> File "/pgadmin4/pgadmin/__init__.py", line 441, in create_app >>>>>>>>> paths.init_app(app) >>>>>>>>> File "/pgadmin4/pgadmin/utils/paths.py", line 103, in init_app >>>>>>>>> raise InternalServerError( >>>>>>>>> werkzeug.exceptions.InternalServerError: 500 Internal Server >>>>>>>>> Error: The user does not have permission to read and write to the >>>>>>>>> specified >>>>>>>>> storage directory. >>>>>>>>> On 20/10/2021 09:08, Aditya Toshniwal wrote: >>>>>>>>> >>>>>>>>> Hi Rodrigo, >>>>>>>>> >>>>>>>>> /var/lib/pgadmin/storage is the base directory. A sub directory >>>>>>>>> for each user will be created for storing user files. >>>>>>>>> >>>>>>>>> On Wed, Oct 20, 2021 at 5:10 PM Rodrigo Mariano < >>>>>>>>> rodmarian...@gmail.com> wrote: >>>>>>>>> >>>>>>>>>> Hi, >>>>>>>>>> >>>>>>>>>> I'm having a trouble related to pgadmin 4 Docker image >>>>>>>>>> <https://hub.docker.com/r/dpage/pgadmin4> >>>>>>>>>> <https://hub.docker.com/r/dpage/pgadmin4>. >>>>>>>>>> >>>>>>>>>> I would like to create a volume to */var/lib/pgadmin/storage* >>>>>>>>>> folder, in order to access backup files created by pgadmin 4 >>>>>>>>>> interface, >>>>>>>>>> however error messages about permission denied are raised, for >>>>>>>>>> example: >>>>>>>>>> >>>>>>>>>> werkzeug.exceptions.InternalServerError: 500 Internal Server >>>>>>>>>> Error: The user does not have permission to read and write to the >>>>>>>>>> specified >>>>>>>>>> storage directory. >>>>>>>>>> >>>>>>>>>> Is there a way to create this volume? >>>>>>>>>> >>>>>>>>>> I had to use a command to change user and group of my volume to >>>>>>>>>> 5050:5050 (i.e. *sudo chown -R 5050:5050 pgadmin4*), but now I'm >>>>>>>>>> not able to get into the folder anymore, even when I try creating a >>>>>>>>>> volume >>>>>>>>>> to */var/lib/pgadmin/storage* folder directly. >>>>>>>>>> >>>>>>>>>> I send below my Docker compose file with default values. >>>>>>>>>> >>>>>>>>>> Thank you in advance. >>>>>>>>>> >>>>>>>>>> Best regards, >>>>>>>>>> Rodrigo >>>>>>>>>> >>>>>>>>>> - >>>>>>>>>> >>>>>>>>>> *docker-compose.yml* >>>>>>>>>> >>>>>>>>>> version: '3' >>>>>>>>>> >>>>>>>>>> services: >>>>>>>>>> cdsr_postgis: >>>>>>>>>> container_name: cdsr_postgis >>>>>>>>>> image: kartoza/postgis:11.0-2.5 >>>>>>>>>> restart: on-failure >>>>>>>>>> environment: >>>>>>>>>> - POSTGRES_USER=postgres >>>>>>>>>> - POSTGRES_PASS=postgres >>>>>>>>>> - ALLOW_IP_RANGE=0.0.0.0/0 >>>>>>>>>> - >>>>>>>>>> POSTGRES_MULTIPLE_EXTENSIONS=postgis,hstore,postgis_topology,pgrouting >>>>>>>>>> volumes: >>>>>>>>>> - ./volumes/postgresql:/var/lib/postgresql >>>>>>>>>> networks: >>>>>>>>>> - cdsr >>>>>>>>>> ports: >>>>>>>>>> - 6000:5432 >>>>>>>>>> >>>>>>>>>> cdsr_pgadmin4: >>>>>>>>>> container_name: cdsr_pgadmin4 >>>>>>>>>> image: dpage/pgadmin4:5.4 >>>>>>>>>> restart: on-failure >>>>>>>>>> environment: >>>>>>>>>> - PGADMIN_DEFAULT_EMAIL=postg...@localhost.com >>>>>>>>>> - PGADMIN_DEFAULT_PASSWORD=postgres >>>>>>>>>> volumes: >>>>>>>>>> # to fix permission bugs: >>>>>>>>>> # sudo chown -R 5050:5050 pgadmin4 >>>>>>>>>> - ./volumes/pgadmin4:/var/lib/pgadmin >>>>>>>>>> - ./volumes/pgadmin4_storage:/var/lib/pgadmin/storage >>>>>>>>>> networks: >>>>>>>>>> - cdsr >>>>>>>>>> depends_on: >>>>>>>>>> - cdsr_postgis >>>>>>>>>> ports: >>>>>>>>>> - 6001:80 >>>>>>>>>> >>>>>>>>>> networks: >>>>>>>>>> cdsr: >>>>>>>>>> driver: bridge >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> Thanks, >>>>>>>>> Aditya Toshniwal >>>>>>>>> pgAdmin Hacker | Software Architect | *edbpostgres.com* >>>>>>>>> <http://edbpostgres.com> >>>>>>>>> "Don't Complain about Heat, Plant a TREE" >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Thanks, >>>>>>>> Aditya Toshniwal >>>>>>>> pgAdmin Hacker | Software Architect | *edbpostgres.com* >>>>>>>> <http://edbpostgres.com> >>>>>>>> "Don't Complain about Heat, Plant a TREE" >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Thanks, >>>>>>> Aditya Toshniwal >>>>>>> pgAdmin Hacker | Software Architect | *edbpostgres.com* >>>>>>> <http://edbpostgres.com> >>>>>>> "Don't Complain about Heat, Plant a TREE" >>>>>>> >>>>>>> >>>>>> >>>>>> -- >>>>>> Dave Page >>>>>> Blog: https://pgsnake.blogspot.com >>>>>> Twitter: @pgsnake >>>>>> >>>>>> EDB: https://www.enterprisedb.com >>>>>> >>>>>> >>>>> >>>>> -- >>>>> Dave Page >>>>> Blog: https://pgsnake.blogspot.com >>>>> Twitter: @pgsnake >>>>> >>>>> EDB: https://www.enterprisedb.com >>>>> >>>>> >>>> >>>> -- >>>> Dave Page >>>> Blog: https://pgsnake.blogspot.com >>>> Twitter: @pgsnake >>>> >>>> EDB: https://www.enterprisedb.com >>>> >>>> >>> >>> -- >>> Dave Page >>> Blog: https://pgsnake.blogspot.com >>> Twitter: @pgsnake >>> >>> EDB: https://www.enterprisedb.com >>> >>> >> >> -- >> Dave Page >> Blog: https://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EDB: https://www.enterprisedb.com >> >> > > -- > *Thanks & Regards* > *Akshay Joshi* > *pgAdmin Hacker | Principal Software Architect* > *EDB Postgres <http://edbpostgres.com>* > > *Mobile: +91 976-788-8246* > -- Fahar Abbas pgAdmin4 team EnterpriseDB Corporation Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Please change description field for pgadmin4.exe
Hi, The pgAdmin4 is purely nwjs based and this is expected. On Tue, Apr 12, 2022 at 4:22 PM Osdoba, Sascha wrote: > Hi, > > > > would you please change description field of pgadmin4.exe to Pgadmin4 or > something. > > > > Regards, > > > > Sascha > > > > -- Fahar Abbas pgAdmin4 team EnterpriseDB Corporation Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Require assistance to install pgadmin software
Hi Mallika, I am confused that you are installing software of aws ec2 instance using userdata script, as far as i know we only support silent mode on Windows installers. Yes we can have an interactive session and what is the feasible time to join the call and you can send personal details on private email? On Fri, Jan 21, 2022 at 12:02 AM Mallika Aravelly < mallika.arave...@gmail.com> wrote: > Hi Fahar, > > I am having issues while installing this software on aws ec2 instance > using userdata script, userdata script does install software at launch. > Can we have an interactive session where I will recreate the issue and > show you? > > > Regards, > Mallika > > On Wed, Jan 19, 2022 at 12:05 AM Fahar Abbas > wrote: > >> Hi, >> >> I am not able to see any issue with silent and verysilent installations >> modes >> >> How I tested the installers: >> >> a) >> 1. open command line and execute installer: >> pgadmin4-6.4-x64.exe /SILENT >> 2. Launch pgadmin4 through Application Menu(No issue) >> >> b) >> 1. open command line and execute installer: >> pgadmin4-6.4-x64.exe /VERYSILENT >> 2. Launch pgadmin4 through Application Menu(No issue) >> >> Can you please share more information, how you tested the installer so we >> can investigate the actual issue? >> >> On Wed, Jan 19, 2022 at 9:53 AM Ninad Shah >> wrote: >> >>> She is asking for a non-interactive installation. >>> >>> >>> Regards, >>> Ninad Shah >>> >>> On Tue, 18 Jan 2022 at 16:39, Fahar Abbas >>> wrote: >>> >>>> Hi Mallika! >>>> >>>> On Tue, Jan 18, 2022 at 1:02 PM Mallika Aravelly < >>>> mallika.arave...@gmail.com> wrote: >>>> >>>>> Hi Team, >>>>> >>>>> I'm trying to install pgadmin4 silently using userdata script but I'm >>>>> unable to install. Requesting help to install pgadmin4 on the Windows 10 >>>>> machine. >>>>> >>>>> I am able to install pgadmin4 successfully on Windows 10 64 bit. What >>>> does your mean "install pgadmin4 silently using userdata script" ? >>>> >>>> Can you please share the exact steps to reproduce and the snapshot >>>> accordingly? >>>> >>>> Expecting your reply and help towards this. >>>>> >>>>> -- >>>>> Thanks & Regards, >>>>> Mallika Aravelly. >>>>> >>>> >>>> >>>> -- >>>> Fahar Abbas >>>> pgAdmin4 team >>>> EnterpriseDB Corporation >>>> Mobile: +92-333-5409707 >>>> Skype ID: *live:fahar.abbas* >>>> Website: www.enterprisedb.com >>>> >>> >> >> -- >> Fahar Abbas >> pgAdmin4 team >> EnterpriseDB Corporation >> Mobile: +92-333-5409707 >> Skype ID: *live:fahar.abbas* >> Website: www.enterprisedb.com >> > > > -- > > Thanks & Regards, > Mallika Aravelly. > -- Fahar Abbas pgAdmin4 team EnterpriseDB Corporation Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: pgAdmin 4 not starting after upgrade to 6.4
Hi Dave Caughey! We have dropped the Windows 7 and Windows 2008R2 64 bit support. Can you please upgrade your system? We have dropped the Windows 7 and Windows 2008R2 64 bit support as per link below: https://www.pgadmin.org/download/pgadmin-4-windows/ pgAdmin is available for 64 bit Windows™ 7 SP1 (desktop) or 2008R2 (server) and above, up to v4.30. v5.0 and later are supported on Windows 8 (desktop) or 2012 (server) and above. 32 bit Windows support is available for versions up to v4.29. Thanks, Kind Regards, On Thu, Jan 20, 2022 at 6:43 PM Dave Caughey wrote: > I still get the same message after a complete uninstall/reinstall. > > I am on Windows 7 SP1 > > Cheers, > Dave > > > On Thu, Jan 20, 2022 at 12:04 AM Fahar Abbas > wrote: > >> Hi Dave Caughey, >> >> I am not able to reproduce the issue. >> >> How I tested: >> >> 1. Installed pgadmin4 6.2 >> 2. Launch pgAdmin4 >> 3. close pgAdmin4 >> 4. Installed pgadmin4 6.4 >> 5. Launch pgadmin4 >> 6. No issue found >> >> Can you please uninstall pgadmin4 from the control panel and try to >> install pgadmin4 6.4 again? >> >> >> On Thu, Jan 20, 2022 at 12:59 AM Dave Caughey wrote: >> >>> Hi all, >>> >>> After upgrading from 6.2 to 6.4, when I start pgAdmin I get an >>> >>> "The pgAdmin 4 server could not be contacted" >>> >>> message, with the environment details shown below. >>> >>> I have tried re-installing pgadmin4-6.4-x64.exe, and tried rebooting >>> windows. >>> >>> Should I uninstall some component and reinstall? Or? And if you need >>> any logs, please let me know where to grab them. >>> >>> Thanks, >>> Dave >>> >>> pgAdmin Runtime Environment >>> >>> Python Path: "C:\Users\User\AppData\Local\Programs\pgAdmin >>> 4\v6\python\python.exe" >>> Runtime Config File: >>> "C:\Users\User\AppData\Roaming\pgadmin\runtime_config.json" >>> pgAdmin Config File: "C:\Users\User\AppData\Local\Programs\pgAdmin >>> 4\v6\web\config.py" >>> Webapp Path: "C:\Users\User\AppData\Local\Programs\pgAdmin >>> 4\v6\web\pgAdmin4.py" >>> pgAdmin Command: "C:\Users\User\AppData\Local\Programs\pgAdmin >>> 4\v6\python\python.exe -s C:\Users\User\AppData\Local\Programs\pgAdmin >>> 4\v6\web\pgAdmin4.py" >>> Environment: >>> - ALLUSERSPROFILE: C:\ProgramData >>> - APPDATA: C:\Users\User\AppData\Roaming >>> - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_1836_DIKKTZARVGRVNIBP >>> - CHROME_RESTART: NW.js|Whoa! NW.js has crashed. Relaunch >>> now?|LEFT_TO_RIGHT >>> - CommonProgramFiles: C:\Program Files\Common Files >>> - CommonProgramFiles(x86): C:\Program Files (x86)\Common Files >>> - CommonProgramW6432: C:\Program Files\Common Files >>> - COMPUTERNAME: USER-PC >>> - ComSpec: C:\Windows\system32\cmd.exe >>> - FP_NO_HOST_CHECK: NO >>> - HOMEDRIVE: C: >>> - HOMEPATH: \Users\User >>> - JAVA_HOME: C:\Program Files\Java\jdk1.8.0_271 >>> - LOCALAPPDATA: C:\Users\User\AppData\Local >>> - LOGONSERVER: \\USER-PC >>> - NUMBER_OF_PROCESSORS: 4 >>> - OS: Windows_NT >>> - Path: C:\Program Files (x86)\Common >>> Files\Oracle\Java\javapath;"C:\Program Files >>> (x86)\Java\jre7\bin";C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program >>> Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program >>> Files\PuTTY\;C:\Program Files\Git\cmd >>> - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC >>> - PGADMIN_INT_KEY: d02a954c-b93a-445b-b57b-ff2764541239 >>> - PGADMIN_INT_PORT: 61303 >>> - PGADMIN_SERVER_MODE: OFF >>> - PROCESSOR_ARCHITECTURE: AMD64 >>> - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 58 Stepping 9, >>> GenuineIntel >>> - PROCESSOR_LEVEL: 6 >>> - PROCESSOR_REVISION: 3a09 >>> - ProgramData: C:\ProgramData >>> - ProgramFiles: C:\Program Files >>> - ProgramFiles(x86): C:\Program Files (x86) >>> - ProgramW6432: C:\Program Files >>> - PSModulePath: C:\Windows\system32\WindowsPowerShell\v1.0\Modules\ >>> - PUBLIC: C:\Users\Public >>> - SESSIONNAME: Console >>> - SystemDrive: C: >>> - SystemRoot: C:\Windows >>> - TEMP: C:\Users\User\AppData\Local\Temp >>> - TMP: C:\Users\User\AppData\Local\Temp >>> - USERDOMAIN: User-PC >>> - USERNAME: User >>> - USERPROFILE: C:\Users\User >>> - windir: C:\Windows >>> - windows_tracing_flags: 3 >>> - windows_tracing_logfile: >>> C:\BVTBin\Tests\installpackage\csilogfile.log >>> >>> >>> >>> Cheers, >>> Dave >>> >> >> >> -- >> Fahar Abbas >> pgAdmin4 team >> EnterpriseDB Corporation >> Mobile: +92-333-5409707 >> Skype ID: *live:fahar.abbas* >> Website: www.enterprisedb.com >> > -- Fahar Abbas pgAdmin4 team EnterpriseDB Corporation Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: pgAdmin 4 not starting after upgrade to 6.4
Can you please let us know about the operating system as well, I am using Windows 10 64? On Thu, Jan 20, 2022 at 10:04 AM Fahar Abbas wrote: > Hi Dave Caughey, > > I am not able to reproduce the issue. > > How I tested: > > 1. Installed pgadmin4 6.2 > 2. Launch pgAdmin4 > 3. close pgAdmin4 > 4. Installed pgadmin4 6.4 > 5. Launch pgadmin4 > 6. No issue found > > Can you please uninstall pgadmin4 from the control panel and try to > install pgadmin4 6.4 again? > > > On Thu, Jan 20, 2022 at 12:59 AM Dave Caughey wrote: > >> Hi all, >> >> After upgrading from 6.2 to 6.4, when I start pgAdmin I get an >> >> "The pgAdmin 4 server could not be contacted" >> >> message, with the environment details shown below. >> >> I have tried re-installing pgadmin4-6.4-x64.exe, and tried rebooting >> windows. >> >> Should I uninstall some component and reinstall? Or? And if you need >> any logs, please let me know where to grab them. >> >> Thanks, >> Dave >> >> pgAdmin Runtime Environment >> >> Python Path: "C:\Users\User\AppData\Local\Programs\pgAdmin >> 4\v6\python\python.exe" >> Runtime Config File: >> "C:\Users\User\AppData\Roaming\pgadmin\runtime_config.json" >> pgAdmin Config File: "C:\Users\User\AppData\Local\Programs\pgAdmin >> 4\v6\web\config.py" >> Webapp Path: "C:\Users\User\AppData\Local\Programs\pgAdmin >> 4\v6\web\pgAdmin4.py" >> pgAdmin Command: "C:\Users\User\AppData\Local\Programs\pgAdmin >> 4\v6\python\python.exe -s C:\Users\User\AppData\Local\Programs\pgAdmin >> 4\v6\web\pgAdmin4.py" >> Environment: >> - ALLUSERSPROFILE: C:\ProgramData >> - APPDATA: C:\Users\User\AppData\Roaming >> - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_1836_DIKKTZARVGRVNIBP >> - CHROME_RESTART: NW.js|Whoa! NW.js has crashed. Relaunch >> now?|LEFT_TO_RIGHT >> - CommonProgramFiles: C:\Program Files\Common Files >> - CommonProgramFiles(x86): C:\Program Files (x86)\Common Files >> - CommonProgramW6432: C:\Program Files\Common Files >> - COMPUTERNAME: USER-PC >> - ComSpec: C:\Windows\system32\cmd.exe >> - FP_NO_HOST_CHECK: NO >> - HOMEDRIVE: C: >> - HOMEPATH: \Users\User >> - JAVA_HOME: C:\Program Files\Java\jdk1.8.0_271 >> - LOCALAPPDATA: C:\Users\User\AppData\Local >> - LOGONSERVER: \\USER-PC >> - NUMBER_OF_PROCESSORS: 4 >> - OS: Windows_NT >> - Path: C:\Program Files (x86)\Common >> Files\Oracle\Java\javapath;"C:\Program Files >> (x86)\Java\jre7\bin";C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program >> Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program >> Files\PuTTY\;C:\Program Files\Git\cmd >> - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC >> - PGADMIN_INT_KEY: d02a954c-b93a-445b-b57b-ff2764541239 >> - PGADMIN_INT_PORT: 61303 >> - PGADMIN_SERVER_MODE: OFF >> - PROCESSOR_ARCHITECTURE: AMD64 >> - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 58 Stepping 9, >> GenuineIntel >> - PROCESSOR_LEVEL: 6 >> - PROCESSOR_REVISION: 3a09 >> - ProgramData: C:\ProgramData >> - ProgramFiles: C:\Program Files >> - ProgramFiles(x86): C:\Program Files (x86) >> - ProgramW6432: C:\Program Files >> - PSModulePath: C:\Windows\system32\WindowsPowerShell\v1.0\Modules\ >> - PUBLIC: C:\Users\Public >> - SESSIONNAME: Console >> - SystemDrive: C: >> - SystemRoot: C:\Windows >> - TEMP: C:\Users\User\AppData\Local\Temp >> - TMP: C:\Users\User\AppData\Local\Temp >> - USERDOMAIN: User-PC >> - USERNAME: User >> - USERPROFILE: C:\Users\User >> - windir: C:\Windows >> - windows_tracing_flags: 3 >> - windows_tracing_logfile: C:\BVTBin\Tests\installpackage\csilogfile.log >> >> >> >> Cheers, >> Dave >> > > > -- > Fahar Abbas > pgAdmin4 team > EnterpriseDB Corporation > Mobile: +92-333-5409707 > Skype ID: *live:fahar.abbas* > Website: www.enterprisedb.com > -- Fahar Abbas pgAdmin4 team EnterpriseDB Corporation Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Require assistance to install pgadmin software
Hi, I am not able to see any issue with silent and verysilent installations modes How I tested the installers: a) 1. open command line and execute installer: pgadmin4-6.4-x64.exe /SILENT 2. Launch pgadmin4 through Application Menu(No issue) b) 1. open command line and execute installer: pgadmin4-6.4-x64.exe /VERYSILENT 2. Launch pgadmin4 through Application Menu(No issue) Can you please share more information, how you tested the installer so we can investigate the actual issue? On Wed, Jan 19, 2022 at 9:53 AM Ninad Shah wrote: > She is asking for a non-interactive installation. > > > Regards, > Ninad Shah > > On Tue, 18 Jan 2022 at 16:39, Fahar Abbas > wrote: > >> Hi Mallika! >> >> On Tue, Jan 18, 2022 at 1:02 PM Mallika Aravelly < >> mallika.arave...@gmail.com> wrote: >> >>> Hi Team, >>> >>> I'm trying to install pgadmin4 silently using userdata script but I'm >>> unable to install. Requesting help to install pgadmin4 on the Windows 10 >>> machine. >>> >>> I am able to install pgadmin4 successfully on Windows 10 64 bit. What >> does your mean "install pgadmin4 silently using userdata script" ? >> >> Can you please share the exact steps to reproduce and the snapshot >> accordingly? >> >> Expecting your reply and help towards this. >>> >>> -- >>> Thanks & Regards, >>> Mallika Aravelly. >>> >> >> >> -- >> Fahar Abbas >> pgAdmin4 team >> EnterpriseDB Corporation >> Mobile: +92-333-5409707 >> Skype ID: *live:fahar.abbas* >> Website: www.enterprisedb.com >> > -- Fahar Abbas pgAdmin4 team EnterpriseDB Corporation Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: help me solve the error
Hi Pravin, The issue is fixed in #6809 <https://redmine.postgresql.org/issues/6809> and will be available in the next release. Meanwhile, you can install the nightly build to see if it works for you - https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2021-11-03/ If it doesn't work, then please check #6809 <https://redmine.postgresql.org/issues/6809> and share the pgadmin4.db file if possible for further investigation. Kind Regards, On Wed, Nov 3, 2021 at 12:44 PM Pravin Chauhan wrote: > HI Team, > > Please help to solve the below-getting problem. > > check the screenshot attached. > > This issue occurs while opening pgadmin4 v6. > > Regards > Pravin > -- Fahar Abbas pgAdmin4 team EnterpriseDB Corporation Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Copy error
Hi Grace, This email is related to pgAdmin4, Can you please raise this issue on pgsql-b...@lists.postgresql.org? On Mon, Oct 25, 2021 at 3:39 PM Grace wrote: > Hello, > > I am taking a data analysis class and was given a project. I am having > errors when trying to execute the command. how can I fix this issue? I have > a windows 10. > > ERROR: could not open file "C:\Users\Public\Documents\PostgreSQL > 10\Documentation\" for reading: No such file or directory HINT: COPY FROM > instructs the PostgreSQL server process to read a file. You may want a > client-side facility such as psql's \copy. SQL state: 58P01 > -- Fahar Abbas EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: postgreSQL connectivity issue
Hi, Can you please share the screen-shots? On Mon, Jul 19, 2021 at 3:11 PM Nagashree H M wrote: > Hii Sir, > > > > In pgAdmin 4 to connect PostgreSQL its asking for password . > > > > > > > > Regards, > > Nagashree H M > -- Fahar Abbas EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Windows installation requires admin rights
Hi Dave, On Wed, Jun 9, 2021 at 1:09 PM Dave Page wrote: > Hi > > I'm waiting for Fahar to respond to my previous comments. > I don't see any other issue on Windows new installers. And I agree with all your points. > > It would certainly help if you could test the build as well: > https://developer.pgadmin.org/~dpage/non-admin-install/pgadmin4-5.3-x64.exe > > It would be great if users also verify the same installers and users can raise issues accordingly. > On Wed, Jun 9, 2021 at 7:57 AM AUMJAUD Antoine > wrote: > >> Hi, >> >> What is the next step for this request? >> >> Thanks a lot, >> >> Antoine >> >> >> >> *From:* Dave Page >> *Sent:* jeudi 27 mai 2021 10:24 >> *To:* Fahar Abbas >> *Cc:* Antoine Aumjaud ; pgAdmin Support < >> pgadmin-supp...@postgresql.org> >> *Subject:* Re: Windows installation requires admin rights >> >> >> >> [EMETTEUR EXTERNE] / [EXTERNAL SENDER] >> Soyez vigilant avant d'ouvrir les pièces jointes ou de cliquer sur les >> liens. En cas de doute, signalez le message via le bouton "Message suspect" >> ou consultez go/secu. >> Be cautious before opening attachments or clicking on any links. If in >> doubt, use "Suspicious email" button or visit go/secu. >> >> >> >> Hi >> >> >> >> On Thu, May 27, 2021 at 8:43 AM Fahar Abbas >> wrote: >> >> Hi Dave, >> >> >> >> 1. Installer is not signed in yet and you have already mentioned it. >> >> 2. Findings in *Install for me only(recommended)* option in case of >> Admin User: >> >> >> >> Pgadmin4 installing in the following location: >> >> C:\Users\Administrator\AppData\Local\Programs\pgAdmin 4\v5 >> >> >> >> No issue found so far with this scenario >> >> >> >> OK. >> >> >> >> >> >> 3. Findings in *Install for all users* option with Admin user: >> >> >> >> Pgadmin4 installing in the following location: >> >> C:\Program Files\pgAdmin 4\v5 >> >> >> >> No issue found so far with this scenario >> >> >> >> OK. >> >> >> >> >> >> 4. Findings in *Install for me only(recommended)* option in case of non >> Admin User with double: >> >> >> >> Pgadmin4 installing in the following location: >> >> C:\Users\Administrator\AppData\Local\Programs\pgAdmin 4\v5 >> >> >> >> No issue found so far with this scenario >> >> >> >> If you were logged in as a non-admin user, there's no way it could have >> installed that way under C:\Users\Administrator\ unless your system is >> seriously broken. You would not have had sufficient privileges to install >> into the Administrator's home directory, and the only way the installer >> could have worked around that is if privileges were elevated for which you >> would have had to enter a username/password of the Administrator - which >> wouldn't have been an option with "Install only for me". >> >> >> >> >> >> 5. Findings in *Install for all users* option with Non admin user: >> >> >> >> Pgadmin4 installing in the following location: >> >> C:\Program Files\pgAdmin 4\v5 >> >> >> >> No issue found so far with this scenario >> >> >> >> OK. >> >> >> >> >> >> 6. Findings in *Install for me only(recommended)* option, in case user >> change the installation directory with non admin user: >> >> >> >> Login to admin user >> >> >> >> Pgadmin4 installing in the following location: >> >> C:\Users\Administrator\AppData\Local\Programs\pgAdmin 4\v5 >> >> >> >> But I changed the installation directory before the installation: >> >> C:\Users\rayyan\AppData\Local\Programs\pgAdmin 4\v5 >> >> >> >> Menu item of pgadmin created under Administrator account while the >> installation is available in C:\Users\rayyan\AppData\Local\Programs\pgAdmin >> 4\v5 >> >> >> >> I can launch the pgadmin4 under an admin account successfully and in case >> a non-admin menu item of pgadmin is not present, but I can launch with the >> pgadmin4 script successfully. >> >> >> >> Yes, that's what I would expect to happen. The Administrator can install >> anywhere, including under another user's home directory. The sho
Re: Windows installation requires admin rights
Hi Dave, 1. Installer is not signed in yet and you have already mentioned it. 2. Findings in *Install for me only(recommended)* option in case of Admin User: Pgadmin4 installing in the following location: C:\Users\Administrator\AppData\Local\Programs\pgAdmin 4\v5 No issue found so far with this scenario 3. Findings in *Install for all users* option with Admin user: Pgadmin4 installing in the following location: C:\Program Files\pgAdmin 4\v5 No issue found so far with this scenario 4. Findings in *Install for me only(recommended)* option in case of non Admin User with double: Pgadmin4 installing in the following location: C:\Users\Administrator\AppData\Local\Programs\pgAdmin 4\v5 No issue found so far with this scenario 5. Findings in *Install for all users* option with Non admin user: Pgadmin4 installing in the following location: C:\Program Files\pgAdmin 4\v5 No issue found so far with this scenario 6. Findings in *Install for me only(recommended)* option, in case user change the installation directory with non admin user: Login to admin user Pgadmin4 installing in the following location: C:\Users\Administrator\AppData\Local\Programs\pgAdmin 4\v5 But I changed the installation directory before the installation: C:\Users\rayyan\AppData\Local\Programs\pgAdmin 4\v5 Menu item of pgadmin created under Administrator account while the installation is available in C:\Users\rayyan\AppData\Local\Programs\pgAdmin 4\v5 I can launch the pgadmin4 under an admin account successfully and in case a non-admin menu item of pgadmin is not present, but I can launch with the pgadmin4 script successfully. 7. I tested pgadmin on clean machine and no issue found 8. I also tested pgadmin4 if existing vcredist and vm tool is already available, no issue found On Tue, May 25, 2021 at 1:29 PM Dave Page wrote: > Hi > > On Fri, May 21, 2021 at 9:25 PM Antoine Aumjaud > wrote: > >> Hi, >> >> >> >> The actual configuration of *Inno Setup* for the installation of >> *pgAdmin4* requires admin privileges on the computer : >> >> >> https://github.com/postgres/pgadmin4/blob/master/pkg/win32/installer.iss.in#L31 >> >> PrivilegesRequired=admin >> >> >> >> I have read the whole configuration, and I think that this constrain >> could be remove if HKCU (HKEY_CURENT_USER of Windows registry) is used >> instead of HKLM (HKEY_LOCAL_MACHINE). >> >> >> >> The pgAdmin package provided by entreprisedb can be installed without >> admin rights, but it is an old version of pgAdmin. >> >> >> >> Do you think that this modification is possible? >> > I think it's a little more complex than that, but here's a patch that I > think does everything required. The only part I'm not sure about is the > VC++ runtime installation, and ensuring that will work for non-admins. > Fahar; can you test that on a *completely* clean installation of Windows > please? You must run the "install only for me" option before anything else > (don't even install VMware tools). > > There's a test build at > https://developer.pgadmin.org/~dpage/non-admin-install/pgadmin4-5.3-x64.exe. > Note that it is not signed, so you will get a warning, but that can be > ignored for the purposes of this test. > > -- > Dave Page > Blog: https://pgsnake.blogspot.com > Twitter: @pgsnake > > EDB: https://www.enterprisedb.com > > -- Fahar Abbas EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Windows installation requires admin rights
Sure, I will update you soon. On Tue, May 25, 2021 at 1:29 PM Dave Page wrote: > Hi > > On Fri, May 21, 2021 at 9:25 PM Antoine Aumjaud > wrote: > >> Hi, >> >> >> >> The actual configuration of *Inno Setup* for the installation of >> *pgAdmin4* requires admin privileges on the computer : >> >> >> https://github.com/postgres/pgadmin4/blob/master/pkg/win32/installer.iss.in#L31 >> >> PrivilegesRequired=admin >> >> >> >> I have read the whole configuration, and I think that this constrain >> could be remove if HKCU (HKEY_CURENT_USER of Windows registry) is used >> instead of HKLM (HKEY_LOCAL_MACHINE). >> >> >> >> The pgAdmin package provided by entreprisedb can be installed without >> admin rights, but it is an old version of pgAdmin. >> >> >> >> Do you think that this modification is possible? >> > I think it's a little more complex than that, but here's a patch that I > think does everything required. The only part I'm not sure about is the > VC++ runtime installation, and ensuring that will work for non-admins. > Fahar; can you test that on a *completely* clean installation of Windows > please? You must run the "install only for me" option before anything else > (don't even install VMware tools). > > There's a test build at > https://developer.pgadmin.org/~dpage/non-admin-install/pgadmin4-5.3-x64.exe. > Note that it is not signed, so you will get a warning, but that can be > ignored for the purposes of this test. > > -- > Dave Page > Blog: https://pgsnake.blogspot.com > Twitter: @pgsnake > > EDB: https://www.enterprisedb.com > > -- Fahar Abbas EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: pgAdmin4 fatal error
Hi Michaela, Can you please follow instructions below: 1. Uninstall pgadmin4 community build(www.pgadmin.org) 2. uninstall all postgresql that downloaded from enterprisedb.com 3. Go into run and search %appdata% and remove pgadmin4 5. Can you please shutdown the Windows machine and start Windows machine again 6. Download and install the latest postgresql from https://www.enterprisedb.com/downloads/postgresql 7. Now hopefully you will be able to launch pgadmin4 successfully. On Tue, May 11, 2021 at 10:24 AM Fahar Abbas wrote: > yes issue will be resolved on Postgresql. > > On Mon, May 10, 2021 at 3:28 PM Michaela Burrell < > micha...@datalorian.co.uk> wrote: > >> Many thanks Fahar, >> >> Does it mean it should resolve the issue I’m facing? >> >> Kind regards, >> Michaela >> >> Sent from my iPhone >> >> On 10 May 2021, at 09:23, Fahar Abbas >> wrote: >> >> >> Hi Michaela, >> >> Our PostgreSQL packagers team will update the latest pgadmin4 5.2 on the >> upcoming PostgreSQL minor release by the end of this week. >> >> On Tue, May 4, 2021 at 10:27 AM Aditya Toshniwal < >> aditya.toshni...@enterprisedb.com> wrote: >> >>> Hi Michaela, >>> >>> I suspect you're using pgAdmin shipped with PostgeSQL 10 installer which >>> is an older version. Please check if you have two pgAdmin installed - one >>> which comes with PostgreSQL bundle (you can uninstall this) and another >>> which you have separately downloaded and installed. >>> >>> On Tue, May 4, 2021 at 9:53 AM Rahul Shirsat < >>> rahul.shir...@enterprisedb.com> wrote: >>> >>>> Hi Michaela, >>>> >>>> Could you please share the log files generated at >>>> %APPDATA\Roaming\pgadmin\% by name pgadmin4.log? >>>> >>>> Also do share pgadmin4.startup file residing under >>>> %APPDATA%\AppData\Local .. >>>> >>>> On Tue, May 4, 2021, 12:59 AM Michaela Burrell < >>>> micha...@datalorian.co.uk> wrote: >>>> >>>>> Hi, >>>>> >>>>> I wonder if you could help please. >>>>> >>>>> I'm doing an SQL training course and I'm struggling to open pgadmin. >>>>> >>>>> I've been in contact with course provider but they've not been able to >>>>> resolve my issue despite multiple email exchanges and I wonder if you >>>>> might >>>>> be able to help please? >>>>> >>>>> I've downloaded PostgreSQL (v10.16) from >>>>> https://www.postgresql.org/download/ and then pgAdmin4 (v 5.1) as >>>>> advised by the trainer. >>>>> >>>>> However, when I open pgAdmin, I receive this message: >>>>> >>>>> >>>>> >>>>> I;ve been advised to update my system settings (.i.e. Path in >>>>> Environment Variables) to the following but it's not resolved the issue. >>>>> I'd be most grateful if you could please help. >>>>> >>>>> >>>>> >>>>> >>>>> Many thanks in advance, >>>>> Michaela >>>>> >>>> >>> >>> -- >>> Thanks, >>> Aditya Toshniwal >>> pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com* >>> <http://edbpostgres.com> >>> "Don't Complain about Heat, Plant a TREE" >>> >> >> >> -- >> Fahar Abbas >> EnterpriseDB Corporation >> Phone Office: +92-51-835-8874 >> Phone Direct: +92-51-8466803 >> Mobile: +92-333-5409707 >> Skype ID: *live:fahar.abbas* >> Website: www.enterprisedb.com >> >> > > -- > Fahar Abbas > EnterpriseDB Corporation > Phone Office: +92-51-835-8874 > Phone Direct: +92-51-8466803 > Mobile: +92-333-5409707 > Skype ID: *live:fahar.abbas* > Website: www.enterprisedb.com > -- Fahar Abbas EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: pgAdmin4 fatal error
yes issue will be resolved on Postgresql. On Mon, May 10, 2021 at 3:28 PM Michaela Burrell wrote: > Many thanks Fahar, > > Does it mean it should resolve the issue I’m facing? > > Kind regards, > Michaela > > Sent from my iPhone > > On 10 May 2021, at 09:23, Fahar Abbas > wrote: > > > Hi Michaela, > > Our PostgreSQL packagers team will update the latest pgadmin4 5.2 on the > upcoming PostgreSQL minor release by the end of this week. > > On Tue, May 4, 2021 at 10:27 AM Aditya Toshniwal < > aditya.toshni...@enterprisedb.com> wrote: > >> Hi Michaela, >> >> I suspect you're using pgAdmin shipped with PostgeSQL 10 installer which >> is an older version. Please check if you have two pgAdmin installed - one >> which comes with PostgreSQL bundle (you can uninstall this) and another >> which you have separately downloaded and installed. >> >> On Tue, May 4, 2021 at 9:53 AM Rahul Shirsat < >> rahul.shir...@enterprisedb.com> wrote: >> >>> Hi Michaela, >>> >>> Could you please share the log files generated at >>> %APPDATA\Roaming\pgadmin\% by name pgadmin4.log? >>> >>> Also do share pgadmin4.startup file residing under >>> %APPDATA%\AppData\Local .. >>> >>> On Tue, May 4, 2021, 12:59 AM Michaela Burrell < >>> micha...@datalorian.co.uk> wrote: >>> >>>> Hi, >>>> >>>> I wonder if you could help please. >>>> >>>> I'm doing an SQL training course and I'm struggling to open pgadmin. >>>> >>>> I've been in contact with course provider but they've not been able to >>>> resolve my issue despite multiple email exchanges and I wonder if you might >>>> be able to help please? >>>> >>>> I've downloaded PostgreSQL (v10.16) from >>>> https://www.postgresql.org/download/ and then pgAdmin4 (v 5.1) as >>>> advised by the trainer. >>>> >>>> However, when I open pgAdmin, I receive this message: >>>> >>>> >>>> >>>> I;ve been advised to update my system settings (.i.e. Path in >>>> Environment Variables) to the following but it's not resolved the issue. >>>> I'd be most grateful if you could please help. >>>> >>>> >>>> >>>> >>>> Many thanks in advance, >>>> Michaela >>>> >>> >> >> -- >> Thanks, >> Aditya Toshniwal >> pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com* >> <http://edbpostgres.com> >> "Don't Complain about Heat, Plant a TREE" >> > > > -- > Fahar Abbas > EnterpriseDB Corporation > Phone Office: +92-51-835-8874 > Phone Direct: +92-51-8466803 > Mobile: +92-333-5409707 > Skype ID: *live:fahar.abbas* > Website: www.enterprisedb.com > > -- Fahar Abbas EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: The pgAdmin 4 server could not be contacted:
Hi, pgadmin4 is working perfectly alright on the MACBigSur, can you please verify in the latest pgadmin4 5.2 release from link below https://www.postgresql.org/ftp/pgadmin/pgadmin4/v5.2/macos/ Issue is also reproducible on PostgreSQL 9.6, 10, 11 and 12 versions and i have already raised it and hopefully we will fix it in the next release of PostgreSQL. On Sun, Apr 25, 2021 at 11:45 PM Idowu Odujobi wrote: > Hello, > > I am running on the current version of MacBigSur and am getting this when > am trying to open Pgadmin4 > > I installed version 12.6 on Mac > > The pgAdmin 4 server could not be contacted: > > Python Path: "/Library/PostgreSQL/12/pgAdmin > 4.app/Contents/Frameworks/Python.framework/Versions/Current/bin/python3" > Runtime Config File: > "/Users/idowuodujobi/Library/Preferences/pgadmin/runtime_config.json" > pgAdmin Config File: "/Library/PostgreSQL/12/pgAdmin > 4.app/Contents/Resources/web/config.py" > Webapp Path: "/Library/PostgreSQL/12/pgAdmin > 4.app/Contents/Resources/web/pgAdmin4.py" > pgAdmin Command: "/Library/PostgreSQL/12/pgAdmin > 4.app/Contents/Frameworks/Python.framework/Versions/Current/bin/python3 > /Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/web/pgAdmin4.py" > Failed to lauch pgAdmin4 with below error: > Error: spawn > ../../Frameworks/Python.framework/Versions/Current/bin/python3 ENOENT > -- Fahar Abbas EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: pgAdmin 4 v4.30 released
Hi, On Mon, Feb 1, 2021 at 1:39 PM androxkentaki wrote: > Hello > > Thanks for fast response > So is there any fast way to migrate all settings from x86 to x64 of > pgAdmin? > Can you please take a database backup from x86 and restore it into the x64 machine? https://www.pgadmin.org/docs/pgadmin4/development/backup_dialog.html Kind Regards, > > pon., 1 lut 2021 o 09:38 Fahar Abbas > napisał(a): > >> Hi, >> >> We have dropped the support for x86 installer for pgadmin4 >> >> 32 bit Windows support is available for versions up to v4.29. >> https://www.pgadmin.org/download/pgadmin-4-windows/ >> >> On Mon, Feb 1, 2021 at 1:14 PM androxkentaki >> wrote: >> >>> Where is x86 setup file for Windows? >>> >>> czw., 28 sty 2021 o 14:14 Akshay Joshi >>> napisał(a): >>> >>>> The pgAdmin Development Team is pleased to announce pgAdmin 4 version >>>> 4.30. >>>> This release of pgAdmin 4 includes 38 bug fixes and new features. For >>>> more details please see the release notes at: >>>> >>>> https://www.pgadmin.org/docs/pgadmin4/4.30/release_notes_4_30.html. >>>> >>>> pgAdmin is the leading Open Source graphical management tool for >>>> PostgreSQL. For more information, please see: >>>> >>>> https://www.pgadmin.org/ >>>> >>>> Notable changes in this release include: >>>> >>>> *Features:* >>>> >>>>- ERD Tool (Beta): >>>> >>>> The Entity-Relationship Diagram (ERD) tool is a database design tool >>>> that provides a graphical representation of database tables, columns, and >>>> inter-relationships. You can use the ERD tool to design a new schema and >>>> generate the SQL required to create it or to reverse engineer and diagram >>>> an existing database schema. >>>> >>>> >>>>- Kerberos Support: >>>> >>>> Kerberos support is added in pgAdmin 4 using SPNEGO for logging into >>>> pgAdmin, similar to the existing LDAP and "internal" options. Note that >>>> support for logging into database servers using Kerberos is not included in >>>> this release, but will be added in a future version. >>>> >>>> >>>>- Add a container option (PGADMIN_DISABLE_POSTFIX) to disable the >>>>Postfix server: >>>> >>>> Postfix (like other MTAs) must start as user 'root', and the pgAdmin >>>> container achieves this using 'sudo'. Whilst that works well in most >>>> environments, it can cause problems in some. This option allows you to >>>> completely disable Postfix to avoid these issues, though you will need to >>>> configure an external mail server to be used to send password reset emails. >>>> >>>> >>>> *Bugs/Housekeeping:* >>>> >>>>- Improve the explain plan details by showing a popup instead of a >>>>tooltip when clicking on plan nodes. >>>>- Ensure that verbose logs are visible for Utility (Backup, >>>>Maintenance etc.) jobs. >>>>- Added support for expressions in exclusion constraints. >>>>- Ensure that the 'template1' database is not visible after >>>>pg_upgrade. >>>>- Added appropriate help message and a placeholder for letting >>>>users know about the account password expiry for Login/Group Role. >>>>- Updated Flask-BabelEx to the latest version. Fixed extra >>>>parentheses issue around joins for Views. >>>>- Ensure that the current value of sequences is ignored while >>>>comparing using Schema Diff. >>>>- Fixed an issue when the user tries to delete multiple records in >>>>the data grid. >>>>- Fixed TypeError exception in schema diff when selecting two >>>>identical objects. >>>>- Include PostgreSQL 13 utilities in the container distribution. >>>> >>>> >>>> Builds for Windows and macOS are available now, along with a Python >>>> Wheel, >>>> Docker Container, RPM, DEB Package, and source code tarball from: >>>> >>>> https://www.pgadmin.org/download/ >>>> >>>> -- >>>> Akshay Joshi >>>> pgAdmin Project >>>> >>>> >>>> >>>> >>> >>> -- >>> Z wyrazami szacunku >>> Andrzej Gerasimuk >>> >> >> >> -- >> Fahar Abbas >> EnterpriseDB Corporation >> Phone Office: +92-51-835-8874 >> Phone Direct: +92-51-8466803 >> Mobile: +92-333-5409707 >> Skype ID: *live:fahar.abbas* >> Website: www.enterprisedb.com >> > > > -- > Z wyrazami szacunku > Andrzej Gerasimuk > -- Fahar Abbas EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: pgAdmin 4 v4.30 released
Hi, We have dropped the support for x86 installer for pgadmin4 32 bit Windows support is available for versions up to v4.29. https://www.pgadmin.org/download/pgadmin-4-windows/ On Mon, Feb 1, 2021 at 1:14 PM androxkentaki wrote: > Where is x86 setup file for Windows? > > czw., 28 sty 2021 o 14:14 Akshay Joshi > napisał(a): > >> The pgAdmin Development Team is pleased to announce pgAdmin 4 version >> 4.30. >> This release of pgAdmin 4 includes 38 bug fixes and new features. For >> more details please see the release notes at: >> >> https://www.pgadmin.org/docs/pgadmin4/4.30/release_notes_4_30.html. >> >> pgAdmin is the leading Open Source graphical management tool for >> PostgreSQL. For more information, please see: >> >> https://www.pgadmin.org/ >> >> Notable changes in this release include: >> >> *Features:* >> >>- ERD Tool (Beta): >> >> The Entity-Relationship Diagram (ERD) tool is a database design tool that >> provides a graphical representation of database tables, columns, and >> inter-relationships. You can use the ERD tool to design a new schema and >> generate the SQL required to create it or to reverse engineer and diagram >> an existing database schema. >> >> >>- Kerberos Support: >> >> Kerberos support is added in pgAdmin 4 using SPNEGO for logging into >> pgAdmin, similar to the existing LDAP and "internal" options. Note that >> support for logging into database servers using Kerberos is not included in >> this release, but will be added in a future version. >> >> >>- Add a container option (PGADMIN_DISABLE_POSTFIX) to disable the >>Postfix server: >> >> Postfix (like other MTAs) must start as user 'root', and the pgAdmin >> container achieves this using 'sudo'. Whilst that works well in most >> environments, it can cause problems in some. This option allows you to >> completely disable Postfix to avoid these issues, though you will need to >> configure an external mail server to be used to send password reset emails. >> >> >> *Bugs/Housekeeping:* >> >>- Improve the explain plan details by showing a popup instead of a >>tooltip when clicking on plan nodes. >>- Ensure that verbose logs are visible for Utility (Backup, >>Maintenance etc.) jobs. >>- Added support for expressions in exclusion constraints. >>- Ensure that the 'template1' database is not visible after >>pg_upgrade. >>- Added appropriate help message and a placeholder for letting users >>know about the account password expiry for Login/Group Role. >>- Updated Flask-BabelEx to the latest version. Fixed extra >>parentheses issue around joins for Views. >>- Ensure that the current value of sequences is ignored while >>comparing using Schema Diff. >>- Fixed an issue when the user tries to delete multiple records in >>the data grid. >>- Fixed TypeError exception in schema diff when selecting two >>identical objects. >>- Include PostgreSQL 13 utilities in the container distribution. >> >> >> Builds for Windows and macOS are available now, along with a Python Wheel, >> Docker Container, RPM, DEB Package, and source code tarball from: >> >> https://www.pgadmin.org/download/ >> >> -- >> Akshay Joshi >> pgAdmin Project >> >> >> >> > > -- > Z wyrazami szacunku > Andrzej Gerasimuk > -- Fahar Abbas EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Unable to installed postgis extension using stack builder
Hi, I have already added an appropriate email list, Kindly always use pgsql-b...@lists.postgresql.org instead of pgadmin-supp...@postgresql.org for all postgreSQL related issues. On Sat, Jan 30, 2021 at 5:00 PM Cadstructure Technology < cadstructur...@gmail.com> wrote: > Good day, > I have installed my desktop postgres apps. but when I am trying to > install postgis extension using stack builder, the following attached > error display, so i need your help please. > -- Fahar Abbas EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: pgAdmin 4 v4.30 (Container)
Hi Paolo, ERD tool is in beta phase and RM is already reported for this https://redmine.postgresql.org/attachments/5593 Kind Regards, On Thu, Jan 28, 2021 at 6:49 PM Paolo Saudin wrote: > Thank you for the wonderful update! > I just updated it via docker on an Ubuntu box, all is working fine. > I noticed that the image export button has a wrong label, the same of > previous button > > [image: image.png] > > Regards, > Paolo Saudin > -- Fahar Abbas EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Installation Error Message
Hi, Can you please try on latest pgadmin4 version https://www.pgadmin.org/download/ Please note that if any pgadmin4 server is running inside the elephant icon, kindly shutdown this first. On Thu, Dec 10, 2020 at 11:23 AM Junhyung Park wrote: > Hi Fahar, > > 1. Browser version > > => I use Safari Version 14.0.1 (16610.2.11.51.8). > > 2. Launch pgadmin4> Right click on the elephant icon> Click on view log > and share the server log? > > => I cannot view the log because the program does not launch with this > error message. > > Best, > > Junhyung > > On Dec 9, 2020, at 6:04 AM, Fahar Abbas > wrote: > > Hi Junhyung, > > We are also planning to release the pgadmin4 4.29 tomorrow and we are not > able to reproduce any issue on macOS Big Sur using test builds. > > Can you please share the following information: > > 1. Browser version > 2. Launch pgadmin4> Right click on the elephant icon> Click on view log > and share the server log? > > On Tue, Dec 8, 2020 at 5:55 AM Junhyung Park > wrote: > >> Hello, >> >> It’s macOS Big Sur (Version 11.0.1). >> >> I tried installing pgadmin4 v2.0 and v4.28 and installations were >> successful but I’m getting the exact same message when I open it. >> >> >> Best, >> >> Junhyung >> >> On Dec 7, 2020, at 2:22 AM, Fahar Abbas >> wrote: >> >> Hello, >> >> Can you please share the operating system details? >> >> On Mon, Dec 7, 2020 at 3:09 PM Junhyung Park >> wrote: >> >>> Hello, >>> >>> Could you please help me solve this installation issue? >>> >>> Thanks, >>> >>> Junhyung >>> >>> Begin forwarded message: >>> >>> *From: *Dave Page >>> *Subject: **Re: Installation Error Message* >>> *Date: *December 7, 2020 at 12:57:32 AM PST >>> *To: *Junhyung Park >>> >>> Hi >>> >>> Please address any support questions to the >>> pgadmin-supp...@postgresql.org mailing list ( >>> https://www.pgadmin.org/support/list/). I am not able to provide >>> support on a private basis. >>> >>> Regards, Dave. >>> >>> On Mon, Dec 7, 2020 at 1:39 AM Junhyung Park >>> wrote: >>> >>>> Hi Dave, >>>> >>>> I’ve tried to download this to my Mac and install multiple times, what >>>> I’m getting everytime is that error message below. Can you please help me >>>> on this? >>>> >>>> Best, >>>> >>>> Junhyung >>>> >>>> >>>> >>>> >>> >>> >>> -- >>> Dave Page >>> PostgreSQL Core Team >>> http://www.postgresql.org/ >>> >>> >>> >> >> -- >> Fahar Abbas >> EnterpriseDB Corporation >> Phone Office: +92-51-835-8874 >> Phone Direct: +92-51-8466803 >> Mobile: +92-333-5409707 >> Skype ID: *live:fahar.abbas* >> Website: www.enterprisedb.com >> >> >> > > -- > Fahar Abbas > EnterpriseDB Corporation > Phone Office: +92-51-835-8874 > Phone Direct: +92-51-8466803 > Mobile: +92-333-5409707 > Skype ID: *live:fahar.abbas* > Website: www.enterprisedb.com > > > -- Fahar Abbas EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Installation Error Message
Hi Junhyung, We are also planning to release the pgadmin4 4.29 tomorrow and we are not able to reproduce any issue on macOS Big Sur using test builds. Can you please share the following information: 1. Browser version 2. Launch pgadmin4> Right click on the elephant icon> Click on view log and share the server log? On Tue, Dec 8, 2020 at 5:55 AM Junhyung Park wrote: > Hello, > > It’s macOS Big Sur (Version 11.0.1). > > I tried installing pgadmin4 v2.0 and v4.28 and installations were > successful but I’m getting the exact same message when I open it. > > Best, > > Junhyung > > On Dec 7, 2020, at 2:22 AM, Fahar Abbas > wrote: > > Hello, > > Can you please share the operating system details? > > On Mon, Dec 7, 2020 at 3:09 PM Junhyung Park > wrote: > >> Hello, >> >> Could you please help me solve this installation issue? >> >> Thanks, >> >> Junhyung >> >> Begin forwarded message: >> >> *From: *Dave Page >> *Subject: **Re: Installation Error Message* >> *Date: *December 7, 2020 at 12:57:32 AM PST >> *To: *Junhyung Park >> >> Hi >> >> Please address any support questions to the >> pgadmin-supp...@postgresql.org mailing list ( >> https://www.pgadmin.org/support/list/). I am not able to provide support >> on a private basis. >> >> Regards, Dave. >> >> On Mon, Dec 7, 2020 at 1:39 AM Junhyung Park >> wrote: >> >>> Hi Dave, >>> >>> I’ve tried to download this to my Mac and install multiple times, what >>> I’m getting everytime is that error message below. Can you please help me >>> on this? >>> >>> Best, >>> >>> Junhyung >>> >>> >>> >>> >> >> >> -- >> Dave Page >> PostgreSQL Core Team >> http://www.postgresql.org/ >> >> >> > > -- > Fahar Abbas > EnterpriseDB Corporation > Phone Office: +92-51-835-8874 > Phone Direct: +92-51-8466803 > Mobile: +92-333-5409707 > Skype ID: *live:fahar.abbas* > Website: www.enterprisedb.com > > > -- Fahar Abbas EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Installation Error Message
Hello, Can you please share the operating system details? On Mon, Dec 7, 2020 at 3:09 PM Junhyung Park wrote: > Hello, > > Could you please help me solve this installation issue? > > Thanks, > > Junhyung > > Begin forwarded message: > > *From: *Dave Page > *Subject: **Re: Installation Error Message* > *Date: *December 7, 2020 at 12:57:32 AM PST > *To: *Junhyung Park > > Hi > > Please address any support questions to the pgadmin-supp...@postgresql.org > mailing > list (https://www.pgadmin.org/support/list/). I am not able to provide > support on a private basis. > > Regards, Dave. > > On Mon, Dec 7, 2020 at 1:39 AM Junhyung Park > wrote: > >> Hi Dave, >> >> I’ve tried to download this to my Mac and install multiple times, what >> I’m getting everytime is that error message below. Can you please help me >> on this? >> >> Best, >> >> Junhyung >> >> >> > > -- > Dave Page > PostgreSQL Core Team > http://www.postgresql.org/ > > > -- Fahar Abbas EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Missing packages for fedora 33
Hi Mike, We don't support the Fedora 33 platform for pgadmin4. --- https://www.pgadmin.org/download/pgadmin-4-rpm/ On Wed, Oct 28, 2020 at 3:38 PM Mike Martin wrote: > > Hi there seems to be missing packages in fedora 33 repo. > In particular missing pgadmin4-python3-flask-compress > > <https://download.postgresql.org/pub/repos/yum/srpms/common/fedora/fedora-32-x86_64/pgadmin4-python3-flask-compress-1.4.0-1.f32.src.rpm> > is missing which prevents pgadmin4 being installed. > > Is there an eta on this? > > Mike > -- Fahar Abbas QMG EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Unable to create a server
Hi Lee! Kindly add pgadmin-supp...@postgresql.org for any issue specific to pgadmin4 and i have already added. Can you please share pgadmin4.log file *(Windows: * %APPDATA%\pgAdmin\pgadmin4.log) In case you do not see any log then you need to enable pgadmin4.log, please visit the following page: https://www.pgadmin.org/faq/ Kind regards, On Tue, Jan 14, 2020 at 5:55 AM Lee Everest wrote: > I can not. I simply cannot register a svr in pgadmin…trying 2 boxes with > no luck. > > > > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for > Windows 10 > > > > *From: *Fahar Abbas > *Sent: *Sunday, January 12, 2020 10:23 PM > *To: *Lee Everest > *Cc: *pgsql-b...@lists.postgresql.org > *Subject: *Re: Unable to create a server > > > > Can you please share steps to reproduce? > > > > On Sun, Jan 12, 2020 at 10:11 PM Lee Everest wrote: > > >- The version of pgAdmin you are running. If it is a development >snapshot, please include the build date from the *Help -> About* screen, >and GIT repository version if known. *4.17* >- The configure options used (if compiled from source) - *No* >- The operating system and version details - e.g. Windows 10, or macOS >10.11.5 >- Whether you're running in server or desktop mode *Windows 10 >desktop* >- The Qt version and configure options used (if compiled from source) >*N/A* >- The Python version and configure options used (if running in server >mode) ) *N/A* >- The output from pip freeze (if running in server mode) ) *N/A* >- Steps required to reproduce the problem. Please include a simple >schema with optional data if required. This may be sent privately *upon >request from a developer* if you are concerned about posting sample >code or data to a public mailing list. > > Response when attempting to ‘Create server’ >>> > > > > [image: cid:16f9d2427ca48485c7e1] > > > > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for > Windows 10 > > > > > > -- > > Fahar Abbas > > QMG > > EnterpriseDB Corporation > > Phone Office: +92-51-835-8874 > Phone Direct: +92-51-8466803 > Mobile: +92-333-5409707 > Skype ID: *live:fahar.abbas* > Website: www.enterprisedb.com > > > -- Fahar Abbas QMG EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: pgadmin4/EnterpriseDB 9.0.4
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
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
QMG
EnterpriseDB Corporation
Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: *live:fahar.abbas*
Website: www.enterprisedb.com
Re: unable to launch pgadmin4 - 4.11 - windows 2016
Hi Chandan! Can you please try on pgadmin4 4.13 and share the screen-shoot? On Wed, Oct 16, 2019 at 11:28 PM Chandan Negi wrote: > > Hi Team, > > I am unable to launch pgadmin4-4.11-x86 on windows 2016 machine. It has > been installed successfully but when i try to launch it, nothing comes up. > > Please advise. > > Cheers, > Chandan > -- Fahar Abbas QMG EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: no rpms for 4.13?
Adding Davrim(The Packager) On Thu, Sep 26, 2019 at 6:29 PM toni incog wrote: > Sry, I'm on fedora 30. > > latest as in 4.13? > > Can't see 4.13 in: > https://download.postgresql.org/pub/repos/yum/11/fedora/fedora-30-x86_64/ > > > dnf list pgadmin4* > ... > PostgreSQL 11 30 - > x86_64 > 63 kB/s | 716 kB 00:11 > Installed Packages > pgadmin4.x86_64 > 4.12-1.f30 @pgdg11 > pgadmin4-docs.noarch > 4.12-1.f30 @pgdg11 > pgadmin4-python3-flask-htmlmin.noarch > 1.5.0-1.f30@pgdg11 > pgadmin4-python3-flask-migrate.noarch > 2.4.0-1.f30@pgdg11 > pgadmin4-python3-psutil.x86_64 > 5.5.1-1.f30@pgdg11 > pgadmin4-python3-six.noarch > 1.12.0-3.f30 @pgdg11 > pgadmin4-python3-sshtunnel.noarch > 0.1.4-1.f30@pgdg11 > pgadmin4-python3-werkzeug.noarch > 0.15.4-1.f30 @pgdg11 > pgadmin4-pytz.noarch > 2018.9-1.f30 @pgdg11 > pgadmin4-web.noarch > 4.12-1.f30 @pgdg11 > Available Packages > pgadmin4-desktop-common.x86_64 > 4.12-1.f30 pgdg11 > pgadmin4-desktop-gnome.noarch > 4.12-1.f30 pgdg11 > pgadmin4-python3-flask.noarch > 1:1.0.2-1.f30 pgdg11 > pgadmin4-python3-flask-login.noarch > 0.4.1-1.f30pgdg11 > pgadmin4-python3-flask-paranoid.noarch > 0.2-1.f30.1pgdg11 > pgadmin4-python3-simplejson.x86_64 > 3.16.0-1.f30 pgdg11 > pgadmin4-python3-wtforms.noarch > 2.2.1-1.f30pgdg11 > > thx > > On Thu, 26 Sep 2019 at 14:52, Fahar Abbas > wrote: > >> Hi Toni! >> >> Can you please share the steps to reproduce and operating system? >> >> I can see latest pgadmin4 rpm on Rhel 7. >> >> Steps to test: >> >> 1.Now install pg repo: >> yum install >> https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-redhat10-10-2.noarch.rpm >> 2. yum clean all >> 3. yum install epel-release* >> 4. yum install pgadmin4* >> >> Kind Regards, >> >> >> On Thu, Sep 26, 2019 at 5:00 PM toni incog wrote: >> >>> >>> >>> >>> >> >> -- >> Fahar Abbas >> QMG >> EnterpriseDB Corporation >> Phone Office: +92-51-835-8874 >> Phone Direct: +92-51-8466803 >> Mobile: +92-333-5409707 >> Skype ID: *live:fahar.abbas* >> Website: www.enterprisedb.com >> > -- Fahar Abbas QMG EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: no rpms for 4.13?
Hi Toni! Can you please share the steps to reproduce and operating system? I can see latest pgadmin4 rpm on Rhel 7. Steps to test: 1.Now install pg repo: yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-redhat10-10-2.noarch.rpm 2. yum clean all 3. yum install epel-release* 4. yum install pgadmin4* Kind Regards, On Thu, Sep 26, 2019 at 5:00 PM toni incog wrote: > > > > -- Fahar Abbas QMG EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: PgAdmin Error when retrieving SQL definition
Hi Paolo, Fix(https://redmine.postgresql.org/issues/4650) will be available in next release of pgadmin4 4.13(19-Sep-2019). On Tue, Aug 27, 2019 at 12:11 PM Paolo Saudin wrote: > Hi, > whenever i click on a VEW I get the following error message and the > pgAdmin does not retrieve the SQL definition. > > [image: image.png] > > Using latest pgAdmin 4.12 container. > Thanks > paolo > -- Fahar Abbas QMG EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: import upload file to pgadmin get CSRF error
Hi Avin, Please replay on Ashesh question: Is it running in 'web' or 'desktop' mode? Also adding Dave Page for his further inputs about shutdown pgadmin4 server process. Kind Regards, On Tue, Aug 6, 2019 at 12:06 PM Avin Kavish wrote: > You can use any one of ps, top, htop, or systemctl to view running > services/processes and kill them > > On Tue, Aug 6, 2019 at 12:21 PM Ashesh Vashi < > ashesh.va...@enterprisedb.com> wrote: > >> On Tue, Aug 6, 2019 at 12:18 PM Fahar Abbas >> wrote: >> >>> Hi, >>> >>> On Tue, Aug 6, 2019 at 11:36 AM Wh isere wrote: >>> >>>> Thank you! I am running pgadmin on a remote server, so there is not Gui >>>> interface, is there command to shut down pgadmin4 server? >>>> I also run yum upgrade pgadmin4*, but it said yum: No match. >>>> >>> Kindly first install GUI on remote machine and shut down pgadmin4 >>> server. >>> >> Before doing that - how did you setup the pgAdmin 4? >> Is it running in 'web' or 'desktop' mode? >> >> -- Thanks, Ashesh >> >>> I don't think so we have any command to shutdown the server. >>> >>> When you will shutdown the pgadmin4 server properly and follow the steps >>> mentioned in the previous replay properly you will not able to see older >>> pgadmin4 4.8 version. >>> >>>> Thanks. >>>> >>>> On Tue, Aug 6, 2019 at 4:25 PM Fahar Abbas < >>>> fahar.ab...@enterprisedb.com> wrote: >>>> >>>>> Please find attached the snapshot for pgadmin4 shutdown the server. >>>>> >>>>> On Tue, Aug 6, 2019 at 11:21 AM Fahar Abbas < >>>>> fahar.ab...@enterprisedb.com> wrote: >>>>> >>>>>> Yes it's due to pgadmin4 is not properly upgrade on your system. >>>>>> >>>>>> Why not you try yum upgrade pgadmin4* include (*) >>>>>> >>>>>> Can you do following steps. >>>>>> >>>>>> 1. Clear you cache >>>>>> 2. Please shutdown the pgadmin4 server through elephant icon >>>>>> 3. then try yum upgrade pgadmin4* >>>>>> >>>>>> >>>>>> If you are still getting any error message and kindly do following: >>>>>> >>>>>> 1. yum erase pgadmin4* >>>>>> 2. yum clean all >>>>>> 3. yum erase pgadmin4* >>>>>> 4. try yum make cache >>>>>> 5. yum makecache >>>>>> 6. Now install pgadmin4 through yum install pgadmin4* >>>>>> >>>>>> Kindly let us know if your issue is resolve or not? >>>>>> >>>>>> Kind Regards? >>>>>> >>>>>> >>>>>> >>>>>> On Tue, Aug 6, 2019 at 11:07 AM Wh isere wrote: >>>>>> >>>>>>> Thanks, I have tried yum upgrade pgadmin4, it is still the same. >>>>>>> >>>>>>> here is the output from previous yum update pgadmin4, and screen >>>>>>> shot of pgadmin4 attached.: >>>>>>> >>>>>>> sudo yum update pgadmin4 >>>>>>> Loaded plugins: enabled_repos_upload, package_upload, product-id, >>>>>>> search- >>>>>>> : disabled-repos, subscription-manager, tracer_upload >>>>>>> rhel-7-server-rpms | 2.0 >>>>>>> kB 00:00 >>>>>>> rhel-7-server-satellite-tools-6.5-rpms | 2.1 >>>>>>> kB 00:00 >>>>>>> Resolving Dependencies >>>>>>> --> Running transaction check >>>>>>> ---> Package pgadmin4.x86_64 0:4.8-1.rhel7 will be updated >>>>>>> ---> Package pgadmin4.x86_64 0:4.11-1.rhel7 will be an update >>>>>>> --> Finished Dependency Resolution >>>>>>> >>>>>>> Dependencies Resolved >>>>>>> >>>>>>> >>>>>>> >>>>>>> Package ArchVersion >>>>>>> Repository Size >>>>>>> >>>>>>> >>>>>>> Updating:
Re: import upload file to pgadmin get CSRF error
Hi, On Tue, Aug 6, 2019 at 11:36 AM Wh isere wrote: > Thank you! I am running pgadmin on a remote server, so there is not Gui > interface, is there command to shut down pgadmin4 server? > I also run yum upgrade pgadmin4*, but it said yum: No match. > Kindly first install GUI on remote machine and shut down pgadmin4 server. I don't think so we have any command to shutdown the server. When you will shutdown the pgadmin4 server properly and follow the steps mentioned in the previous replay properly you will not able to see older pgadmin4 4.8 version. > Thanks. > > On Tue, Aug 6, 2019 at 4:25 PM Fahar Abbas > wrote: > >> Please find attached the snapshot for pgadmin4 shutdown the server. >> >> On Tue, Aug 6, 2019 at 11:21 AM Fahar Abbas >> wrote: >> >>> Yes it's due to pgadmin4 is not properly upgrade on your system. >>> >>> Why not you try yum upgrade pgadmin4* include (*) >>> >>> Can you do following steps. >>> >>> 1. Clear you cache >>> 2. Please shutdown the pgadmin4 server through elephant icon >>> 3. then try yum upgrade pgadmin4* >>> >>> >>> If you are still getting any error message and kindly do following: >>> >>> 1. yum erase pgadmin4* >>> 2. yum clean all >>> 3. yum erase pgadmin4* >>> 4. try yum make cache >>> 5. yum makecache >>> 6. Now install pgadmin4 through yum install pgadmin4* >>> >>> Kindly let us know if your issue is resolve or not? >>> >>> Kind Regards? >>> >>> >>> >>> On Tue, Aug 6, 2019 at 11:07 AM Wh isere wrote: >>> >>>> Thanks, I have tried yum upgrade pgadmin4, it is still the same. >>>> >>>> here is the output from previous yum update pgadmin4, and screen shot >>>> of pgadmin4 attached.: >>>> >>>> sudo yum update pgadmin4 >>>> Loaded plugins: enabled_repos_upload, package_upload, product-id, >>>> search- >>>> : disabled-repos, subscription-manager, tracer_upload >>>> rhel-7-server-rpms | 2.0 kB >>>> 00:00 >>>> rhel-7-server-satellite-tools-6.5-rpms | 2.1 kB >>>> 00:00 >>>> Resolving Dependencies >>>> --> Running transaction check >>>> ---> Package pgadmin4.x86_64 0:4.8-1.rhel7 will be updated >>>> ---> Package pgadmin4.x86_64 0:4.11-1.rhel7 will be an update >>>> --> Finished Dependency Resolution >>>> >>>> Dependencies Resolved >>>> >>>> >>>> >>>> Package ArchVersion >>>> Repository Size >>>> >>>> >>>> Updating: >>>> pgadmin4 x86_64 4.11-1.rhel7 >>>> pgdg10 11 k >>>> >>>> Transaction Summary >>>> >>>> >>>> Upgrade 1 Package >>>> >>>> Total download size: 11 k >>>> Is this ok [y/d/N]: y >>>> Downloading packages: >>>> No Presto metadata available for pgdg10 >>>> pgadmin4-4.11-1.rhel7.x86_64.rpm | 11 kB >>>> 00:01 >>>> Running transaction check >>>> Running transaction test >>>> Transaction test succeeded >>>> Running transaction >>>> Updating : >>>> pgadmin4-4.11-1.rhel7.x86_64 1/2 >>>> Cleanup: >>>> pgadmin4-4.8-1.rhel7.x86_64 2/2 >>>> Uploading Package Profile >>>> Uploading Tracer Profile >>>> Verifying : >>>> pgadmin4-4.11-1.rhel7.x86_64 1/2 >>>> Verifying : >>>> pgadmin4-4.8-1.rhel7.x86_64 2/2 >>>> >>>> Updated: >>>> pgadmin4.x86_64 >>>> 0:4.11-1.rhel7 >>>> >>>> Complete! >>>> Uploading Enabled Repositories Report >>>> >>>> >>>> >>>> On Tue, Aug 6, 2019 at 3:49 PM Fahar Abbas < >>>> fahar.ab...@enterprisedb.com> wrote: >>>> >>>>> Hi, >>>>> >>>>> Can
Re: import upload file to pgadmin get CSRF error
Yes it's due to pgadmin4 is not properly upgrade on your system. Why not you try yum upgrade pgadmin4* include (*) Can you do following steps. 1. Clear you cache 2. Please shutdown the pgadmin4 server through elephant icon 3. then try yum upgrade pgadmin4* If you are still getting any error message and kindly do following: 1. yum erase pgadmin4* 2. yum clean all 3. yum erase pgadmin4* 4. try yum make cache 5. yum makecache 6. Now install pgadmin4 through yum install pgadmin4* Kindly let us know if your issue is resolve or not? Kind Regards? On Tue, Aug 6, 2019 at 11:07 AM Wh isere wrote: > Thanks, I have tried yum upgrade pgadmin4, it is still the same. > > here is the output from previous yum update pgadmin4, and screen shot of > pgadmin4 attached.: > > sudo yum update pgadmin4 > Loaded plugins: enabled_repos_upload, package_upload, product-id, search- > : disabled-repos, subscription-manager, tracer_upload > rhel-7-server-rpms | 2.0 kB > 00:00 > rhel-7-server-satellite-tools-6.5-rpms | 2.1 kB > 00:00 > Resolving Dependencies > --> Running transaction check > ---> Package pgadmin4.x86_64 0:4.8-1.rhel7 will be updated > ---> Package pgadmin4.x86_64 0:4.11-1.rhel7 will be an update > --> Finished Dependency Resolution > > Dependencies Resolved > > > > Package ArchVersionRepository > Size > > > Updating: > pgadmin4 x86_64 4.11-1.rhel7 pgdg10 > 11 k > > Transaction Summary > > > Upgrade 1 Package > > Total download size: 11 k > Is this ok [y/d/N]: y > Downloading packages: > No Presto metadata available for pgdg10 > pgadmin4-4.11-1.rhel7.x86_64.rpm | 11 kB > 00:01 > Running transaction check > Running transaction test > Transaction test succeeded > Running transaction > Updating : > pgadmin4-4.11-1.rhel7.x86_64 1/2 > Cleanup: > pgadmin4-4.8-1.rhel7.x86_64 2/2 > Uploading Package Profile > Uploading Tracer Profile > Verifying : > pgadmin4-4.11-1.rhel7.x86_64 1/2 > Verifying : > pgadmin4-4.8-1.rhel7.x86_64 2/2 > > Updated: > pgadmin4.x86_64 > 0:4.11-1.rhel7 > > Complete! > Uploading Enabled Repositories Report > > > > On Tue, Aug 6, 2019 at 3:49 PM Fahar Abbas > wrote: > >> Hi, >> >> Can you please try yum upgrade pgadmin4* and check the pgadmin4? >> >> >> On Tue, Aug 6, 2019 at 10:39 AM Wh isere wrote: >> >>> It is web browser cache we need to clean or other cache? Thanks. >>> >>> On Tue, Aug 6, 2019 at 3:27 PM Wh isere wrote: >>> >>>> Thanks. I cleaned the cache, but it is still the same. >>>> >>>> On Tue, Aug 6, 2019 at 3:18 PM Ashesh Vashi < >>>> ashesh.va...@enterprisedb.com> wrote: >>>> >>>>> Would please try to clear the cache? >>>>> >>>>> -- >>>>> >>>>> Thanks & Regards, >>>>> >>>>> Ashesh Vashi >>>>> EnterpriseDB INDIA: Enterprise PostgreSQL Company >>>>> <http://www.enterprisedb.com> >>>>> >>>>> >>>>> *http://www.linkedin.com/in/asheshvashi* >>>>> <http://www.linkedin.com/in/asheshvashi> >>>>> >>>>> >>>>> On Tue, Aug 6, 2019 at 10:47 AM Wh isere wrote: >>>>> >>>>>> I run 'yum update pgadmin4' it appears pgadmin4 already 4.11, but on >>>>>> the web interface under about it still shows 4.8. Any idea? Thanks. >>>>>> >>>>>> On Tue, Aug 6, 2019 at 3:08 PM Wh isere wrote: >>>>>> >>>>>>> Hello, we have updated pgadmin4 to 4.11 but this problem is still >>>>>>> there. Thanks. >>>>>>> >>>>>>> On Fri, Jun 28, 2019 at 3:09 PM Murtuza Zabuawala < >>>>>>> murtuza.zabuaw...@enterprisedb.com> wrote: >>>>>>> >>>>>>>> >>>>>>>> On Fri, Jun 28, 2019 at 10:18 AM Where is Where >>>>>>>> wrote: >>>>>>>> >>>>>&g
Re: import upload file to pgadmin get CSRF error
>>>>> But it doesn't seem to fix the problem.
>>>>>>>>>>>>
>>>>>>>>>>>> It will require bundling of the static files after applying the
>>>>>>>>>>> patch.
>>>>>>>>>>> Instead, you can install the pgAdmin from the nightly builds
>>>>>>>>>>> having the latest code.
>>>>>>>>>>>
>>>>>>>>>>> https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2019-06-24/
>>>>>>>>>>>
>>>>>>>>>>> * // We need to append our csrf token with dropzone's ajax
>>>>>>>>>>> request header
>>>>>>>>>>>> *
>>>>>>>>>>>>
>>>>>>>>>>>> * let csrfToken = {};
>>>>>>>>>>>> *
>>>>>>>>>>>>
>>>>>>>>>>>> * csrfToken[pgAdmin.csrf_token_header] =
>>>>>>>>>>>> pgAdmin.csrf_token;
>>>>>>>>>>>> *
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> $('div#multiple-uploads').dropzone({
>>>>>>>>>>>>
>>>>>>>>>>>> paramName: 'newfile',
>>>>>>>>>>>>
>>>>>>>>>>>> url: pgAdmin.FileUtils.fileConnector,
>>>>>>>>>>>>
>>>>>>>>>>>> *headers: csrfToken,*
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> Thanks, Junran
>>>>>>>>>>>>
>>>>>>>>>>>> On Mon, Jun 24, 2019 at 3:47 PM Khushboo Vashi <
>>>>>>>>>>>> khushboo.va...@enterprisedb.com> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> On Mon, Jun 24, 2019 at 11:13 AM Where is Where <
>>>>>>>>>>>>> whis...@gmail.com> wrote:
>>>>>>>>>>>>>
>>>>>>>>>>>>>> Hello, we are trying to import csv file to database from
>>>>>>>>>>>>>> pgadmin, but when uploading file it reports '
>>>>>>>>>>>>>> 400 Bad Request Bad Request The CSRF token is
>>>>>>>>>>>>>> missing. '
>>>>>>>>>>>>>> I looked at config.py but can't find any related setting.
>>>>>>>>>>>>>> Any idea is much appreciated.
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> This issue has already been reported and fixed. (Ref:
>>>>>>>>>>>>> https://redmine.postgresql.org/issues/4350)
>>>>>>>>>>>>> You will get the fix in the upcoming release which is
>>>>>>>>>>>>> scheduled on coming Thursday.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Thanks,
>>>>>>>>>>>>> Khushboo
>>>>>>>>>>>>>
>>>>>>>>>>>>
--
Fahar Abbas
QMG
EnterpriseDB Corporation
Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: *live:fahar.abbas*
Website: www.enterprisedb.com
Re: Bug when a column is JSON?
Hi, This fix will be available in 4.11 release today. On Thu, Jul 25, 2019 at 2:21 PM Michael Monerau wrote: > Hi, > > Just ran into this bug when trying to simply list the contents of a table: > > [image: image.png] > > And the DataOutput panel is blank. > > It definitely works on other tables, and the connection to the server is > ok (it correctly pulls out the 268 rows, and downloading the CSV works ok). > > The only difference I can see between this table and others is that it has > a "JSON" type column. > > Is this a known bug? > > Best, > Michael > -- Fahar Abbas QMG EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Re: upload large files in pgadmin
Hi Sebastian! We can not give any timeline for this and it's already in our list. Kind Regards, On Fri, Jul 19, 2019 at 5:42 PM Sebastian Wandernoth wrote: > Hi Fahar, > > Thanks for reraising the issue. I see that it has been there for 2 years > already. How are the chances for this to be fixed in the near future? > > *Gesendet:* Freitag, 19. Juli 2019 um 14:31 Uhr > *Von:* "Fahar Abbas" > *An:* "Sebastian Wandernoth" > *Cc:* "pgadmin-support lists.postgresql.org" < > pgadmin-support@lists.postgresql.org> > *Betreff:* Re: upload large files in pgadmin > Hi Sebastian! > > RM is already reported:- > > https://redmine.postgresql.org/issues/2097 > > On Fri, Jul 19, 2019 at 5:23 PM Sebastian Wandernoth > wrote: > >> Hey guys, >> >> I would like to use pgadmin4 to restore a postgres database from a backup >> file that is about 300MB in size. >> >> Both pgadmin and postgres are running in separate docker containers in >> the same pod on a kubernetes cluster. >> >> If I try to upload the file (after of course adjusting the *Maximum file >> upload size* in the preferences) it gets stuck and does not do anything. >> I also tried it locally with the same result (So it is definitely not a >> network/firewall issue). A smaller file (7MB) works without problems >> >> My suspicion is that pgadmin does not internally adjust the max file size >> even though it is showing the new number in the UI. Is it possible to >> adjust this value in the config file? >> >> Am I doing something else wrong? Does anyone have experience with such a >> setup? >> >> This is the version of pgadmin I am using: >> *Version* >> 4.10 >> *Copyright* >> Copyright (C) 2013 - 2019, The pgAdmin Development Team >> *Python Version* >> 3.7.3 (default, May 11 2019, 02:00:41) [GCC 8.3.0] >> *Flask Version* >> 1.0.2 >> >> Thanks in advance for your help >> Sebastian >> >> > > > -- > Fahar Abbas > QMG > EnterpriseDB Corporation > Phone Office: +92-51-835-8874 > Phone Direct: +92-51-8466803 > Mobile: +92-333-5409707 > Skype ID: *live:fahar.abbas* > Website: www.enterprisedb.com > -- Fahar Abbas QMG EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: upload large files in pgadmin
Hi Sebastian! RM is already reported:- https://redmine.postgresql.org/issues/2097 On Fri, Jul 19, 2019 at 5:23 PM Sebastian Wandernoth wrote: > Hey guys, > > I would like to use pgadmin4 to restore a postgres database from a backup > file that is about 300MB in size. > > Both pgadmin and postgres are running in separate docker containers in the > same pod on a kubernetes cluster. > > If I try to upload the file (after of course adjusting the *Maximum file > upload size* in the preferences) it gets stuck and does not do anything. > I also tried it locally with the same result (So it is definitely not a > network/firewall issue). A smaller file (7MB) works without problems > > My suspicion is that pgadmin does not internally adjust the max file size > even though it is showing the new number in the UI. Is it possible to > adjust this value in the config file? > > Am I doing something else wrong? Does anyone have experience with such a > setup? > > This is the version of pgadmin I am using: > *Version* > 4.10 > *Copyright* > Copyright (C) 2013 - 2019, The pgAdmin Development Team > *Python Version* > 3.7.3 (default, May 11 2019, 02:00:41) [GCC 8.3.0] > *Flask Version* > 1.0.2 > > Thanks in advance for your help > Sebastian > > -- Fahar Abbas QMG EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Save modification of the record makes error
Hi Durumdara, RM is already reported (https://redmine.postgresql.org/issues/4404) and fix will be available in next release of pgAdmin4 4.10. On Mon, Jul 1, 2019 at 5:07 PM Durumdara wrote: > Hello! > > I updated PgAdmin4 because of prior very big error (Query Tool DataBase > name was different than the real, connected DB name). > > Today I tried to edit a record. I set two string fields, and then I > clicked to save. > > This errormessage I got: > > " 'int' object has no attribute 'replace' " > > I can't edit records now... :-( > > Thank for your help! > > dd > -- Fahar Abbas QMG EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Bug
Adding pgadmin-support@lists.postgresql.org email and Removing pgsql-bugs email. Hi Faran! Can you please share the pgadmin4.log file as well? Kind regards, On Tue, Jun 25, 2019 at 2:47 PM Faran Ali wrote: > Hi, > *pgAdmin: *v4.8 > *OS: *Tried on Ubuntu 19.04/18.10/18.04 > *Server Mode: *True > *Python: *Tried Python 3.5/3.6/3.7/3.8 > > I've Installed pgAdmin from APT repository and while others can get it to > work simply I get an error in the screen attached below whenever I try to > take a backup or restore from pgAdmin > [image: image.png] > > Please let me know if you need anything else. > > Regards, > Faran. > -- Fahar Abbas QMG EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: centos 7 / pgadmin 4.7
-1.rhel7.x86_64.rpm >> | 274 kB 00:00:00 >> (3/4): >> pgadmin4-web-4.8-1.rhel7.noarch.rpm >> | 5.2 MB 00:00:02 >> (4/4): >> pgadmin4-docs-4.8-1.rhel7.noarch.rpm >> | 29 MB 00:00:27 >> >> --- >> Total >> 1.2 MB/s | 34 MB 00:00:28 >> Running transaction check >> Running transaction test >> Transaction test succeeded >> Running transaction >> Updating : >> pgadmin4-docs-4.8-1.rhel7.noarch >> 1/8 >> Updating : >> pgadmin4-web-4.8-1.rhel7.noarch >> 2/8 >> Updating : >> pgadmin4-desktop-common-4.8-1.rhel7.x86_64 >> 3/8 >> Updating : >> pgadmin4-4.8-1.rhel7.x86_64 >> 4/8 >> Cleanup: >> pgadmin4-4.7-2.rhel7.x86_64 >> 5/8 >> Cleanup: >> pgadmin4-desktop-common-4.7-2.rhel7.x86_64 >> 6/8 >> Cleanup: >> pgadmin4-web-4.7-2.rhel7.noarch >> 7/8 >> Cleanup: >> pgadmin4-docs-4.7-2.rhel7.noarch >> 8/8 >> Verifying : >> pgadmin4-desktop-common-4.8-1.rhel7.x86_64 >> 1/8 >> Verifying : >> pgadmin4-web-4.8-1.rhel7.noarch >> 2/8 >> Verifying : >> pgadmin4-4.8-1.rhel7.x86_64 >> 3/8 >> Verifying : >> pgadmin4-docs-4.8-1.rhel7.noarch >> 4/8 >> Verifying : >> pgadmin4-4.7-2.rhel7.x86_64 >> 5/8 >> Verifying : >> pgadmin4-docs-4.7-2.rhel7.noarch >> 6/8 >> Verifying : >> pgadmin4-web-4.7-2.rhel7.noarch >> 7/8 >> Verifying : >> pgadmin4-desktop-common-4.7-2.rhel7.x86_64 >> 8/8 >> >> Updated: >> pgadmin4.x86_64 0:4.8-1.rhel7pgadmin4-desktop-common.x86_64 >> 0:4.8-1.rhel7pgadmin4-docs.noarch 0:4.8-1.rhel7 >> pgadmin4-web.noarch 0:4.8-1.rhel7 >> >> Complete! >> >> >> Any help would be greatly appreciated. >> >> Do you see any error on browser console? > Please clear the cache and run the application. > >> Thanks, >> >> Alex >> >> >> Sent with ProtonMail <https://protonmail.com> Secure Email. >> >> -- Fahar Abbas QMG EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: pgAdmin v4.7
Hi, We have already fixed the issue and will be available in next 4.8 release. On Fri, May 31, 2019 at 12:10 AM Fahar Abbas wrote: > Hi Michelle, > > This is a valid issue and reproducible on my end and Here is RM ID: > https://redmine.postgresql.org/issues/4309 > > > > > On Thu, May 30, 2019 at 10:30 PM Michelle Schwan > wrote: > >> Just installed pgAdmin v4.7 from v4.6 with no issues. >> >> >> >> I found a bug. >> >> >> >> Go to Views and select SQL. Click on a view and receive an error >> message. This was not happening in v4.6. >> >> >> >> >> >> Thanks, >> >> Michelle >> >> >> > > > -- > Fahar Abbas > QMG > EnterpriseDB Corporation > Phone Office: +92-51-835-8874 > Phone Direct: +92-51-8466803 > Mobile: +92-333-5409707 > Skype ID: *live:fahar.abbas* > Website: www.enterprisedb.com > -- Fahar Abbas QMG EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: pgAdmin v4.7
Hi Michelle, This is a valid issue and reproducible on my end and Here is RM ID: https://redmine.postgresql.org/issues/4309 On Thu, May 30, 2019 at 10:30 PM Michelle Schwan wrote: > Just installed pgAdmin v4.7 from v4.6 with no issues. > > > > I found a bug. > > > > Go to Views and select SQL. Click on a view and receive an error > message. This was not happening in v4.6. > > > > > > Thanks, > > Michelle > > > -- Fahar Abbas QMG EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: *live:fahar.abbas* Website: www.enterprisedb.com
Re: Windows testing required: Updated runtime
Hi Dave! I also tested Windows installers and script error displayed and here is the RM ID: -- https://redmine.postgresql.org/issues/2542 On Thu, Jul 6, 2017 at 10:01 PM, Shira Bezalel <sh...@sfei.org> wrote: > > > On Thu, Jul 6, 2017 at 7:59 AM, Dave Page <dp...@pgadmin.org> wrote: > >> All, >> >> I've put an interim build of pgAdmin 4 at https://developer.pgadmin.o >> rg/~dpage/pgadmin4-1.5-x86.exe for Windows users. This build uses a work >> in progress patch to replace the slow Qt components with ActiveQt + the >> Microsoft web browser control to significantly improve performance. >> >> The version also includes close to 100 other bug fixes and changes, most >> noticeably performance improvements in the Query Tool that make it >> significantly faster than pgAdmin 3 with large result sets, and the ability >> to open the Query Tool and Debugger in new tabs that can be dragged onto >> different windows and therefore displays. >> >> If you have the ability, please give it a test and let me know how it >> performs. There are some known issues that we're working on: >> >> - The Query Tool History view isn't rendered correctly. >> >> - Closing a tab is now detected when there's a dirty query tool window in >> it, but closing the window containing the tab is not. >> >> - Inactive tabs have no visual definition between them. >> >> - When dragging a tab, the mouse icon changes to one with a stop sign in >> it. >> >> - If you close the last tab in a child window, it doesn't close the >> window. >> >> - Popout alerts don't display correctly. >> >> Thanks! >> >> -- >> Dave Page >> Blog: http://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EnterpriseDB UK: http://www.enterprisedb.com >> The Enterprise PostgreSQL Company >> > > Hi Dave, > > At first, I was not having the same positive experience as the others. > After installation, the "Loading pgAdmin 4 v1.5..." message with the > spinning icon just appeared indefinitely. After several minutes, I canceled > it. Then I tried it again, and got this message: > > Error loading script - /sqleditor/sqleditor > Error message > undefined > > Then I disabled my AV software, and all was well. It launched in about 11 > seconds (down from the 33 seconds I was getting on the previous version.) > > I'll test it out a little further later. > > Thank you, > Shira > > > > > -- Fahar Abbas QMG EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: syed.fahar.abbas Website: www.enterprisedb.com
