Re: pgAdmin4 won't start after OS upgrade

[Dave Page]

Please post your question to a new thread rather than replying to an
existing one so people don't get confused.

Thanks.

On Wed, Sep 2, 2020 at 1:58 AM Bo Guo  wrote:

> Hi there,
>
> pgAdmin4 acted up today when I start using it mid afternoon - I was
> presented a "blank" page after login (see image below).  We tried different
> browsers on different OS with the same issue.  Please kindly advise.
>
> My server is Ubuntu 18.04 and here is the content of file
> "/etc/apt/sources.list.d/pgdg.list"
>
> deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
>
> On 9/1/20 9:07 AM, Dave Page wrote:
>
>
>
> On Tue, Sep 1, 2020 at 5:03 PM Ray O'Donnell  wrote:
>
>> On 01/09/2020 16:58, Dave Page wrote:
>> > Hi
>> >
>> > On Tue, Sep 1, 2020 at 4:33 PM Ray O'Donnell > > > wrote:
>> >
>> > Hi all,
>> >
>> > I upgraded my laptop yesterday from Debian 9 to 10 (Buster), and now
>> > pgAdmin4 won't start. It tries to start for a while, and then I get
>> a
>> > little dialog saying "An error occurred initialising the pgAdmin
>> server:
>> > Failed to launch the application server, server thread exiting."
>>
>> 
>>
>> >
>> >
>> > Probably due to the library differences in stretch vs. buster.
>> >
>> > I would remove the existing pgAdmin packages with dpkg, then
>> > edit /etc/apt/sources.list.d/pgadmin4.list and correct the URL (change
>> > stretch to buster). Then do an apt get update before installing pgAdmin
>> > again.
>>
>> Hi Dave,
>>
>> Thanks for responding so quickly. I should have been clearer - I did
>> that before the OS upgrade, going for the big-bang approach to the
>> upgrade (yes, I know that that's living dangerously!), so my current
>> installation is from the buster repo. I assumed that the pgAdmin and
>> Python libraries would have been upgraded along with everything else
>> when I did the OS upgrade - was I wrong?
>>
>
> I don't know if dist-upgrade would have dealt with pgAdmin as well or not.
> It's possible there's some dependency or other missing now though I guess,
> so it probably wouldn't hurt to uninstall and then reinstall the packages.
>
> If that doesn't work, try running the pgAdmin binary from the command line
> and see if it complains about anything that's missing.
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EDB: http://www.enterprisedb.com
>
> --
> Regards,
>
> Bo Guo, PhD, PE
> President
> Gistic Research, Inc.
> 2033 E Warner Rd Ste 105
> Tempe, AZ 85284www.gisticinc.comwww.youtube.com/linearbench
> Office: 480-656-9962
> Cell: 602-570-4697
>
>

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: http://www.enterprisedb.com

Re: pgAdmin4 won't start after OS upgrade

[Dave Page]

On Tue, Sep 1, 2020 at 5:28 PM Ray O'Donnell  wrote:

> On 01/09/2020 17:07, Dave Page wrote:
> >
> >
> > On Tue, Sep 1, 2020 at 5:03 PM Ray O'Donnell  > > wrote:
> >
> > Hi Dave,
> >
> > Thanks for responding so quickly. I should have been clearer - I did
> > that before the OS upgrade, going for the big-bang approach to the
> > upgrade (yes, I know that that's living dangerously!), so my current
> > installation is from the buster repo. I assumed that the pgAdmin and
> > Python libraries would have been upgraded along with everything else
> > when I did the OS upgrade - was I wrong?
> >
> >
> > I don't know if dist-upgrade would have dealt with pgAdmin as well or
> > not. It's possible there's some dependency or other missing now though I
> > guess, so it probably wouldn't hurt to uninstall and then reinstall the
> > packages.
> >
> > If that doesn't work, try running the pgAdmin binary from the command
> > line and see if it complains about anything that's missing.
>
> I removed (dpkg --purge) the packages, and reinstalled them:
>
> rod@rambo:~$ sudo apt install pgadmin4-server pgadmin4-desktop
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> The following NEW packages will be installed:
>   pgadmin4-desktop pgadmin4-server
> 0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.
> Need to get 67.8 MB of archives.
> After this operation, 0 B of additional disk space will be used.
> Get:1 https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/buster
> pgadmin4/main amd64 pgadmin4-server amd64 4.25 [67.4 MB]
> Get:2 https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/buster
> pgadmin4/main amd64 pgadmin4-desktop amd64 4.25 [384 kB]
>
> Fetched 67.8 MB in 15s (4,554 kB/s)
>
>
> Selecting previously unselected package pgadmin4-server.
> (Reading database ... 476665 files and directories currently installed.)
> Preparing to unpack .../pgadmin4-server_4.25_amd64.deb ...
> Unpacking pgadmin4-server (4.25) ...
> Selecting previously unselected package pgadmin4-desktop.
> Preparing to unpack .../pgadmin4-desktop_4.25_amd64.deb ...
> Unpacking pgadmin4-desktop (4.25) ...
> Setting up pgadmin4-server (4.25) ...
> Setting up pgadmin4-desktop (4.25) ...
> Processing triggers for mime-support (3.62) ...
> Processing triggers for desktop-file-utils (0.23-4) ...
>
> I then tried running it from the command line as you suggested:
>
> rod@rambo:~$ cd /usr/pgadmin4/bin/
> rod@rambo:/usr/pgadmin4/bin$ ls -l
> total 600
> -rwxr-xr-x 1 root root 613792 Aug 18 13:54 pgadmin4
> rod@rambo:/usr/pgadmin4/bin$ ./pgadmin4
> QCoreApplication::applicationFilePath: Please instantiate the
> QApplication object first
> QCoreApplication::applicationFilePath: Please instantiate the
> QApplication object first
> Semaphore name: "pgadmin4-rod-ee77a0244675220dc7dad994b4311b50-sema"
> Shared memory segment name:
> "pgadmin4-rod-ee77a0244675220dc7dad994b4311b50-shmem"
> Python path:
>
> "/home/rod/.local/lib/python3.5/site-packages:/usr/pgadmin4/venv/lib/python3.7:/usr/lib/python3.7/lib-dynload:/usr/pgadmin4/venv/lib/python3.7/site-packages:/home/rod/.local/lib/python3.5"
>
> Python Home:  "/usr/pgadmin4/venv"
> Webapp path:  "/usr/pgadmin4/web/pgAdmin4.py"
> "Failed to launch the application server, server thread exiting."
>
> One thing caught my eye: the Python path in the above output includes
> both Python 3.5 and 3.7 stuff... Any thoughts?
>

Hmm, yeah - looks like you may have a Python installation in
/home/rod/.local/lib/python3.5 that got into the path?

Try temporarily moving it out of the way and see if that helps. Also, check
in ~/.config/pgadmin/pgadmin4.conf to see if there's a PythonPath key
that's confusing things.

See https://www.pgadmin.org/docs/pgadmin4/4.25/desktop_deployment.html for
more info.

FYI, our Ubuntu packages ship with a virtual environment in
/usr/pgadmin4/venv/ which is based on the system install of Python 3.7.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: http://www.enterprisedb.com

Vá: pgadmin 4.25 version - fix port number

[Polgár Benedek]

Dear Joshi!

Thank you very much!

A saját LG Mobile-ról küldve

-- Eredeti üzenet--
Feladó: Akshay Joshi
Dátum: 2020. szept. 2., Sze 7:12
Címzett: Polgár Benedek;
Másolat: richard coleman;pgadmin-support@lists.postgresql.org;
Tárgy:Re: pgadmin 4.25 version - fix port number

Hi

We have fixed this weird issue. It will be part of the release on 19th 
September but if you want to test it, download and install the nightly build 
from https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2020-09-02/

On Wed, Sep 2, 2020 at 3:34 AM Polgár Benedek 
mailto:polgar.bene...@otpmobil.com>> wrote:
Dear Rik!
Thanks!
I created ticket: https://redmine.postgresql.org/issues/5798
then I found other task with similar error: 
https://redmine.postgresql.org/issues/5773

___
Best Regards:

Benedek Polgár | System administrator | 
polgar.bene...@otpmobil.com

[cid:1744d3a14a14ce8e91]

From: richard coleman 
mailto:rcoleman.ascen...@gmail.com>>
Sent: 01 September 2020 22:40
To: Polgár Benedek 
mailto:polgar.bene...@otpmobil.com>>
Cc: 
pgadmin-support@lists.postgresql.org
Subject: Re: pgadmin 4.25 version - fix port number

Polgár,

Well that is annoying.  I was just wondering if it was related to bug #5783 ( 
https://redmine.postgresql.org/issues/5783#change-23810 ).  You should probably 
gile a bug report in the redmine system.

Best of luck,

rik.

On Tue, Sep 1, 2020 at 4:26 PM Polgár Benedek 
mailto:polgar.bene...@otpmobil.com>> wrote:
Dear Rik,

I set 58505 port number in configure menu.

When start pgadmin 4 server, it generate random port number, for example: 59860
When use "new pgadmin4 window" from taskbar, use the previous random port 
number, 59860

But i want that the pgadmin 4 server use the 58505 port number.

Every time, when start pgadmin 4 server (after OS restart, or pagadmin server 
stop), it generate other random port number.

___
Best Regards:

Benedek Polgár | System administrator | 
polgar.bene...@otpmobil.com

[cid:1744d3a14a14ce8e91]

From: richard coleman 
mailto:rcoleman.ascen...@gmail.com>>
Sent: 01 September 2020 21:43
To: Polgár Benedek 
mailto:polgar.bene...@otpmobil.com>>
Cc: 
pgadmin-support@lists.postgresql.org
Subject: Re: pgadmin 4.25 version - fix port number


Polgár,

When you first start pgAdmin?
When you use the "New pgAdmin 4 window..." option from the taskbar?
Or both?

Thanks,

rik.

On Tue, Sep 1, 2020 at 3:33 PM Polgár Benedek 
mailto:polgar.bene...@otpmobil.com>> wrote:
Dear Support Team!

The fixed port number config is not working in pgadmin 4.25 version.
Please help me!
Thank you!

Attached printscreen.

___
Best Regards:

Benedek Polgár | System administrator | 
polgar.bene...@otpmobil.com

[cid:1744d3a14a14ce8e91]



--
Thanks & Regards
Akshay Joshi
pgAdmin Hacker | Sr. Software Architect
EDB Postgres
Mobile: +91 976-788-8246

Query editor lagging in 4.25

[androxkentaki]

Since couple of days I have noticed significant delays in the pgAdmin's
response.

Lags are noticed generally in query editor. SQL code from query id
displayed after 2-3 sec after scrolling down. It also appears even when I
am typing SQL  on keyboard (typed words are displayed on screen with 1s
delay).



Hardware id OK, I don’t see any RAM or CPU mass usage. Even other browser
tabs are working without aby lag’s. It is happening only in pgAdmin.

Any idea what could be wrong?



(pgAdmin v 4.25 x86, running on PC with W10 Pro 64bit, 32GB RAM, i7-6700K
and SSD and in Firefox 80.0.1)


-- 
Z wyrazami szacunku
Andrzej Gerasimuk

Re: pgAdmin4 won't start after OS upgrade

[Ray O'Donnell]

On 02/09/2020 08:50, Dave Page wrote:
> 
> 
> On Tue, Sep 1, 2020 at 5:28 PM Ray O'Donnell  > wrote:



> One thing caught my eye: the Python path in the above output includes
> both Python 3.5 and 3.7 stuff... Any thoughts?
> 
> 
> Hmm, yeah - looks like you may have a Python installation in
> /home/rod/.local/lib/python3.5 that got into the path?
> 
> Try temporarily moving it out of the way and see if that helps. Also,
> check in ~/.config/pgadmin/pgadmin4.conf to see if there's a PythonPath
> key that's confusing things.

That sorted it! I renamed /home/rod/.local/lib/python3.5, and pgAdmin
was then able to start.

I looked into  ~/.config/pgadmin/pgadmin4.conf as you suggested, and
there is indeed a PythonPath line:

PythonPath="/home/rod/.local/lib/python3.5;/home/rod/.local/lib/python3.5/site-packages"

Can I safely delete this line?

I think the Python 3.5 installation is cruft from historical
installations of pgAdmin4, before the deb packages became available...
I'll leave it there for the moment, and if nothing else breaks I'll
eventually delete it.

Thanks a million for your help!

Ray.


-- 
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: pgAdmin4 won't start after OS upgrade

[Dave Page]

On Wed, Sep 2, 2020 at 1:11 PM Ray O'Donnell  wrote:

> On 02/09/2020 08:50, Dave Page wrote:
> >
> >
> > On Tue, Sep 1, 2020 at 5:28 PM Ray O'Donnell  > > wrote:
>
> 
>
> > One thing caught my eye: the Python path in the above output includes
> > both Python 3.5 and 3.7 stuff... Any thoughts?
> >
> >
> > Hmm, yeah - looks like you may have a Python installation in
> > /home/rod/.local/lib/python3.5 that got into the path?
> >
> > Try temporarily moving it out of the way and see if that helps. Also,
> > check in ~/.config/pgadmin/pgadmin4.conf to see if there's a PythonPath
> > key that's confusing things.
>
> That sorted it! I renamed /home/rod/.local/lib/python3.5, and pgAdmin
> was then able to start.
>

\o/


>
> I looked into  ~/.config/pgadmin/pgadmin4.conf as you suggested, and
> there is indeed a PythonPath line:
>
>
> PythonPath="/home/rod/.local/lib/python3.5;/home/rod/.local/lib/python3.5/site-packages"
>
> Can I safely delete this line?
>

Yes.


>
> I think the Python 3.5 installation is cruft from historical
> installations of pgAdmin4, before the deb packages became available...
> I'll leave it there for the moment, and if nothing else breaks I'll
> eventually delete it.
>
> Thanks a million for your help!
>

You're welcome.


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: http://www.enterprisedb.com

pgAdmin4 presents blank screen after login

[Bo Guo]

I am reposting my yesterday's query as a separate thread per Dave's 
advise.  Please let me know if I should try to download and install the 
newer release that is targeted to Sept 19th.  Thanks!


   Hi there,

   pgAdmin4 acted up today when I start using it mid afternoon - I was
   presented a "blank" page after login (see image below).  We tried
   different browsers on different OS with the same issue.  Please
   kindly advise.

   My server is Ubuntu 18.04 and here is the content of file
   "/etc/apt/sources.list.d/pgdg.list"

   deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main

   Bo

Re: Critical bug: pgAdmin v4.25 has started ignoring my "Browser Command" which completely cripples me and makes me unable to manage my PostgreSQL database.

[Darren Duncan]

On 2020-08-28 8:28 p.m., tutilu...@tutanota.com wrote:
That's... not what I've been saying. If you don't recognize that Chrome/Firefox 
are spyware, you *are* objectively wrong. There's just no two ways about it. Are 
you astroturfing for Google/Mozilla (it's almost pointless to even mention 
Mozilla at all anymore because they are owned by Google)? Why persist in 
defending this evil mega corporation's horrific treatment of your security?


You haven't actually explained what the harm here is.  So what if Chrome or 
Firefox "spy" on you.  What is an *actual* harm you have suffered or expect to 
suffer because of using those browsers?  What would they do with what they learn 
that would cause you actual harm?


I've already jumped through tons of hoops and wasted tons of time and effort 
sending messages to this mailing list. I'm not going to sit and "file bugs" on 
top of that, doubtlessly requiring me to jump through even more hoops. I'm not a 
pgAdmin developer. Every bug I've ever managed to file in the past for any 
project has been ignored. FOSS developers hate bug reports and make it 
obnoxiously difficult to submit them. This is what I learned many, many years ago.


Its already established that filing bugs is the only valid way to get a problem 
solved.  So if you're wasting your time continuing to send messages to this 
mailing list rather than filing the bugs, then you should have spent the time 
filing the bugs instead.  That's the only way your pgAdmin problems would get fixed.


-- Darren Duncan

How to grant on all tables in pgAdmin4?

[QA Collective]

Hello,

I hope I've got the correct list for the pgAdmin4 web tool?

I just wanted to ask, how is it possible via pgAdmin4 UI to execute a
command like:

GRANT SELECT ON ALL TABLES IN SCHEMA abc TO "viewer";

When I went to use the Grant Wizard, I selected the tickbox for all tables,
but that resulted in SQL which granted select on each individual
table...which isn't great for a database you expect to grow in tables in
future.  Ideally, this would grant select on all tables as per the command
above.

Then of course, there is the high chance I've missed something - given I'm
relatively new to all of this.

Andrew

Re: pgAdmin4 presents blank screen after login

[Khushboo Vashi]

Hi,

Please enable logging and send the pgAdmin4.log file. Please refer
https://www.pgadmin.org/faq/#8 to enable logging.
Also, provide the browser console logs if you get any errors there.

Thanks,
Khushboo

On Wed, Sep 2, 2020 at 9:02 PM Bo Guo  wrote:

> I am reposting my yesterday's query as a separate thread per Dave's
> advise.  Please let me know if I should try to download and install the
> newer release that is targeted to Sept 19th.  Thanks!
>
>> Hi there,
>>
>> pgAdmin4 acted up today when I start using it mid afternoon - I was
>> presented a "blank" page after login (see image below).  We tried different
>> browsers on different OS with the same issue.  Please kindly advise.
>>
>> My server is Ubuntu 18.04 and here is the content of file
>> "/etc/apt/sources.list.d/pgdg.list"
>>
>> deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
>>
>> Bo
>>
>