pgAdmin4-9.5 password textbox missing in connection settings

2025-07-09 Thread richard coleman
I've recently upgraded to pgAdmin4-9.5 from pgAdmin4-9.1 on Windows 10. Apparently the Password textbox in the Connection tab has been removed. Why has this change been made? How do I get it back? Thanks, rik.

install pgAdmin4-desktop on Ubuntu without installing pgAdmin4-server

2025-06-27 Thread richard coleman
Hello all, Is there a way to install just pgadmin4-desktop on Ubuntu? Following the instructions here: https://www.pgadmin.org/download/pgadmin-4-apt/ It states: # Install for both desktop and web modes: sudo apt install pgadmin4 # Install for desktop mode only: sudo apt install pgadmin4-desk

pgadmin4-server comming along for the ride

2023-10-12 Thread richard coleman
Installing pgadmin4 on a new kubuntu system. install via: sudo apt-get install pgadmin4-desktop it automatically also installs pgadmin4-server. If I try to remove pgadmin4-server it also removes desktop. How do I *just* install pgadmin4-desktop? Thanks, rik.

Re: Admin User Connect Privilege to Database

2023-06-29 Thread richard coleman
Josh, This isn't really the list for it, but have you tried: GRANT CONNECT ON DATABASE database_name TO public; as the postgres superuser? just a thought, rik. On Thu, Jun 29, 2023 at 3:41 PM Josh Klok wrote: > Hi, > > I'm relatively new to database management. I have a database setup > cu

Re: pgAdmin 4 v7.2 Released

2023-06-01 Thread richard coleman
Also, just closing that dialog box now results in every saved connection re-requesting the saved password all over again. Why is this happening and how do I revert back to the previous behavior? Thanks again, rik. On Thu, Jun 1, 2023 at 4:25 PM richard coleman wrote: > Just upgraded

Re: pgAdmin 4 v7.2 Released

2023-06-01 Thread richard coleman
Just upgraded to pgAdmin 4 version 7.2. Even though I have a config_local.py file with the string: MASTER_PASSWORD_REQUIRED=False I am still getting a "Migrate Saved Passwords" dialog upon start. How do I by pass this new dialog? Thanks, rik. On Thu, Jun 1, 2023 at 9:31 AM Akshay Joshi wrote:

Re: error open app

2022-11-18 Thread richard coleman
Or if it's *very* large, a simple text (.txt) file. rik. On Fri, Nov 18, 2022 at 9:31 AM Ray O'Donnell wrote: > On 18/11/2022 10:48, Alina wrote: > > Hello, when I open pgadmin4 app, I have this error message attached. > > Please help me with this error. > > I'd be very wary about opening a Wor

Re: PgAdmin ERD tool question

2022-08-18 Thread richard coleman
ables and so on. >> But I think that can be made optional with a preference setting. >> >> On Wed, Aug 17, 2022 at 9:18 PM richard coleman < >> rcoleman.ascen...@gmail.com> wrote: >> >>> Aditya, >>> >>> How about an option to drag any/all

Re: PgAdmin ERD tool question

2022-08-17 Thread richard coleman
Aditya, How about an option to drag any/all related items when you drag one that is tied to other elements? Just a thought. rik. On Wed, Aug 17, 2022 at 5:33 AM Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi Didier, > > Since we can drop one table at a time, it is not possibl

Re: Bulk CSV input within the GUI, not from file?

2022-06-11 Thread richard coleman
Jeong-hun Sin, Have you tried just writing one or more INSERT statements in the query tool? In that way you won't need a CSV file and can just type them in the text area as opposed to the data grid. I hope that helps, rik. On Sat, Jun 11, 2022 at 7:18 PM Jeong-hun Sin wrote: > I wanted to in

Re: Question regarding Dashboard column resize

2022-05-31 Thread richard coleman
I've noticed it as well. This greatly reduces the utility of the dashboard. (pgAdmin4 v 6.9, Windows 10 Pro x64) rik. On Tue, May 31, 2022 at 11:51 AM Eric Katchan wrote: > Hello, I have upgraded pgAdmin to v 6.9 and noticed that I was no longer > able to resize columns in dashboard mode. Ha

pgAdmin 4 (v 6.9) still doesn't like to cancel background processes

2022-05-18 Thread richard coleman
Hi all, Running pgAdmin4 version 6.9 on Windows 10 Pro x64. It seems that pgAdmin still doesn't like to stop processes. I started a backup, then a couple of seconds after it started I noticed a mistake and hit the "Stop Process" button. As of the time of this email it's been over 7,400 seconds

Re: pgadmin4 for fedora 35

2021-11-09 Thread richard coleman
Dave, Good to know, thanks, rik. On Tue, Nov 9, 2021 at 8:43 AM Dave Page wrote: > Hi > > On Tue, Nov 9, 2021 at 12:41 PM richard coleman < > rcoleman.ascen...@gmail.com> wrote: > >> Dave, >> >> Have you ever considered using something like flatpak (

Re: pgadmin4 for fedora 35

2021-11-09 Thread richard coleman
Dave, Have you ever considered using something like flatpak ( https://flatpak.org/ ) for the Linux versions of pgAdmin? It might; make it easier to handle the many different distributions, and deal with the different release schedules of the many dependencies that pgAdmin relies upon. Just a tho

Re: Running pgadmin4:5.5 behind reverse-proxy only shows progress indicator after successful login

2021-08-11 Thread richard coleman
Hi Jörg Liebig, If it's the same issue that *still exists* when I connect over an RDP session, I would try moving the window? I find that the screen doesn't refresh and it is actually all set behind that screen. Moving the window clears it up. That might not be *your* problem, but it won't hurt

Re: Resetting the pgadmin4 web user credentials

2021-07-27 Thread richard coleman
Kevin, I don't think that the pgAdmin user and the database user are necessarily the same thing (though I could be wrong) [see: https://www.pgadmin.org/docs/pgadmin4/5.4/user_management.html ]. The pg_hba.conf file defines what users/machines/methods are allowed to connect to a postgresql server.

Re: FK to partitioned table

2021-06-29 Thread richard coleman
Piotr, Thanks for the question. This is the pgAdmin4 (a GUI for managing PostgreSQL databases) list. You might have better luck on the postgres list Pgsql-admin . Good luck, rik. On Tue, Jun 29, 2021 at 8:28 AM Piotr Włodarczyk < piotrwlodarczy...@gmail.com> wrote: > Hello geeks, > > I have

Re: pgAdmin 4 v5.4 Released

2021-06-18 Thread richard coleman
Akshay, Thanks for pointing that out, I never realized that it was there ;) rik. On Fri, Jun 18, 2021 at 10:07 AM Akshay Joshi wrote: > Hi Frank > > On Fri, 18 Jun, 2021, 2:42 pm Frank Limpert, > wrote: > >> At first: Thank you all for repairing Bug #6520 - CSV Export. >> >> 2.) Your idea

Re: pgAdmin 4 v5.4 Released

2021-06-17 Thread richard coleman
It looks like Bug #6520 has been squashed. Thanks to the entire team for their work in this and the other bug squashing/improvements. 👍 rik. On Thu, Jun 17, 2021 at 6:21 AM Akshay Joshi wrote: > The pgAdmin Development Team is pleased to announce pgAdmin 4 version 5.4. > > > > This release of p

Re: Open pgAdmin in browser

2021-06-03 Thread richard coleman
Trung, Yes, I can see how that would be annoying. Hopefully the development team can address these issues in future versions. rik. p.s. As for the last issue, you don't actually have to minimize the window, just moving it a bit will refresh the display. It isn't actually stuck, it just looks l

Re: Open pgAdmin in browser

2021-06-03 Thread richard coleman
Trung Do, You know I think you are the *only* person I've heard from that actually liked the old behaviour. ;) I believe the only way is to either: - revert to an earlier version (not really recommended) - use pgAdmin4 in **server** mode as opposed to desktop mode I hope that helps, rik.

Re: Import fails on single quote.

2021-05-11 Thread richard coleman
Blake, You might want to try escaping the single quotes in your data. Either by doubling them up or switching double quotes for dollar-quoted strings. Just a thought, rik. On Tue, May 11, 2021 at 3:02 PM dsbw wrote: > Hello, > > Trying to import data, tab-delimited but unfortunately with q

Re: Rearrange Column

2021-04-22 Thread richard coleman
lumns in the way you want to see them, or, should they be > using "View/Edit Rows" pgAdmin would again show the rows in the prefered > order. > > Cheers, > Dave > > > On Thu, Apr 22, 2021 at 11:01 AM richard coleman < > rcoleman.ascen...@gmail.com> wrote: >

Re: Rearrange Column

2021-04-22 Thread richard coleman
Sachin, Umm, I hate to be the one to break it to you, but *postgreSQL *doesn't support rearranging columns in a table, short of dropping them and re-adding them in the desired order. Since postgreSQL itself doesn't support that, I would be truly amazed to learn that pgAdmin4 managed to accomplish

Re: PGAdmin 4 V5 scroll-bars

2021-03-23 Thread richard coleman
Darren, I think I understand what you are trying to get at with your post, but I am afraid it comes across as a bit insensitive. Trackpad/touch control surfaces are very difficult for me, and I would imagine like situated people, to utilize. Suggesting that they try a "...*more modern (but still

Re: PGAdmin 4 V5 scroll-bars

2021-03-23 Thread richard coleman
Darren, Same issue here. Windows 10 Enterprise, pgAdmin 4 v5 desktop mode. Scroll bar visible but useless. As you can see from the original poster's screen shot, the problem with text overwriting the scroll bars hasn't been addressed either. As for using a scroll wheel, not all of us have one.

Re: pgAdmin desktop app fatal error

2021-03-12 Thread richard coleman
Alex, It sounds like you might have a pgAdmin4 *pre-verson 5 *installation on your machine. Version 5 is the one that doesn't rely on an external browser, previous versions did. Adding to the confusion is that when pgAdmin 4 v5 is installed, it *doesn't remove* any pre-version 5 installations.

Re: Switch PG Versions

2021-03-04 Thread richard coleman
Edson, Of course not. What you can do is install multiple versions of postgreSQL in parallel (I've done it on Windows and Ubuntu Server). It's why they are each put into their own version numbered directory. For example, a Windows machine running versions 10, 12, and 13 would have a default fi

Re: How do I remove this stupid "master password"?

2021-02-28 Thread richard coleman
[ HOW TO DISABLE MASTER PASSWORD feature in pgAdmin4 ] Vladimir, I sympathize with you. I have had some extensive discussions with the head developer, unfortunately it doesn't seem to be something that he is willing to address. It's built to address a *remote* threat vector, one that the vast m

Re: query tool csv/txt output file extension choice and encoding

2021-02-05 Thread richard coleman
Dave, I concur with Alain. On Fri, Feb 5, 2021 at 3:22 PM Dave Caughey wrote: > Always naming the file as ".csv", regardless of the delimited used, was a > bug that was fixed. > > In my case it was a bug that was created. > The problem with always naming a file as ".csv" is that Excel then bl

Re: Testing required: pgAdmin 4 with new desktop runtime

2021-01-21 Thread richard coleman
Dave, Sounds promising, can the new beta be installed alongside the existing version? Thanks, rik. On Thu, Jan 21, 2021 at 10:56 AM Dave Page wrote: > All, > > As you know, when run in Desktop mode, pgAdmin 4 uses a server process > which runs all the time and opens a browser window to displa

Re: Varying Character comparison

2021-01-06 Thread richard coleman
Joseph, This is really an SQL question, not something specific to PostgreSQL or pgAdmin. That being said, it looks like your e.index_entry field is of type varchar (character varying) and you are trying to compare it to an int. If that is the case you will need to either cast the e.index_entry f

Re: Extra Paranthesis on joins on saving a view

2020-12-03 Thread richard coleman
Alex, Sounds like you would like to register some *feature requests* for pgAdmin4. Your best bet would be to enter them here: https://redmine.postgresql.org/projects/pgadmin4 One item per feature request. Good luck, rik. On Wed, Dec 2, 2020 at 8:44 PM Alex Williams wrote: > Hi, > > I'm not

Re: PGAdmin4 v4.28 Windows Chrome

2020-12-01 Thread richard coleman
Marcelo, This is a known issue with the latest version under windows. The solution is documented here: https://www.pgadmin.org/faq/#12 TLDR; To resolve the issue, use the Registry Editor and reset the value of HKEY_CLASSES_ROOT\.js\Content Type to: text/javascript Good luck, rik. On Fri, N

Re: pg Admin 4 v4.28 Errors on launch

2020-12-01 Thread richard coleman
tito, This is a known issue with the latest version under windows. The solution is documented here: https://www.pgadmin.org/faq/#12 TLDR; To resolve the issue, use the Registry Editor and reset the value of HKEY_CLASSES_ROOT\.js\Content Type to: text/javascript Good luck, rik. On Thu, Nov

Re: Start pgadmin4 server

2020-11-12 Thread richard coleman
mrivera, Welcome. Running pgAdmin4 doesn't require you to be running, nor start running a local postgreSQL server. There may be some confusion in that pgAdmin *itself* is a server (just not a postgreSQL server). Actually pgAdmin4 is just the back end, it relies on a browser to provide a user in

Re: pgAdmin 4 v4.28 released

2020-11-12 Thread richard coleman
👍 On Thu, Nov 12, 2020 at 11:22 AM Dave Page wrote: > > > On Thu, Nov 12, 2020 at 4:13 PM richard coleman < > rcoleman.ascen...@gmail.com> wrote: > >> Dave, >> >> Thanks, but I expected that once an issue makes it into a release, and a >> relea

Re: pgAdmin 4 v4.28 released

2020-11-12 Thread richard coleman
Dave, Thanks, but I expected that once an issue makes it into a release, and a release announcement, that the veil is pulled back. rik. On Thu, Nov 12, 2020 at 11:05 AM Dave Page wrote: > Richard, > > On Thu, Nov 12, 2020 at 3:59 PM richard coleman < > rcoleman.ascen...@g

Re: pgAdmin 4 v4.28 released

2020-11-12 Thread richard coleman
Hi All, The release notes list: Issue #5919 - Added security related enhancements. But this issue does not show up on the list of issues and following the link returns a 403 error. What exactly was included in this change? It doesn't seem exactly *

Re: pgAdmin 4 v4.28 released

2020-11-12 Thread richard coleman
Hi All, The release notes list: Issue #5919 - Added security related enhancements. But this issue does not show up on the list of issues and following the link returns a 403 error. What exactly was included in this change? It doesn't seem exactly *

Re: pgAdmin standalone

2020-10-07 Thread richard coleman
Msciwoj, Just a word of warning, this *isn't* what you might suspect. The old desktop version had its own bundled browser frontend. The current version, even the _desktop_ version, is still a local web server that requires a web browser to function as the UI. rik. On Wed, Oct 7, 2020 at 6:43

Re: pgAdmin 4 v4.26 released

2020-09-18 Thread richard coleman
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. W

Re: pgAdmin 4 v4.26 released

2020-09-17 Thread richard coleman
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? Thanks, rik. On Thu, Sep 17, 2020 at 8:09 AM Akshay Joshi wrote: > The pgAdmin Development Team is pleased to announce pgAdmin 4 version 4.2

Re: pgadmin 4.25 version - fix port number

2020-09-01 Thread richard coleman
_* > > *Best Regards:* > > > > *Benedek Polgár | *System administrator | polgar.bene...@otpmobil.com > > > > > > *From:* richard coleman > *Sent:* 01 September 2020 21:43 > *To:* Polgár Benedek > *Cc:* pgadmin-support@lists.postgresql.org > *Subject:

Re: pgadmin 4.25 version - fix port number

2020-09-01 Thread richard coleman
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 wrote: > Dear Support Team! > > > > The fixed port number config is not working in pgadmin 4.25 version. > > Please hel

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 richard coleman
That's what I do. Chromium for pgAdmin4, Chrome, Vivaldi, Firefox for everything else. ¯\_(ツ)_/¯ rik. On Wed, Aug 26, 2020 at 5:00 PM Jack Royal-Gordon wrote: > 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

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-25 Thread richard coleman
Dave, Thanks for the link. It was very informative. Best wishes to you and your team. rik. On Tue, Aug 25, 2020 at 9:00 AM Dave Page wrote: > > > On Fri, Aug 21, 2020 at 11:23 AM wrote: > > >> Please consider testing your software before releasing it. >> > > https://pgsnake.blogspot.com/202

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

2020-08-12 Thread richard coleman
t; > The behavior described by Tung Do is really just a learning step. > > On Aug 12, 2020, at 12:36 PM, richard coleman > wrote: > > That's not a bug, it's a *feature* !! > > Seriously though, presently the query window in pgAdmin4 has two options: > If nothi

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

2020-08-12 Thread richard coleman
That's not a bug, it's a *feature* !! Seriously though, presently the query window in pgAdmin4 has two options: If nothing is selected -> run the entire window If something is selected -> run just what's selected. That's how it's been since, well as long as I can recall. Unlike some other tools,

Re: connect external app via pgadmin

2020-08-12 Thread richard coleman
B., I hate to be the bearer of bad news, but in a nutshell no. As you write, with both pgAdmin and postgreSQL installed on the same machine there is no need to open any ports to access that particular postgreSQL instance. Unfortunately unless the other application is also installed on that same s

Re: Mystery "PostgreSQL 11" server keeps reappearing in pgAdmin 4 no matter how many times I delete it.

2020-04-21 Thread richard coleman
Dave, On Tue, Apr 21, 2020 at 4:31 AM Dave Page wrote: > > > On Tue, Apr 21, 2020 at 8:57 AM wrote: > >> Ever since I went through the horrible ordeal of trying to update >> PostgreSQL on Windows (from 11.5 to 11.7, so not even a major version), >> pgAdmin 4 has started showing a "PostgreSQL 11

Re: Proposal: Drop support for Internet Explorer

2020-04-07 Thread richard coleman
Dave, Seeing that IE isn't standards compliant and not only is not being further developed, but Microsoft is actively discouraging its use, it is probably time to drop support for it. I would caution *against* using browser analytics as any sort of proxy for use. Since pgAdmin 4 lacks a UI of it

Re: Starting just the pgAdmin server

2020-04-03 Thread richard coleman
Ken, Short answer, it's a more or less a self contained environment for running applications. Docker is more developer friendly, a similar technology kubernetes is more dev ops focused. Here are a few links to get you started: - https://hub.

Re: Seriously? MASTER PASSWORD REQUIRED Again?!#$@!

2019-10-18 Thread richard coleman
Dave, On Fri, Oct 18, 2019 at 3:24 AM Dave Page wrote: > > > On Thu, Oct 17, 2019 at 7:03 PM richard coleman < > rcoleman.ascen...@gmail.com> wrote: > >> Aditya, >> >> That's new. I have kept that setting in that file ever since the it was >&g

Re: Seriously? MASTER PASSWORD REQUIRED Again?!#$@!

2019-10-17 Thread richard coleman
019 at 12:50 PM Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi Richard, > > You need to add the setting in config_local.py. Other files will be > replaced except config_local.py. > > On Thu, Oct 17, 2019, 22:15 richard coleman > wrote: > >&

Seriously? MASTER PASSWORD REQUIRED Again?!#$@!

2019-10-17 Thread richard coleman
Ugg, Just upgraded pgAdmin4 to the latest version 4.14. Even though I have had the Master Password requirement disabled for as long as it has been in existence, guess what I was greeted with upon starting pgAdmin4? If you guessed the prompt requiring me to create a Master Password, or be locked

Sane right-click Hurray

2019-09-11 Thread richard coleman
Finally got 4.12 here, and I am pleasantly surprised to see a sane (and some would say) sensible right-click context menu in the query tool. Good job devs. rik.

Re: Some pgAdmin bugs...

2019-09-10 Thread richard coleman
at 8:34 AM Dave Page wrote: > > > On Tue, Sep 10, 2019 at 8:24 AM richard coleman < > rcoleman.ascen...@gmail.com> wrote: > >> Hi All, >> >> My $0.02. Tested the first one here (Kubuntu 18.04, Chromium, pgAdmin 4 >> 4.12) with mixed results. >>

Re: Some pgAdmin bugs...

2019-09-10 Thread richard coleman
Hi All, My $0.02. Tested the first one here (Kubuntu 18.04, Chromium, pgAdmin 4 4.12) with mixed results. On Tue, Sep 10, 2019 at 7:59 AM Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi, > > On Tue, Sep 10, 2019 at 5:13 PM Arni Kromić > wrote: > >> Working with pgAdmin, I've

Re: Start pgadmin4 server

2019-08-26 Thread richard coleman
Khushboo, Thanks for the thought, but I believe he is asking how to start pgAdmin4 *without *opening a browser window. In other words, start pgAdmin4 but *never* see a browser window until you choose "New pgAdmin 4 window ...". I don't think that's possible, at least from the *desktop* variant o

Re: pgAdmin 4 ignores its own config option: "BrowserCommand"

2019-08-09 Thread richard coleman
Tutiluren, On Thu, Aug 8, 2019 at 6:16 PM wrote: > I don't know what you mean by right-clicking on the pgAdmin 4 Taskbar icon > and selecting "Configure", because no such thing appears when I do that. > The only other option other than running it is "Unpin". > > > Here are a few pictures (from W

Re: pgAdmin 4 ignores its own config option: "BrowserCommand"

2019-08-08 Thread richard coleman
tutiluren, I am sorry to read that you are still having difficulties. The MASTER_PASSWORD_REQUIRED string is documented in the pgAdmin4 documentation located here: https://www.pgadmin.org/docs/pgadmin4/development/master_password.html . As for the BrowserCommand I usually set it in the configure

Re: My user experience with pgAdmin 4.

2019-08-04 Thread richard coleman
For what it's worth, I try to mitigate the isolation issue by letting pgAdmin4 have it's own dedicated browser. I have a Chromium installation that is only used for pgAdmin4. I've adjusted the *browser command* to: "chromium-browser %URL%". In that way, whenever I start pgAdmin4, or ask for a n

Re: pgadmin4 - Use classic style interface, don't launch browser?

2019-08-02 Thread richard coleman
Mark, I can concur (in Kubuntu 18.04). It has happened on occasion in FireFox (both current and ESR), Chrome, Chromium, Vivaldi (yea those last three are basically the same thing, I know ;) ). That's why I have a separate install of Chromium that is just used for pgAdmin4. So when the browser c

Re: no results in 4.11 Ubuntu

2019-08-01 Thread richard coleman
e issue? The link you sent just goes to a postgresql.org "sign in" page. > > On Thu, Aug 1, 2019 at 6:58 AM richard coleman < > rcoleman.ascen...@gmail.com> wrote: > >> Richard, >> >> Congratulations, you too have been hit by the mis-pack

Re: no results in 4.11 Ubuntu

2019-08-01 Thread richard coleman
Richard, Congratulations, you too have been hit by the mis-packaged pgAdmin4.11 bug recorded as Issue # 4520 (among others) . *TLDR* version; pgAdmin 4.11 is dependent on a version of psycopg2 that isn't in the repository (any repository)

Re: pgadmin4 - Use classic style interface, don't launch browser?

2019-07-31 Thread richard coleman
-size > > The best way to identify areas that require improvement is to run the > lighthouse > <https://chrome.google.com/webstore/detail/lighthouse/blipmdconlkpinefehnmjammfjpmpbjk> > auditing tool. > > > On Tue, Jul 30, 2019 at 5:46 PM richard coleman < > rc

Re: Appreciation for pgAdmin 4's progress

2019-07-30 Thread richard coleman
I concur. Ctrl-C/Ctrl-V is basically muscle memory at this point. Unfortunately though there are times when it's particularly jarring. Selecting things are done in pgAdmin4 with the mouse/track ball/etc. so your hand is already off the keyboard. So for example; you select an sql statement to copy

Re: pgadmin4 - Use classic style interface, don't launch browser?

2019-07-30 Thread richard coleman
Dave, That's true. Of course that's the ultimate draw back of the client/server model. Having *just* a server isn't enough, you need a *client* as well. pgAdmin4 is *just* the server portion of that model. It's relying on *borrowing* someone else's client. That's frees up quite a bit of resour

Re: (Repeat.) Please give pgAdmin 4 its own GUI. The constant password inputs are driving me insane...

2019-07-29 Thread richard coleman
ocally that has had phpPgAdmin installed. In pgAdmin4's case it's using python not php and the application and web server come as a bundle. But thanks for pointing me to that web page. rik. On Mon, Jul 29, 2019 at 8:14 AM Dave Page wrote: > Hi > > On Mon, Jul 29, 20

Re: (Repeat.) Please give pgAdmin 4 its own GUI. The constant password inputs are driving me insane...

2019-07-29 Thread richard coleman
am not the only one who would like that opportunity. rik. On Mon, Jul 29, 2019 at 4:45 AM Dave Page wrote: > Hi > > On Sat, Jul 27, 2019 at 8:50 PM richard coleman < > rcoleman.ascen...@gmail.com> wrote: > >> (sorry about the last missive - continued) >> &g

Re: pgadmin4 - Use classic style interface, don't launch browser?

2019-07-28 Thread richard coleman
vate', () => { > if (win === null) { > createWindow() > } > }) > > That's all there is to it. Once you have that working, you can take it a > step further by getting electron to launch the pgadmin4 server if it is not > running already by using spawn

Re: pgAdmin4 (v 4.11) SELECT * returns 'table_oid'

2019-07-27 Thread richard coleman
I think I have been bit by Bug #4520 <https://redmine.postgresql.org/issues/4520?issue_count=196&issue_position=3&next_issue_id=4519&prev_issue_id=4525>. I hope there is a solution soon. rik. On Sat, Jul 27, 2019 at 4:14 PM richard coleman wrote: > 'ello all, >

pgAdmin4 (v 4.11) SELECT * returns 'table_oid'

2019-07-27 Thread richard coleman
'ello all, When running the following query: SELECT * FROM live.tbl_documents limit 1; in pgAdmin4 it returns *no* output and switches to the Messages tab with the following message: 'table_oid' The same query against the same table in the same database run at the psql prompt returns the

Re: (Repeat.) Please give pgAdmin 4 its own GUI. The constant password inputs are driving me insane...

2019-07-27 Thread richard coleman
(sorry about the last missive - continued) On Sat, Jul 27, 2019 at 3:38 PM richard coleman wrote: > Darren, > > On Sat, Jul 27, 2019 at 3:03 PM Darren Duncan > wrote: > >> Have you tried using more than one browser? >> that's what I've taken to doing,

Re: (Repeat.) Please give pgAdmin 4 its own GUI. The constant password inputs are driving me insane...

2019-07-27 Thread richard coleman
Darren, On Sat, Jul 27, 2019 at 3:03 PM Darren Duncan wrote: > Have you tried using more than one browser? > that's what I've taken to doing, I have a separate install of Chromium > just for pgAdmin4. I've even changed the browser command to > Load pgAdmin and/or a small number of secured thing

Re: pgadmin4 - Use classic style interface, don't launch browser?

2019-07-27 Thread richard coleman
Hi Avin, My $0.02 On Sat, Jul 27, 2019 at 2:11 PM Avin Kavish wrote: > Hey, > > Here's some unofficial input on the topic. > > This request baffles me for two reasons. > > a. Why does one need a standalone window when they can have pgAdmin open > in a tab while multi-tasking. Is there ever a ti

Re: Please give pgAdmin 4 its own GUI. The constant password inputs are driving me insane...

2019-07-25 Thread richard coleman
e to think about what I've written, rik. On Thu, Jul 25, 2019 at 8:49 AM Dave Page wrote: > Richard, > > On Thu, Jul 25, 2019 at 1:08 PM richard coleman < > rcoleman.ascen...@gmail.com> wrote: > >> Avin, >> >> I agree, the master password *nonsens

Re: Bug when a column is JSON?

2019-07-25 Thread richard coleman
t; On Thu, Jul 25, 2019 at 1:11 PM richard coleman < > rcoleman.ascen...@gmail.com> wrote: > >> Fahar, >> >> We've *just* gotten the 4.*10* release in .deb format. Will we have to >> wait until 4.*11* or maybe 4.*13* until we will see 4.10? >> > > Ne

Re: Bug when a column is JSON?

2019-07-25 Thread richard coleman
Fahar, We've *just* gotten the 4.*10* release in .deb format. Will we have to wait until 4.*11* or maybe 4.*13* until we will see 4.10? Thanks, rik. On Thu, Jul 25, 2019 at 5:37 AM Fahar Abbas wrote: > Hi, > > This fix will be available in 4.11 release today. > > On Thu, Jul 25, 2019 at 2:21

Re: Please give pgAdmin 4 its own GUI. The constant password inputs are driving me insane...

2019-07-25 Thread richard coleman
Avin, I agree, the master password *nonsense* was poorly implemented. I too wish the developers would rethink it. Until then there is a way to disable it by setting an option in a config file. I can provide more details if you would like (or you could look for other more expansive posts by myse

Re: How do I remove this stupid "master password"?

2019-07-09 Thread richard coleman
tutiluren, I feel your pain. Here's the *short* answer I passed along to someone else. There's a *much* longer discussion between myself and the dev that thought this was a good idea that I can share if you are ever interested. rik. -

Re: [EXTERNAL] - Re: How to close pgAdmin4

2019-06-27 Thread richard coleman
Michelle, Right click the little picture of the elephant, the context menu should include an entry "Shut down server", select that and you will *correctly* shut down pgAdmin4. [image: context_menu_pgAdmin4_taskbar.png] Some of your confusion probably stems from the fact, that contrary to appeara

Re: change connection in PgAdmin4

2019-06-19 Thread richard coleman
Michael, I don't think so, but I would love to be proven wrong. It's rather annoying to have to open a new query tool window per database and copy/paste SQL between them. Especially since the new design doesn't lend it self to side by side windows. rik. On Wed, Jun 19, 2019 at 10:18 AM Michael

Re: pgAdmin4 v.4.8 Kubuntu / Chromium can't resize Properties dialog

2019-06-19 Thread richard coleman
andex browser - others(?) It seems rather *silly* to state that Chromium isn't a supported browser. Thanks, rik. On Wed, Jun 19, 2019 at 12:10 AM Khushboo Vashi < khushboo.va...@enterprisedb.com> wrote: > Hi Richard, > > On Tue, Jun 18, 2019 at 9:41 PM richard c

pgAdmin4 v.4.8 Kubuntu / Chromium can't resize Properties dialog

2019-06-18 Thread richard coleman
To Whom it may concern, Running pgAdmin4 version 4.8 on Chromium under Kubuntu. When I open the properties dialog for a table, it is un-resizable and the horizontal scroll bar doesn't work. This is particularly problematic as I can't get to all the properties in the columns screen. The develope

Re: pgAdmin4 4.8 Kubuntu issues

2019-06-06 Thread richard coleman
ys appreciated, lack of color forgiven ;). > > rik. > On Thu, Jun 6, 2019, 10:01 richard coleman > wrote: > >> Dave, >> >> Thank you for getting back to me. >> >> On Thu, Jun 6, 2019 at 5:01 AM Dave Page wrote: >> >>> >>> >&

Re: pgAdmin4 4.8 Kubuntu issues

2019-06-06 Thread richard coleman
Dave, Thank you for getting back to me. On Thu, Jun 6, 2019 at 5:01 AM Dave Page wrote: > > > On Wed, Jun 5, 2019 at 7:29 PM richard coleman < > rcoleman.ascen...@gmail.com> wrote: > >> >> All passwords are stored in files of one sort or another. Hopefull

Re: pgAdmin4 4.8 Kubuntu issues

2019-06-05 Thread richard coleman
Dave, On Wed, Jun 5, 2019 at 12:13 PM Dave Page wrote: > Richard, > > On Wed, Jun 5, 2019 at 4:55 PM richard coleman < > rcoleman.ascen...@gmail.com> wrote: > >> Dave, >> >> Actually I thought I was being quite restrained in my assessment. With >>

Re: pgAdmin4 4.8 Kubuntu issues

2019-06-05 Thread richard coleman
than > this should be changed, if they don't, then keep it, as it's more secure. I > know it's not going to help in your case, but seems more balanced to me on > security vs. Usage, on a more democratic way. > > And again, I think the docs should explain this at

Re: pgAdmin4 4.8 Kubuntu issues

2019-06-05 Thread richard coleman
; > It shouldn't need one, the user should be able to use or not use a master password from the Preferences UI. If they want to use one, fine. If not, that's OK too. If they were and want to stop, warn the user and wipe all of the existing passwords. > Those are my 2 cents.

Re: pgAdmin4 4.8 Kubuntu issues

2019-06-05 Thread richard coleman
urity. Yes, I think I have been quite restrained in my assessment. Thanks, rik. On Wed, Jun 5, 2019 at 10:59 AM Dave Page wrote: > Richard, > > On Wed, Jun 5, 2019 at 3:22 PM richard coleman < > rcoleman.ascen...@gmail.com> wrote: > >> Dave, >> >> And

Re: pgAdmin4 4.8 Kubuntu issues

2019-06-05 Thread richard coleman
Dave, Sorry, but after an e*xhaustive* search of the several terabytes on my machine, there is *no* config_local.py file. Do you have any idea where it's supposed to be located? Thanks, rik. On Wed, Jun 5, 2019 at 9:30 AM Dave Page wrote: > > > On Wed, Jun 5, 2019 at 1:16 PM r

Re: pgAdmin4 4.8 Kubuntu issues

2019-06-05 Thread richard coleman
ython?.?/site-packages/pgadmin4/config_local.py". This is in the > docs: https://www.pgadmin.org/docs/pgadmin4/dev/master_password.html > > On Tue, Jun 4, 2019 at 4:41 PM richard coleman < > rcoleman.ascen...@gmail.com> wrote: > >> To whomever, >> >> Running a n

Re: pgAdmin4 4.8 Kubuntu issues

2019-06-05 Thread richard coleman
Christoph, pgAdmin4 updated itself this morning, and now the "?" on the Set Master Password dialog returns an actual page, not a 404. Unfortunately it isn't all that clear. It suggests; "You can disable the master password by setting the configuration parameter MASTER_PASSWORD_REQUIRED=False"

pgAdmin4 4.8 Kubuntu issues

2019-06-04 Thread richard coleman
To whomever, Running a newly update pgAdmin 4 version 4.8 on my Kubuntu box. There are a couple of glaring issues. First: It keeps prompting to; "Set Master Password" I don't want to set another password that I'll just end up forgetting. Second: When I click the "?" button on that dialog bo

Re: pip, anyone?

2019-05-07 Thread richard coleman
Malik, Well for what it's worth, I'm running Kubuntu 18.10 and I usually apt-get install pgAdmin4. The instructions on how to add the relevant repository is here: https://wiki.postgresql.org/wiki/Apt . The only caveat is that it tends to lag behind the releases for windows and RPM (sometimes eve

Re: pgadmin 4 v4.6 - Eternal Loading

2019-05-03 Thread richard coleman
se, ".js" extension's file name display right to an "outsystems" > reference. > > Regards. > > Maycon > > Em sex, 3 de mai de 2019 às 10:19, richard coleman < > rcoleman.ascen...@gmail.com> escreveu: > >> Maycon, >> >> If you w

Re: pgadmin 4 v4.6 - Eternal Loading

2019-05-03 Thread richard coleman
Maycon, If you wouldn't mind sharing, which Chrome Extension was the cause? Thanks, rik. On Fri, May 3, 2019 at 9:18 AM Maycon Oleczinski wrote: > Hi All. > > Sorry, attach has blocked. > But just now, really now, I found "problem cause". > An Chrome Extension activated when page load get err

Re: How to: copy records from one table to another?

2019-03-22 Thread richard coleman
Dave, When moving data *between* postgresql databases, I rely on custom python scripts using psycopg2. A simple write loop inside a read loop and two connections usually does the trick. rik. On Fri, Mar 22, 2019 at 9:59 AM Dave Caughey wrote: > Unfortunately, using simple SQL statements isn't

  1   2   >