Re: How do I tell pgAdmin 4 to not harass me with pointless extra clicks every single time I want to use it?

[Dave Page]

This type of unprofessional and disrespectful message is not welcome on the
pgAdmin mailing list. It does nothing except upset and annoy the people
that have spent hundreds or thousands of hours continually improving
pgAdmin, and if anything probably makes those people at the very minimum
subconsciously push any comment you make to the back of the queue. I would
not be surprised if some of them have kill-filed you at this point.

Anyone is welcome to report a bug. Anyone is welcome to provide
constructive feedback on how pgAdmin may be improved. Anyone is welcome to
contribute patches or improvements they choose to work on. The developers
work extremely hard to continually improve pgAdmin, and constructive
feedback is critical to that.

Ultimately though, pgAdmin is free and open source. Neither it, or the
developers owe you anything or have any obligation to you whatsoever - and
they are certainly under no obligation to pay any attention to rude emails.
If you disagree, then feel free to use a different tool for managing
PostgreSQL.

If you are unable to present your feedback and suggestions in a cordial and
respectful manner, then I will remove you from the lists. You have already
been warned by one senior PostgreSQL community member.


On Sun, Sep 20, 2020 at 3:32 PM  wrote:

> This is absolutely unreal. I never wanted to have to waste my time asking
> about pgAdmin 4 ever again, but here we are...
>
> Every single time I open it, even with a dedicated browser profile which
> never gets its data cleared, and even with the special configuration
> options (requiring one to hack a file) to not ask for a stupid "master
> password", it **still** forces me to first double-click the "Servers", then
> double-click the actual "server" to get back to work. So that's four
> pointless extra clicks every time I want to use pgAdmin 4.
>
> How do I make it connect immediately? Why would anyone ever **not** want
> it to at the very least show the list of servers? Why have all this extra,
> pointless work?
>
> Needless to say, there's nothing in the "preferences" to set this. It's
> seriously mind-boggling. The only reason I've never mentioned this before
> has been that there's even worse issues that overshadowed this.
>
> Sometimes, randomly, it *does* connect immediately to the server once
> you've double-clicked the "Servers" thing. The fact that this is not
> consistent, but (apparently) random, just further confuses me and makes me
> (again) wonder if this program was designed purposely as a psychological
> experiment.
>


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

Re: How do I tell pgAdmin 4 to not harass me with pointless extra clicks every single time I want to use it?

[Dave Page]

On Mon, Sep 21, 2020 at 3:37 AM Mark Murawski 
wrote:

>
> I'm no where near an MS-Fanboy, but honestly it might have been a
> smoother life cycle with better usability had the whole thing been
> developed in C# on Mono.
>

C# on Mono would have been my preference had we started retiring pgAdmin 3
a few years earlier. However, when we did do that, one of the requirements
we set was to have pgAdmin be able to run as a web based interface so it
could run as a service in cloud environments, and that wasn't feasible with
a C#/Mono based design. Running like that, based on download stats etc, is
easily the most popular way of running pgAdmin, so I don't regret that part
of the decision.


>
> I still can't barely use pgadmin4 for my workflow, and I've been
> patiently waiting since September 2016 (1.0) to do so.


What are you waiting for exactly? If there are specific features that
prevent you from doing so, it would help to know what they are exactly.


> I've since moved
> on with my workhorse PG guis to be omnidb and datagrip, but keep up with
> the pgadmin4 updates for a just in case release that might give me a
> reason to use it again for day to day.
>
>
> On 2020-09-20 19:02, Dave Caughey wrote:
> > tutiluren,
> >
> > I think everyone understands that the usability isn't optimal.  Indeed,
> > in my son's university program, they have a course on UE design, and
> > pgAdmin is used as a case study of a suboptimal user experience (sorry,
> > don't shoot me, I'm just the messenger!)
> >
> > I've logged several feature requests relating to usability, and would
> > dearly love to see some of them get addressed.   But then I look at
> > what's in the release notes, and see that the team is working on really
> > core capabilities.  I.e., they have to support everything that
> > PostgreSQL can possibly do, most of what is fixed is way, way beyond my
> > knowledge.  As a developer of a web app I just need the most basic
> > features, whereas the pgAdmin team has to collectively understand
> > absolutely *everything* about PostgreSQL.  And in my experience as a
> > development manager, the kind of people who tend to like all the nitty
> > gritty details of databases rarely tend to have a passion for UE
> > design--different strengths and skill sets are required.   So I'm not
> > surprised that a team that can understand the complexity of something
> > like PostgreSQL doesn't agonize over optimizing the UE.
> >
> > But of course, anyone who is knowledgeable and passionate about UE
> > design is free to contribute, and perhaps make some improvements.   And
> > at that point I look down at my feet awkwardly and mutter something
> > about not having the time to immerse myself in the project, and then
> > come to the happy realization that if it works and is free, then I can
> > live with the usability rough edges.
> >
> > So... we have a product that has to encompass a mind-boggling range of
> > functionality.  Could it have better usability? yes.  Can I live with
> > it, as is? yes.
> >
> > Cheers,
> > Dave
> >
> >
> > On Sun, Sep 20, 2020 at 6:07 PM Bo Guo  > > wrote:
> >
> > tutiluren,
> >
> > I do not disagree with some of you suggestions; however, please
> present
> > your ideas professionally and with respect!
> >
> > I for one am very grateful to be able to use pgadmin for free, and
> > thankful to those who are behind this wonderful and free product we
> > come
> > to rely on.
> >
> > Bo
> >
> >
> > On 9/20/20 7:32 AM, tutilu...@tutanota.com
> >  wrote:
> >  > This is absolutely unreal. I never wanted to have to waste my time
> >  > asking about pgAdmin 4 ever again, but here we are...
> >  >
> >  > Every single time I open it, even with a dedicated browser profile
> >  > which never gets its data cleared, and even with the special
> >  > configuration options (requiring one to hack a file) to not ask
> > for a
> >  > stupid "master password", it **still** forces me to first
> > double-click
> >  > the "Servers", then double-click the actual "server" to get back
> to
> >  > work. So that's four pointless extra clicks every time I want to
> use
> >  > pgAdmin 4.
> >  >
> >  > How do I make it connect immediately? Why would anyone ever
> **not**
> >  > want it to at the very least show the list of servers? Why have
> all
> >  > this extra, pointless work?
> >  >
> >  > Needless to say, there's nothing in the "preferences" to set this.
> >  > It's seriously mind-boggling. The only reason I've never mentioned
> >  > this before has been that there's even worse issues that
> > overshadowed
> >  > this.
> >  >
> >  > Sometimes, randomly, it *does* connect immediately to the server
> > once
> >  > you've double-clicked the "Servers" thing. The fact that this is
> not
> >  > consistent, but (apparently) random, ju

Fatal Error Query

[Rowan MacKinnon]

Hi

After I install pgAdmin 4 I receive the follow error message.

[cid:image001.png@01D69059.9A8BCA70]

I have uninstalled & installed twice, but keep having the same error. Internet 
connection is fine.

Are you able to assist/advise?

Kind regards


Rowan MacKinnon
Phone: (64) 22 624 9237
Email: rowan.mackinno...@outlook.com

Re: Fatal Error Query

[Aditya Toshniwal]

Hi Rowan,

Could you please share log files having names like - .pgadmin.startup
and .pgadmin..
You'll find these files in your windows user directory.

On Mon, Sep 21, 2020 at 2:27 PM Rowan MacKinnon <
rowan.mackinno...@outlook.com> wrote:

> Hi
>
>
>
> After I install pgAdmin 4 I receive the follow error message.
>
>
>
>
>
> I have uninstalled & installed twice, but keep having the same error.
> Internet connection is fine.
>
>
>
> Are you able to assist/advise?
>
>
>
> Kind regards
>
>
>
>
>
> Rowan MacKinnon
>
> Phone: (64) 22 624 9237
>
> Email: rowan.mackinno...@outlook.com
>
>
>


-- 
Thanks,
Aditya Toshniwal
pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*

"Don't Complain about Heat, Plant a TREE"

Re: pgAdmin 4 v4.26 released

[Dave Page]

On Sat, Sep 19, 2020 at 7:21 AM Dave Page  wrote:

>
>
> On Sat, 19 Sep 2020 at 00:59, richard coleman 
> wrote:
>
>> Dave,
>>
>> Thanks for the update.  Are you going to rerelease the update with a
>> valid certificate, or at least publish the SHA256 hash for the file so that
>> we can verify that it downloaded correctly?
>>
>
> Yes, a new release is in progress already.
>

I came to the conclusion that a new release isn't warranted, as there are
no code changes, or any changes to the package contents at all; instead I
have manually signed the original installers on the build server, and then
re-pushed to the download site.

Apologies for any inconvenience.


>
>
>> Thanks again,
>>
>> rik.
>>
>> On Fri, Sep 18, 2020 at 4:45 AM Dave Page  wrote:
>>
>>> Hi
>>>
>>> On Thu, Sep 17, 2020 at 4:22 PM Dave Page  wrote:
>>>


 On Thu, Sep 17, 2020 at 4:18 PM richard coleman <
 rcoleman.ascen...@gmail.com> wrote:

> Akshay,
>
> Just downloaded pgadmin4-4.26-x64.exe from the official web site.
> When I go to install it comes up with an "unknown publisher".
>
> Is this legit?
>

 I'm seeing that too - there doesn't seem to be a digital signature on
 the installer.

>>>
>>> So to the original question, yes, it is legit. The certificate expired
>>> :-(
>>>
>>>

 I have to wonder a) how that happened without the build failing,

>>>
>>> That happened because all our build scripts will ignore certificate not
>>> found type errors, throwing out a warning to the (very long) build log
>>> instead. Microsoft's tools don't give a separate error for expired
>>> certificates - they have a generic "No suitable certificate found" one.
>>>
>>> It does it that way because individual developers don't have code
>>> signing certificates (they're expensive, a pain to get, and we don't want
>>> random ones with our name on them in existence, or to have lots of people
>>> with access to the one we use). Obviously the developers need to be able to
>>> build, even though they don't have a CSC.
>>>
>>> --
>>> Dave Page
>>> Blog: http://pgsnake.blogspot.com
>>> Twitter: @pgsnake
>>>
>>> EDB: http://www.enterprisedb.com
>>>
>>>
>>>
>>>
>>
>> --
> --
> Dave Page
> https://pgsnake.blogspot.com
>
> EDB Postgres
> https://www.enterprisedb.com
>


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

EDB: http://www.enterprisedb.com

Re: How do I tell pgAdmin 4 to not harass me with pointless extra clicks every single time I want to use it?

[Mark Murawski]

On 2020-09-21 04:30, Dave Page wrote:




What are you waiting for exactly? If there are specific features that 
prevent you from doing so, it would help to know what they are exactly.


Hi Dave,

The first thing on my list would be having pgadmin4 consistently working 
on Linux (Debian) without having to come to the mailing list every time 
for support.


Fresh apt-get install pgadmin4/buster-pgdg


pgadmin4:
  Installed: 4.25-1.pgdg100+1
  Candidate: 4.25-1.pgdg100+1
  Version table:
 *** 4.25-1.pgdg100+1 500
500 http://apt.postgresql.org/pub/repos/apt buster-pgdg/main 
amd64 Packages

100 /var/lib/dpkg/status

markm {~} kobaz$ pgadmin4
QCoreApplication::applicationFilePath: Please instantiate the 
QApplication object first
QCoreApplication::applicationFilePath: Please instantiate the 
QApplication object first

QStandardPaths: XDG_RUNTIME_DIR not set, defaulting to '/tmp/runtime-kobaz'
Semaphore name: "pgadmin4-kobaz-3ed67051214d25124b2c63f3117290d1-sema"
Shared memory segment name: 
"pgadmin4-kobaz-3ed67051214d25124b2c63f3117290d1-shmem"
Python path: 
"/home/kobaz/.virtualenvs/pgadmin4/lib/python3.4/site-packages:/usr/lib/python3/dist-packages"

Python Home:  ""
Webapp path:  "/usr/share/pgadmin4/web/pgAdmin4.py"
Failed to connect to the server: "Connection refused" - request URL: 
"http://127.0.0.1:37205/misc/ping?key=05bc319b-a240-4a10-8463-80c2fb86a0a2"; 
.
Failed to connect to the server: "Connection refused" - request URL: 
"http://127.0.0.1:37205/misc/ping?key=05bc319b-a240-4a10-8463-80c2fb86a0a2"; 
.
Failed to connect to the server: "Connection refused" - request URL: 
"http://127.0.0.1:37205/misc/ping?key=05bc319b-a240-4a10-8463-80c2fb86a0a2"; 
.
Failed to connect to the server: "Connection refused" - request URL: 
"http://127.0.0.1:37205/misc/ping?key=05bc319b-a240-4a10-8463-80c2fb86a0a2"; 
.

Re: How do I tell pgAdmin 4 to not harass me with pointless extra clicks every single time I want to use it?

[Dave Page]

Hi

On Mon, Sep 21, 2020 at 12:23 PM Mark Murawski 
wrote:

> On 2020-09-21 04:30, Dave Page wrote:
> >
>
> > What are you waiting for exactly? If there are specific features that
> > prevent you from doing so, it would help to know what they are exactly.
>
> Hi Dave,
>
> The first thing on my list would be having pgadmin4 consistently working
> on Linux (Debian) without having to come to the mailing list every time
> for support.
>
> Fresh apt-get install pgadmin4/buster-pgdg
>
>
> pgadmin4:
>Installed: 4.25-1.pgdg100+1
>Candidate: 4.25-1.pgdg100+1
>Version table:
>   *** 4.25-1.pgdg100+1 500
>  500 http://apt.postgresql.org/pub/repos/apt buster-pgdg/main
> amd64 Packages
>  100 /var/lib/dpkg/status
>

Please try using the packages the pgAdmin development team produce. We
started building them a few releases ago because of issues such as these
that were not getting resolved.

See https://www.pgadmin.org/download/pgadmin-4-apt/

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

EDB: http://www.enterprisedb.com

Re: How do I tell pgAdmin 4 to not harass me with pointless extra clicks every single time I want to use it?

[Christoph Berg]

Re: Dave Page
> Please try using the packages the pgAdmin development team produce. We
> started building them a few releases ago because of issues such as these
> that were not getting resolved.

It's also true that pgadmin is the only package that needs this level
of nannying from packagers, and you aren't exactly making our life
easier by requiring the latest and greatest versions of all
dependencies.

Christoph

Re: How do I tell pgAdmin 4 to not harass me with pointless extra clicks every single time I want to use it?

[Dave Page]

On Mon, Sep 21, 2020 at 1:35 PM Christoph Berg  wrote:

> Re: Dave Page
> > Please try using the packages the pgAdmin development team produce. We
> > started building them a few releases ago because of issues such as these
> > that were not getting resolved.
>
> It's also true that pgadmin is the only package that needs this level
> of nannying from packagers, and you aren't exactly making our life
> easier by requiring the latest and greatest versions of all
> dependencies.
>

I believe that only happened once (with psycopg2), outside of security
related updates.

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

EDB: http://www.enterprisedb.com

Re: pgAdmin 4 v4.26 released

[Cherio]

Dave,

Could you please confirm that the issue only affects the Windows install
and not the other ways of setting up pgAdmin.
My team is relying on the Python Wheel setup we run on Linux.

Thank you.

On Mon, Sep 21, 2020 at 6:09 AM Dave Page  wrote:

>
>
> On Sat, Sep 19, 2020 at 7:21 AM Dave Page  wrote:
>
>>
>>
>> On Sat, 19 Sep 2020 at 00:59, richard coleman <
>> rcoleman.ascen...@gmail.com> wrote:
>>
>>> Dave,
>>>
>>> Thanks for the update.  Are you going to rerelease the update with a
>>> valid certificate, or at least publish the SHA256 hash for the file so that
>>> we can verify that it downloaded correctly?
>>>
>>
>> Yes, a new release is in progress already.
>>
>
> I came to the conclusion that a new release isn't warranted, as there are
> no code changes, or any changes to the package contents at all; instead I
> have manually signed the original installers on the build server, and then
> re-pushed to the download site.
>
> Apologies for any inconvenience.
>
>
>>
>>
>>> Thanks again,
>>>
>>> rik.
>>>
>>> On Fri, Sep 18, 2020 at 4:45 AM Dave Page  wrote:
>>>
 Hi

 On Thu, Sep 17, 2020 at 4:22 PM Dave Page  wrote:

>
>
> On Thu, Sep 17, 2020 at 4:18 PM richard coleman <
> rcoleman.ascen...@gmail.com> wrote:
>
>> Akshay,
>>
>> Just downloaded pgadmin4-4.26-x64.exe from the official web site.
>> When I go to install it comes up with an "unknown publisher".
>>
>> Is this legit?
>>
>
> I'm seeing that too - there doesn't seem to be a digital signature on
> the installer.
>

 So to the original question, yes, it is legit. The certificate expired
 :-(


>
> I have to wonder a) how that happened without the build failing,
>

 That happened because all our build scripts will ignore certificate not
 found type errors, throwing out a warning to the (very long) build log
 instead. Microsoft's tools don't give a separate error for expired
 certificates - they have a generic "No suitable certificate found" one.

 It does it that way because individual developers don't have code
 signing certificates (they're expensive, a pain to get, and we don't want
 random ones with our name on them in existence, or to have lots of people
 with access to the one we use). Obviously the developers need to be able to
 build, even though they don't have a CSC.

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

 EDB: http://www.enterprisedb.com




>>>
>>> --
>> --
>> Dave Page
>> https://pgsnake.blogspot.com
>>
>> EDB Postgres
>> https://www.enterprisedb.com
>>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EDB: http://www.enterprisedb.com
>
>