Re: Issue 5404

[Akshay Joshi]

Hi Michael

We will try our best to include it in the next release.

On Tue, Mar 2, 2021 at 7:20 PM Michael Shapiro  wrote:

> Any word on this issue?
>
> https://redmine.postgresql.org/issues/5404
>


-- 
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres *

*Mobile: +91 976-788-8246*

Re: PGadmin Support

[Redoute]

Am 03.03.2021 um 08:12 schrieb Hany shebl:

> I attached the image of the issue.

Typo? Is your user name "mysetry_visitor2" or "mystery_visitor2"?

Possible packaging problem with gssapi

[Shaheed Haque]

Hi,

I *think* there is something not quite right with the pgAdmin4 packaging as
regards gssapi, which I assume is related to the new Kerberos support in
4.30. When I try to deploy our software, which has a dependency on
pgAdmin4, I see something like this:

$ sudo pip install ...blah...our stuff...blah...
...
Collecting pgadmin4
 Downloading pgadmin4-5.0-py3-none-any.whl (97.3 MB)
...
Collecting gssapi==1.6.*
 Downloading gssapi-1.6.12.tar.gz (1.1 MB)
   ERROR: Command errored out with exit status 1:
...
   /bin/sh: 1: krb5-config: not found
   In distributed package, building from C files...
  ...
   subprocess.CalledProcessError: Command 'krb5-config --libs gssapi'
returned non-zero exit status 127.
   
WARNING: Discarding
https://files.pythonhosted.org/packages/c2/77/7cba9c5945d4d42d54ed1fb2a0bd8095d629548743198fa47ed6c1167846/gssapi-1.6.12.tar.gz#sha256=16ed3b5d7fc37683be27f34a2a6
5062cb11d815d019bb2e89ffeb395576e51c8 (from https://pypi.org/simple/gssapi/)
(requires-python:>=3.6.*). Command errored out with exit status 1: python
setup.py egg_info Check the logs for full command output.
 Downloading gssapi-1.6.11.tar.gz (1.1 MB)
...same error..
 Downloading gssapi-1.6.10.tar.gz (1.1 MB)
...same error..
 Downloading gssapi-1.6.9.tar.gz (1.1 MB)
...same error..
 Downloading gssapi-1.6.5.tar.gz (1.1 MB)
...same error..
 Downloading gssapi-1.6.2.tar.gz (1.1 MB)
...same error..
 Downloading gssapi-1.6.1.tar.gz (1.1 MB)
...same error..
 Downloading gssapi-1.6.0.tar.gz (1.1 MB)
...same error..
Collecting pgadmin4
 Downloading pgadmin4-4.30-py3-none-any.whl (92.7 MB)

At some level, this is a dependency issue for gsslib, not pgadmin4, but
OTOH, I'm not using Kerberos so it is kind of annoying.

[What is worse is that, because - I think - of the dependency pinning
approach that pgAdmin4 uses, the above downgrade to pgadmin4.30 is not the
end of the story: I actually end up all the way back on pgadmin4.25, which
is even more annoying, if not downright dangerous].

I'm not sure if there is a way to make the gsslib dependency
optional/failsafe?

Thanks, Shaheed

Re: Possible packaging problem with gssapi

[Dave Page]

Hi

On Wed, Mar 3, 2021 at 2:33 PM Shaheed Haque  wrote:

> Hi,
>
> I *think* there is something not quite right with the pgAdmin4 packaging
> as regards gssapi, which I assume is related to the new Kerberos support in
> 4.30. When I try to deploy our software, which has a dependency on
> pgAdmin4, I see something like this:
>
> $ sudo pip install ...blah...our stuff...blah...
> ...
> Collecting pgadmin4
>  Downloading pgadmin4-5.0-py3-none-any.whl (97.3 MB)
> ...
> Collecting gssapi==1.6.*
>  Downloading gssapi-1.6.12.tar.gz (1.1 MB)
>ERROR: Command errored out with exit status 1:
> ...
>/bin/sh: 1: krb5-config: not found
>In distributed package, building from C files...
>   ...
>subprocess.CalledProcessError: Command 'krb5-config --libs gssapi'
> returned non-zero exit status 127.
>
> WARNING: Discarding
> https://files.pythonhosted.org/packages/c2/77/7cba9c5945d4d42d54ed1fb2a0bd8095d629548743198fa47ed6c1167846/gssapi-1.6.12.tar.gz#sha256=16ed3b5d7fc37683be27f34a2a6
> 5062cb11d815d019bb2e89ffeb395576e51c8 (from
> https://pypi.org/simple/gssapi/) (requires-python:>=3.6.*). Command
> errored out with exit status 1: python setup.py egg_info Check the logs for
> full command output.
>  Downloading gssapi-1.6.11.tar.gz (1.1 MB)
> ...same error..
>  Downloading gssapi-1.6.10.tar.gz (1.1 MB)
> ...same error..
>  Downloading gssapi-1.6.9.tar.gz (1.1 MB)
> ...same error..
>  Downloading gssapi-1.6.5.tar.gz (1.1 MB)
> ...same error..
>  Downloading gssapi-1.6.2.tar.gz (1.1 MB)
> ...same error..
>  Downloading gssapi-1.6.1.tar.gz (1.1 MB)
> ...same error..
>  Downloading gssapi-1.6.0.tar.gz (1.1 MB)
> ...same error..
> Collecting pgadmin4
>  Downloading pgadmin4-4.30-py3-none-any.whl (92.7 MB)
>
> At some level, this is a dependency issue for gsslib, not pgadmin4, but
> OTOH, I'm not using Kerberos so it is kind of annoying.
>

Right - it is caused by gssapi, which will be built from source if there's
no binary wheel available for your platform. It's not clear what platform
you're on, but installing the krb5-devel (Redhat/CentOS/Fedora)
or libkrb5-dev (Debian/Ubuntu) should solve the build issue.


>
> [What is worse is that, because - I think - of the dependency pinning
> approach that pgAdmin4 uses, the above downgrade to pgadmin4.30 is not the
> end of the story: I actually end up all the way back on pgadmin4.25, which
> is even more annoying, if not downright dangerous].
>

I'm not sure I understand the issue there. What prevents you from going
back to 4.29?


>
> I'm not sure if there is a way to make the gsslib dependency
> optional/failsafe?
>

I'd need to dive into it some more. There are "extras", but from what I can
see these have to be explicitly installed. Ideally we want something that
will try to install gssapi automatically, but not get upset if it fails.

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

EDB: http://www.enterprisedb.com

Re: Possible packaging problem with gssapi

[Shaheed Haque]

Hi,

On Wed, 3 Mar 2021 at 14:42, Dave Page  wrote:

> Hi
>
> On Wed, Mar 3, 2021 at 2:33 PM Shaheed Haque 
> wrote:
>
>> Hi,
>>
>> I *think* there is something not quite right with the pgAdmin4 packaging
>> as regards gssapi, which I assume is related to the new Kerberos support in
>> 4.30. When I try to deploy our software, which has a dependency on
>> pgAdmin4, I see something like this:
>>
>> $ sudo pip install ...blah...our stuff...blah...
>> ...
>> Collecting pgadmin4
>>  Downloading pgadmin4-5.0-py3-none-any.whl (97.3 MB)
>> ...
>> Collecting gssapi==1.6.*
>>  Downloading gssapi-1.6.12.tar.gz (1.1 MB)
>>ERROR: Command errored out with exit status 1:
>> ...
>>/bin/sh: 1: krb5-config: not found
>>In distributed package, building from C files...
>>   ...
>>subprocess.CalledProcessError: Command 'krb5-config --libs gssapi'
>> returned non-zero exit status 127.
>>
>> WARNING: Discarding
>> https://files.pythonhosted.org/packages/c2/77/7cba9c5945d4d42d54ed1fb2a0bd8095d629548743198fa47ed6c1167846/gssapi-1.6.12.tar.gz#sha256=16ed3b5d7fc37683be27f34a2a6
>> 5062cb11d815d019bb2e89ffeb395576e51c8 (from
>> https://pypi.org/simple/gssapi/) (requires-python:>=3.6.*). Command
>> errored out with exit status 1: python setup.py egg_info Check the logs for
>> full command output.
>>  Downloading gssapi-1.6.11.tar.gz (1.1 MB)
>> ...same error..
>>  Downloading gssapi-1.6.10.tar.gz (1.1 MB)
>> ...same error..
>>  Downloading gssapi-1.6.9.tar.gz (1.1 MB)
>> ...same error..
>>  Downloading gssapi-1.6.5.tar.gz (1.1 MB)
>> ...same error..
>>  Downloading gssapi-1.6.2.tar.gz (1.1 MB)
>> ...same error..
>>  Downloading gssapi-1.6.1.tar.gz (1.1 MB)
>> ...same error..
>>  Downloading gssapi-1.6.0.tar.gz (1.1 MB)
>> ...same error..
>> Collecting pgadmin4
>>  Downloading pgadmin4-4.30-py3-none-any.whl (92.7 MB)
>>
>> At some level, this is a dependency issue for gsslib, not pgadmin4, but
>> OTOH, I'm not using Kerberos so it is kind of annoying.
>>
>
> Right - it is caused by gssapi, which will be built from source if there's
> no binary wheel available for your platform. It's not clear what platform
> you're on, but installing the krb5-devel (Redhat/CentOS/Fedora)
> or libkrb5-dev (Debian/Ubuntu) should solve the build issue.
>

Yes, I'm on Ubuntu LTS, and installing one of the krb dev packages does
indeed solve the problem. Ideally though, I'd like to avoid installing a
package we don't - in principle - need.


>
>> [What is worse is that, because - I think - of the dependency pinning
>> approach that pgAdmin4 uses, the above downgrade to pgadmin4.30 is not the
>> end of the story: I actually end up all the way back on pgadmin4.25, which
>> is even more annoying, if not downright dangerous].
>>
>
> I'm not sure I understand the issue there. What prevents you from going
> back to 4.29?
>

That's not clear to me, and I don't know if there is an accessible way to
work out why pip3's dependency resolver (which I guess is in charge here)
decides that it has to go back further. I can post logs or run any commands
that might help track this down, but I fear this is inevitable if packages
we depend on extensively pin dependencies.

FWIW, pgadmin4 and one or two others from a well-known cloud vendor are the
main ones that do extensive pinning. (I can understand why, if one thinks
of oneself as an end product, this might seem attractive, but for me,
pgadmin4 is a rather useful component, not the end application :-)).


>
>> I'm not sure if there is a way to make the gsslib dependency
>> optional/failsafe?
>>
>
> I'd need to dive into it some more. There are "extras", but from what I
> can see these have to be explicitly installed. Ideally we want something
> that will try to install gssapi automatically, but not get upset if it
> fails.
>

As noted, I'm not trying to pin any blame for this, and there are
workarounds available. But anything that you might do to help would be
great.

Thanks for the quick reply (as always!),

Shaheed


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

Save results in CSV

[Kay Khandpur]

I just upgraded to pgAdmin 4 v5.0 from v4.29.

There is change in the default behavior when I save my query results as a
CSV.

In the earlier version I would include a limit statement in my query to
test it. Then I would highlight the query without the limit statement,
click on the download icon and ALL results would download into a CSV and be
opened by Excel.

In the new version, clicking on the download icon after following the same
steps gives me only the results from the query with the limit (say 100)
that I had used for testing. To get full results I have to re-run the query
without the limit statement, and then click the download icon. This results
in the CSV being downloaded, but not automatically opened by Excel.

Are there some settings I can change to revert to the earlier behavior? Or
are there any other workarounds to download results with fewer steps?

Thanks.

Re: Save results in CSV

[Aditya Toshniwal]

Hi Kay,

Previously, the download CSV button used to run the query again. The
behaviour is corrected now.
The "Save results to file" indicates save the query output result. It will
not run the query, and will save whatever is in the grid.


On Thu, Mar 4, 2021 at 6:58 AM Kay Khandpur  wrote:

> I just upgraded to pgAdmin 4 v5.0 from v4.29.
>
> There is change in the default behavior when I save my query results as a
> CSV.
>
> In the earlier version I would include a limit statement in my query to
> test it. Then I would highlight the query without the limit statement,
> click on the download icon and ALL results would download into a CSV and be
> opened by Excel.
>
> In the new version, clicking on the download icon after following the same
> steps gives me only the results from the query with the limit (say 100)
> that I had used for testing. To get full results I have to re-run the query
> without the limit statement, and then click the download icon. This results
> in the CSV being downloaded, but not automatically opened by Excel.
>
> Are there some settings I can change to revert to the earlier behavior? Or
> are there any other workarounds to download results with fewer steps?
>
> Thanks.
>
>

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

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

Re: Save results in CSV

[Kay Khandpur]

Thanks Aditya!

So it looks like I got used to a feature that was actually a bug. 😆

Any suggestions on how to automatically open the csv file when it
downloads, as it did before? Or is it the intended behavior to not open the
csv?

On Wed, Mar 3, 2021, 20:28 Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi Kay,
>
> Previously, the download CSV button used to run the query again. The
> behaviour is corrected now.
> The "Save results to file" indicates save the query output result. It will
> not run the query, and will save whatever is in the grid.
>
>
> On Thu, Mar 4, 2021 at 6:58 AM Kay Khandpur  wrote:
>
>> I just upgraded to pgAdmin 4 v5.0 from v4.29.
>>
>> There is change in the default behavior when I save my query results as a
>> CSV.
>>
>> In the earlier version I would include a limit statement in my query to
>> test it. Then I would highlight the query without the limit statement,
>> click on the download icon and ALL results would download into a CSV and be
>> opened by Excel.
>>
>> In the new version, clicking on the download icon after following the
>> same steps gives me only the results from the query with the limit (say
>> 100) that I had used for testing. To get full results I have to re-run the
>> query without the limit statement, and then click the download icon. This
>> results in the CSV being downloaded, but not automatically opened by Excel.
>>
>> Are there some settings I can change to revert to the earlier behavior?
>> Or are there any other workarounds to download results with fewer steps?
>>
>> Thanks.
>>
>>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
> 
> "Don't Complain about Heat, Plant a TREE"
>

Re: Save results in CSV

[Aditya Toshniwal]

Hi,

On Thu, Mar 4, 2021 at 10:08 AM Kay Khandpur  wrote:

> Thanks Aditya!
>
> So it looks like I got used to a feature that was actually a bug. 😆
>
> Any suggestions on how to automatically open the csv file when it
> downloads, as it did before? Or is it the intended behavior to not open the
> csv?
>
Opening a file automatically after download is a browser feature. Since
pgAdmin 5.0 has its own container now, it is not opening it.
However, you can log the feature request for the team to look into it.
https://redmine.postgresql.org/projects/pgadmin4/issues/new

>
> On Wed, Mar 3, 2021, 20:28 Aditya Toshniwal <
> aditya.toshni...@enterprisedb.com> wrote:
>
>> Hi Kay,
>>
>> Previously, the download CSV button used to run the query again. The
>> behaviour is corrected now.
>> The "Save results to file" indicates save the query output result. It
>> will not run the query, and will save whatever is in the grid.
>>
>>
>> On Thu, Mar 4, 2021 at 6:58 AM Kay Khandpur  wrote:
>>
>>> I just upgraded to pgAdmin 4 v5.0 from v4.29.
>>>
>>> There is change in the default behavior when I save my query results as
>>> a CSV.
>>>
>>> In the earlier version I would include a limit statement in my query to
>>> test it. Then I would highlight the query without the limit statement,
>>> click on the download icon and ALL results would download into a CSV and be
>>> opened by Excel.
>>>
>>> In the new version, clicking on the download icon after following the
>>> same steps gives me only the results from the query with the limit (say
>>> 100) that I had used for testing. To get full results I have to re-run the
>>> query without the limit statement, and then click the download icon. This
>>> results in the CSV being downloaded, but not automatically opened by Excel.
>>>
>>> Are there some settings I can change to revert to the earlier behavior?
>>> Or are there any other workarounds to download results with fewer steps?
>>>
>>> Thanks.
>>>
>>>
>>
>> --
>> Thanks,
>> Aditya Toshniwal
>> pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
>> 
>> "Don't Complain about Heat, Plant a TREE"
>>
>

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

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

Re: pgAdmin 4 v5.0 released

[Richard Brockie]

Thanks for the smooth upgrade to the new pgadmin4 implementation with v5.

I have one extremely minor quibble - my master password is stored in a
password manager which would autocomplete using a browser plugin. Now I
have to find the password manually and copy it into the password field!
Best wishes,
R.


On Thu, Feb 25, 2021 at 4:57 AM Akshay Joshi 
wrote:

> The pgAdmin Development Team are pleased to announce pgAdmin 4 version
> 5.0. This release of pgAdmin 4 includes 31 bug fixes and new features. For
> more details please see the release notes
> .
>
> Notable changes in this release include:
>
> Features:
>
>-
>
>New Desktop Runtime (Using NWjs):
>
> The Desktop Runtime is now based on NWjs which integrates a browser and
> the Python server creating a standalone application. By implementing it
> using NWjs we get rid of the separate server application and the
> independent browser. We also get rid of QT and C++ runtime logic.
>
> There are two minor known issues with this feature (6255
>  and 6258
> ), both of which are due to
> bugs in NWjs itself; Users on macOS should use the application menu to exit
> pgAdmin, rather than quitting from the Dock icon to avoid the first issue.
> The second issue may cause Windows users to see a red square instead of the
> normal application icon in some circumstances.
>
>-
>
>Logical Replication support:
>
> Logical replication uses a publish and subscribe model with one or more
> subscribers subscribing to one or more publications on a publisher node. We
> have added support for logical replication by introducing new treeview
> nodes and dialogues with which users can easily create/alter/delete
> publications and subscriptions. Support is also included in the Schema Diff
> tool.
>
>-
>
>Quick Search functionality:
>
> Added a quick search option in the Help menu to search menu items and help
> articles. Type at least three characters to display all the matching
> possibilities under Menu items and the relevant documents under Help
> articles.
>
>-
>
>Make Statistics, Dependencies, Dependants tabs closable. Users can add
>them back using the 'Add panel' option on the context menu for the tab
>strip.
>-
>
>When running in Docker/Kubernetes, ensure logs are not stored in the
>container, and only sent to the console.
>
> Bugs/Housekeeping:
>
>-
>
>Use cheroot as the default production server for pgAdmin4
>-
>
>Updated Javascript dependencies to the latest versions
>-
>
>Fixed an issue where the focus is not properly set on the filter text
>editor after closing the error dialog.
>-
>
>Fixed an issue where the dependencies tab shows multiple owners for
>the objects having shared dependencies.
>-
>
>Fixed an issue where the Zoom to fit button in the ERD Tool only works
>if the diagram is larger than the canvas.
>-
>
>Fixed an issue where the user was unable to change the background
>color for a server.
>-
>
>Fixed an issue where external utility jobs (backup, maintenance etc.)
>are failing when the log level is set to DEBUG.
>-
>
>Ensure DEB/RPM packages depend on the same version of each other.
>-
>
>Fixed an autocomplete issue where it is not showing any suggestions if
>the schema name contains escape characters.
>
> 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
>
>

-- 
R.

Richard Brockie

Real-time bicycle race management - www.ontheday.net