"Crypt key is missing" on new instal

2021-10-20 Thread Jack Royal-Gordon
Hi, Just installed pgAdmin4 6.0 via download of the .dmg file on a new laptop. When I try to add a server to it, after specifying the Connection info, I click “Save” and get “Crypt key is missing.” I get this with both a local server and a remote server. What is the fix for this?

Restoring context when reopening

2021-08-04 Thread Jack Royal-Gordon
I imagine this has been requested before, but it seems like it’s time to bring it up again. We’ve pretty much all become used to our applications that re-open previously opened documents, etc. when the application is reopened after rebooting our computer. PgAdmin lags in this area. I’d like to s

Re: How to unzoom the window

2021-04-01 Thread Jack Royal-Gordon
Thank you all for the answers. Dave is right that I’m running the experimental nwjs version. Darren is right that Cmd-Plus and Cmd-Minus will zoom the browser on MacOS, and while I didnt’ do that, there is perhaps another native MacOS capability at work here. I used to get the same issue with pd

How to unzoom the window

2021-03-31 Thread Jack Royal-Gordon
Hi all, I’m running 4.29-nwjs on MacOS. I accidentally zoomed the window way up and could not figure out how to zoom it back down. I checked the documentation for shortcut keys () but did not see anything there. I ended up closing and re-opening the program. What’s the sequence for unzooming?

Re: Accessibility issues in PgAdmin

2021-03-12 Thread Jack Royal-Gordon
I’m not one of the Developers, but if I were, I would feel like I have to fix this, because your request was put so politely! You aren’t Canadian, are you? ;) > On Mar 12, 2021, at 10:17 AM, > wrote: > > Hello, > > I discovered an accessibility issue in PgAdmin: > All toggle buttons (eg. u

Re: RES: Switch PG Versions

2021-03-04 Thread Jack Royal-Gordon
Jack, > > I was in a similar situation with an old application using pg v9. I installed > different versions of postgres with homebrew on Catalina. I currently have > versions 9, 11 & 12 installed and can have them all running in parallel > listening on different ports. I c

Re: Switch PG Versions

2021-03-04 Thread Jack Royal-Gordon
t 3:29 PM, Dave Page wrote: > > EDB installers are designed to support side by side installation of multiple > major versions. It works just fine (I’ve been using them like that for years). > > On Thu, 4 Mar 2021 at 23:22, Jack Royal-Gordon <mailto:jac...@pobox.com>&g

Re: Switch PG Versions

2021-03-04 Thread Jack Royal-Gordon
nnect to them all from a single instance of > pgAdmin4 over their respective ports. Testing the application with the new pg > version is also just a port change in the configuration. It works very well. > > Best wishes, > R. > > > On Thu, Mar 4, 2021 at 11:52 AM Jack Roya

Switch PG Versions

2021-03-04 Thread Jack Royal-Gordon
I’m using the EDB PG installation on Mac OS 11.1 (Big Sur), which seems to offer multiple versions. I’m currently running PG10, but I’m looking to upgrade to PG13 and would like to test with it first. Can I (and if so then how do i) switch back and forth between PG versions?

Re: Higher than expected(?) energy usage

2021-03-02 Thread Jack Royal-Gordon
sed then CPU% > fluctuates between 4-5%. > > > > > On Tue, Mar 2, 2021 at 4:29 AM Jack Royal-Gordon <mailto:j...@architechies.com>> wrote: > I’m running the test version of pgadmin with nwjs, and I just noticed that my > laptop felt a

Higher than expected(?) energy usage

2021-03-01 Thread Jack Royal-Gordon
I’m running the test version of pgadmin with nwjs, and I just noticed that my laptop felt a little warm, so of course I went to check on energy usage, expecting the culprit to be a webpage with a bunch of crap on it. But, to my surprise, it was pgAdmin. When I drilled down into it, I saw that it

Re: desktop application

2021-02-10 Thread Jack Royal-Gordon
Hi Gunner, I’ve been using this new version exclusively for about three weeks now, and it appears very solid. I love that it’s independent of my browser windows, and highly recommend it. Jack > On Feb 10, 2021, at 12:11 AM, Aditya Toshniwal > wrote: > > Hi Gunnar, > > We've been working on

Re: pgAdmin 4 v4.30 released

2021-01-28 Thread Jack Royal-Gordon
Is this version using the NWjs framework, or is that still in testing? > On Jan 28, 2021, at 5:14 AM, Akshay Joshi > wrote: > > 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 ple

Re: Testing required: pgAdmin 4 with new desktop runtime

2021-01-22 Thread Jack Royal-Gordon
I’ve only just installed and started using the new version, but I love it. Especially that it’s in it’s own window instead of just another tab in the browser window. Kudos! > On Jan 21, 2021, at 12:29 PM, Dave Page wrote: > > Hi > > On Thu, 21 Jan 2021 at 16:01, richard coleman

Re: Varying Character comparison

2021-01-06 Thread Jack Royal-Gordon
Joseph, What you quoted “as barcode” is NOT a “cast”, that is an alias, which is about naming a value in order to facilitate referencing it elsewhere. A “cast” is about stating explicitly what type you want the value converted to. For example cast(barcode as int) takes the “varchar” barcode and

Re: ERDTool alpha version for trial

2020-12-16 Thread Jack Royal-Gordon
I have one question: is there any risk that this tool, when used with an existing database, can affect the database at all (assuming you don’t execute any of the DDL generated by it)? In other words, is it safe to use with existing databases without risking any damage or changes to the performan

Re: insert sql generated from pgAdmin

2020-12-11 Thread Jack Royal-Gordon
Someone else may be able to clarify further, but I believe that pgbackup can write a file that contains insert sql statements in order to recreate the contents of the database. You can choose one or more tables and whether to include the statements to create the tables (along with many many othe

Re: pgAdmin4 - Multi-database Servers

2020-12-01 Thread Jack Royal-Gordon
e "Hobby Dev" rather than pick from the long list, I've > added the database name to the "DB restriction" field on the Advanced tab of > the connection menu. I didn't have to do this for the "Standard 0" database > for some reason. > > R. >

pgAdmin4 - Multi-database Servers

2020-12-01 Thread Jack Royal-Gordon
I am using Heroku to host a number of apps. Some of them have PG databases that are on shared servers. When that happens, there could be hundreds of databases on a single server (each with a randomly-generated name), but only one of them is the one I’m interested in (and that’s the only one that

Re: Problem when double-clicking to auto-size column in query window

2020-09-29 Thread Jack Royal-Gordon
reproducible on it. > > Thanks, > Khushboo > > On Mon, Sep 28, 2020 at 9:49 PM Jack Royal-Gordon <mailto:jac...@pobox.com>> wrote: > When I double-click on the column border of the query result window to > auto-size a column, I get no resizing and the following erro

Problem when double-clicking to auto-size column in query window

2020-09-28 Thread Jack Royal-Gordon
When I double-click on the column border of the query result window to auto-size a column, I get no resizing and the following error in the log. I get this both with Safari and Chrome. I’m running version 4.1of pgAdmin4. Error from Safari: TypeError: undefined is not an object (evaluating 'b().f

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

2020-09-24 Thread Jack Royal-Gordon
I’m happy to see that some of these items are already addressed.But I have a couple issues with them: 1) auto-re-sizing columns by clicking on their separator does not work for me. I’ve got Safari as my default browser (running on OS X,). Double-clicking the header separator to the right of the

Re: How to grant on all tables in pgAdmin4?

2020-09-03 Thread Jack Royal-Gordon
Maybe I’m missing something here, but since pgAdmin includes a query window, you can connect to the server, open a query window, type that command into the query window and then execute it. The query window is an alternative to the graphical interface. I would expect that just about anything yo

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.

2020-08-27 Thread Jack Royal-Gordon
Perhaps I chose my words poorly - “insist, while being accurate, probably carries negative connotations that were unnecessary. You “chose” to use Pale Moon. To you, it appeared to be the only reasonable alternative; that may be true or may not - it is subject to debate. But you “chose” to use it

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.

2020-08-26 Thread Jack Royal-Gordon
Here’s a thought that I think could solve your issues: It sounds like a lot of your issues are caused by the insistence on using PaleMoon. I don’t imagine that the team does much if any testing against PaleMoon, so I’m not shocked that you have issues with it. And I get it - you want private br

Re: Is there a better option than supporting every Browser out there?

2020-08-25 Thread Jack Royal-Gordon
On Sun, Aug 23, 2020 at 11:55 PM Jack Royal-Gordon <mailto:jac...@pobox.com>> wrote: > It seems like a lot of effort is being spent on supporting all of the major > browsers out there, and working around the quirks that arise from pgAdmin4 > being browser-based. Recognizing, ho

Is there a better option than supporting every Browser out there?

2020-08-23 Thread Jack Royal-Gordon
It seems like a lot of effort is being spent on supporting all of the major browsers out there, and working around the quirks that arise from pgAdmin4 being browser-based. Recognizing, however, that using a browser as he basis for screen output achieves a major goal of platform independence, I h

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.

2020-08-21 Thread Jack Royal-Gordon
Hi Bob, pgAdmin III is a TOTALLY DIFFERENT piece of software than pgAdmin 4. I used III for a number of years. I was never thrilled with it, but it did what I needed for me. For example, if I lost my connection to the server either voluntarily or because I closed my laptop, I could not allow th

Re: Bug report: pgAdmin takes selected portion of query in Query Editor to run

2020-08-12 Thread Jack Royal-Gordon
I don’t know if it’s even a good idea to change that functionality. When I’m working on performance issues, I very well may put a very complicated SQL statement with several sub-selects in the window, and start with just one of the sub-selects to see what it’s performance issues might be. So it’

Re: How to use pgadmin 4

2020-07-21 Thread Jack Royal-Gordon
I expect that someone who has Windows will answer this, but in the meantime, pgAdmin has a configuration utility, and you can configure the command line to use to start it up (at least in Mac OS X you can, and I assume Windows is the same). So figure out the correct command line for Chrome and s

Re: Proposal: Drop support for Internet Explorer

2020-04-07 Thread Jack Royal-Gordon
I’ve had a similar response from not supporting IE since about 2016. A couple users asked about it and had no problem when I told them we didn’t support it. Mostly, they switched to Chrome. 👍👍 > On Apr 7, 2020, at 4:41 AM, Dave Caughey wrote: > > Check the analytics... I think you'll find dro

Re: Mac client - reconnecting to existing server

2020-04-05 Thread Jack Royal-Gordon
FWIW, you can edit the .plitst file with any text editor. All you get with Xcode is syntax coloring and it’s a very heavy application for a Mac just for that. I stopped using Xcode for .plist editing several years ago. > On Apr 4, 2020, at 10:56 PM, Diggs, Asoka wrote: > > Additional info. >

Re: ENQUIRY

2020-01-28 Thread Jack Royal-Gordon
Before you can create a database, you have to have a database server. pgAdmin4 is a front end for controlling database servers. If you don’t have a database server, look for an installation for Postgres for your local machine — install that and you’ll have a database server to connect to. Altern

Re: Is there a way to export favourites from pgadmin3 on Lates macOS version(Catalina)

2019-11-15 Thread Jack Royal-Gordon
I just looked at my pgAdmin III configuration files (in ~) and there is an XML file “.pgadminfavourites” that seems to contain favorite queries. select date, sum(sold-returned) from barnes_and_noble_sales_points where date >= '11/1/19' and book_id in (select id from books where user_id = 867

Re: joining tables

2019-09-03 Thread Jack Royal-Gordon
Let me step back a bit, as I realize upon further reflection that the first method will not work. As far as the issue about two “Ted” records, read it as though I said two “Ted D” records. It refers to two records in the same table with the same key value. If “Ted D” appeared twice in table 1 a

Re: joining tables

2019-09-03 Thread Jack Royal-Gordon
Hi Ted, In essence, you want to merge the three tables, removing records that are duplicated by another table, right? Here are two approaches: 1) SELECT DISTINCT (field list) FROM (SELECT * from table1 UNION SELECT * from table2 UNION SELECT * from table 3). This will remove all duplicates, re

Re: My user experience with pgAdmin 4.

2019-08-06 Thread Jack Royal-Gordon
tutiluren, I think you’re being a little thin-skinned here. I don’t think he was accusing you of misusing the browser, but I think you should admit that the root of most of the problems being described here is the necessity of clearing your browser history often, due to bad players who take adva

Re: pgAdmin v4.1 - positive feedback

2019-01-20 Thread Jack Royal-Gordon
Thanks for your post, Richard. Like you, I looked at pgAdmin 4 a couple years ago. I decided then that it wasn’t ready for me, so I went back to pgAdmin III. Your post convinced me to go back and take another look. I only just loaded it, but my immediate impression is far more positive. I’m not

Re: pgadmin3 on macOS "Mojave"

2018-11-05 Thread Jack Royal-Gordon
:http://www.enterprisedb.com <http://www.enterprisedb.com/> > The Enterprise PostgreSQL Company > > On 5 Nov 2018, at 17:47, Jack Royal-Gordon <mailto:jac...@pobox.com>> wrote: > >> +1 - thanks for the heads-up, Bill. I was just about to upgrade, but I guess &

Re: pgadmin3 on macOS "Mojave"

2018-11-05 Thread Jack Royal-Gordon
+1 - thanks for the heads-up, Bill. I was just about to upgrade, but I guess I’ll hold off until they respond to this request. > On Nov 5, 2018, at 8:50 AM, Bill Evans wrote: > > Hello, > > I recently upgraded my Mac to the latest version of macOS. Now, when I run > pgadmin3, I get a messag