pgadmin4-server comming along for the ride

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

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 >

Re: pgAdmin 4 v7.2 Released

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 upgra

Re: pgAdmin 4 v7.2 Released

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

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

Re: PgAdmin ERD tool question

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 d

Re: PgAdmin ERD tool question

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

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

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

Re: Question regarding Dashboard column resize

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.

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

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

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

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

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

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

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

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

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

Re: pgAdmin 4 v5.4 Released

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

Re: Open pgAdmin in browser

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

Re: Open pgAdmin in browser

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,

Re: Import fails on single quote.

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

Re: Rearrange Column

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: > >> Sachin, >&g

Re: Rearrange Column

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

Re: PGAdmin 4 V5 scroll-bars

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

Re: PGAdmin 4 V5 scroll-bars

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

Re: pgAdmin desktop app fatal error

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

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

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

[ 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

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

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

Re: Testing required: pgAdmin 4 with new desktop runtime

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

Re: Varying Character comparison

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

Re: Extra Paranthesis on joins on saving a view

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

Re: PGAdmin4 v4.28 Windows Chrome

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,

Re: pg Admin 4 v4.28 Errors on launch

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,

Re: Start pgadmin4 server

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

Re: pgAdmin 4 v4.28 released

 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

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

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

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

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

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

Re: pgAdmin 4 v4.26 released

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

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

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.

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. >> > >

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

e 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 nothing is selected ->

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

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

Re: connect external app via pgadmin

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

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

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

Re: Proposal: Drop support for Internet Explorer

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

Re: Starting just the pgAdmin server

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: -

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

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 >> in

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

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: > >> Ugg, >&g

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

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

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...

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...

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

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

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

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

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

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.

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

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

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

Re: no results in 4.11 Ubuntu

t; the 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

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?

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 < > rcoleman.ascen...@gmail.com> wrote: &

Re: Appreciation for pgAdmin 4's progress

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

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

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

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

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, 2019 at 12:58 PM richard coleman < >

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

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) >> >> On Sat,

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

org/api/child_process.html#child_process_child_process_execsync_command_options> > > It's nice that you included the above, but it's not terribly helpful to > the *non*-programmer. I could write the Lorentz transformation equations > to handle relative velocities in special relativity >

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

I think I have been bit by Bug #4520 <https://redmine.postgresql.org/issues/4520?issue_count=196_position=3_issue_id=4519_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, > > When running the following qu

pgAdmin4 (v 4.11) SELECT * returns 'table_oid'

'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...

(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, I have a s

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

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

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

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

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

t 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 *nonsense* was poorly implemented

Re: Bug when a column is JSON?

t 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? >> > > Neither Fahar nor the rest of

Re: Bug when a column is JSON?

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

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

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

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

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

Re: change connection in PgAdmin4

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

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

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 coleman <

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

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

Re: pgAdmin4 4.8 Kubuntu issues

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: >> >>> >>> >>> On Wed,

Re: pgAdmin4 4.8 Kubuntu issues

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

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

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 length. > > Sorry if my input wasn't ve

Re: pgAdmin4 4.8 Kubuntu issues

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. > > Thanks again, rik. > On Wed, Jun 5, 2019, 12:55 richard coleman >

Re: pgAdmin4 4.8 Kubuntu issues

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 richar

Re: pgAdmin4 4.8 Kubuntu issues

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

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

Re: pip, anyone?

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

Re: pgadmin 4 v4.6 - Eternal Loading

quot;.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 wouldn't mi

Re: pgadmin 4 v4.6 - Eternal Loading

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

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

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

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

Dave, If you are talking about copying records between tables in *different* databases, postgresql currently doesn't support this. If you are talking about *within* the same database, 'INSERT with a SELECT CLAUSE', 'SELECT INTO', and similar commands exist. As far as I know; #1 Sounds good in

pgAdmin 4.3 scratch pad

Hi All, Is there a setting to *stop* the scratch pad from showing up *every time *you open a query window? pgAdmin 4.3, Kubuntu 18.10, Chromium Thanks, rik.

Re: Either Find does not work or I don't know how to make it work

Malik, Yes, I can confirm that it's rather counterintuative. Ubuntu 18.10, Chromium here. Cntrl-F in the query window causes the *Search: *bar to appear. Doing *anything* other than clicking in the text box to the right of the *Search:* will cause the search bar to disappear. Entering text

Re: Import/Export failure due to UTF-8 error in pgAdmin4 but not in pgAdmin3

Nanina, If you can do it through the psql prompt, then the problem is most likely pgAdmin4, otherwise you might want to get in touch with the postgreSQL devs/support lists. For example, you can run the COPY command both with and without the HEADERS option and see if that works. I hope that

Re: Change browser in MacOS

Steve, Well I have mine set to launch chromium with this command: > chromium-browser %URL% So I would imagine substituting the command to start chrome from the command line would suffice. Just a thought, rik. On Tue, Jan 8, 2019 at 10:02 AM Steve Hawes wrote: > Hi, > > > > Can anyone help

Re: Import/Export failure due to UTF-8 error in pgAdmin4 but not in pgAdmin3

tms_production > SET default_transaction_read_only TO off; > ALTER DATABASE tms_production > SET client_encoding TO sql_ascii; > ALTER DATABASE tms_production > SET standard_conforming_strings TO off; rik. On Tue, Jan 8, 2019 at 8:37 AM Dave Page wrote: > Hi Rik

Re: Import/Export failure due to UTF-8 error in pgAdmin4 but not in pgAdmin3

12:47 AM richard coleman > wrote: > > > > Dave, > > > > Thanks for taking the time to respond, but I don't see anywhere that > SQL_ASCII is recommended against doing. Here's the documentation listing > the supported encoding schemas: > https://www.postgresql.org/d

  1   2   >