Re: Unable configure pgadmin on Google Cloud Run with SSL certs

2021-04-21 Thread Dave Page
/pgadmin4 $ ls -al /etc | head -5 total 232 drwxr-xr-x1 root root 4096 Apr 21 08:17 . drwxr-xr-x1 root root 4096 Apr 21 08:17 .. -rw-r--r--1 root root 7 Apr 14 10:25 alpine-release drwxr-xr-x1 root root 4096 Apr

Re: How to unzoom the window

2021-04-01 Thread Dave Page
Hi On Thu, Apr 1, 2021 at 9:30 AM Darren Duncan wrote: > On 2021-04-01 1:10 a.m., Dave Page wrote: > > Jack is running '4.29-nwjs', which was a pre-5.0 test build of the nwjs > based > > user interface. It does not use a browser, nor does it have zoom > functionality >

Re: How to unzoom the window

2021-04-01 Thread Dave Page
On Thu, Apr 1, 2021 at 9:00 AM Darren Duncan wrote: > On 2021-04-01 12:08 a.m., Dave Page wrote: > > On Thu, 1 Apr 2021 at 07:09, Akshay Joshi wrote: > > On Thu, Apr 1, 2021 at 9:03 AM Aditya Toshniwal wrote: > > Not sure how you zoomed the window, because the f

Re: How to unzoom the window

2021-04-01 Thread Dave Page
hacker | Sr. Software Engineer | *edbpostgres.com* >> <http://edbpostgres.com> >> "Don't Complain about Heat, Plant a TREE" >> > > > -- > *Thanks & Regards* > *Akshay Joshi* > *pgAdmin Hacker | Principal Software Architect* > *EDB Postgres <http://edbpostgres.com>* > > *Mobile: +91 976-788-8246* > -- -- Dave Page https://pgsnake.blogspot.com EDB Postgres https://www.enterprisedb.com

Re: Starting just the pgAdmin server

2021-03-29 Thread Dave Page
tion now, and runs as a traditional app would rather than a separate server with browser. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: Correct procedure for upgrading pgAdmin on Windows?

2021-03-29 Thread Dave Page
ry so you can uninstall and then reinstall safely anyway. If you install the community pgAdmin package it will install alongside the one with the database server; they should coexist without any problems. One won't attempt to modify the other in any way (unless you try to force the installation directory

Re: pgAdmin 4 v5.1 Released

2021-03-25 Thread Dave Page
is in ASCII character. >>- >> >>Ensure that the user should be able to kill the session from >>Dashboard if the user has a 'pg_signal_backend' role. >>- >> >>Ensure PGADMIN_DEFAULT_EMAIL looks sane when initializing a co

Re: unable to restore database

2021-03-18 Thread Dave Page
get you barred from posting. What is welcome is courteous discussion, and constructive feedback to help the developers and other users. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: Problems with pgAdmin 4 on MacBook Pro running macOS BigSur 11.2.3

2021-03-17 Thread Dave Page
f pgAdmin from www.pgadmin.org until the PostgreSQL installers catch up. It'll happily live alongside your existing installation. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: Accessibility issues in PgAdmin

2021-03-15 Thread Dave Page
future. > Khushboo, can you please make sure the appropriate WAI-ARIA roles are added ASAP? Thanks. > > Thanks, > Khushboo > >> Making the toggle buttons respond to keyboard actions (such as clicks >> using the space bar) has the advantage that it includes blind user

Re: PgAdmin 4 V5.0

2021-03-08 Thread Dave Page
he fact that it's no longer confined > to the browser. Well done Dave and all the team! > Thanks - Akshay deserves all the credit for the hard work. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: Switch PG Versions

2021-03-04 Thread Dave Page
S 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: Possible packaging problem with gssapi

2021-03-03 Thread Dave Page
t 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: Please HELP me! - pgAdmin 4 v4.x on macOS BigSuk

2021-02-26 Thread Dave Page
Windows en-masse? What would that accomplish? -- Darren Duncan > I was assuming that was somewhat tongue-in-cheek. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: Please HELP me! - pgAdmin 4 v4.x on macOS BigSuk

2021-02-26 Thread Dave Page
ya said, please update to 5.0, as it removes the Qt dependency. Oddly though; I don't think we've ever seen the issue you describe in a release version. We've not had it at all with the community builds, but I do know that the team that maintain the PostgreSQL installers at EDB (which include pgAd

Re: pgAdmin 4 v5.0 released

2021-02-25 Thread Dave Page
On Thu, Feb 25, 2021 at 3:30 PM Dave Page wrote: > > > On Thu, Feb 25, 2021 at 3:13 PM Dave Page wrote: > >> >> >> On Thu, Feb 25, 2021 at 2:46 PM Dave Caughey wrote: >> >>> Here's what happens when I run the command on the terminal. >>> &g

Re: pgAdmin 4 v5.0 released

2021-02-25 Thread Dave Page
On Thu, Feb 25, 2021 at 3:13 PM Dave Page wrote: > > > On Thu, Feb 25, 2021 at 2:46 PM Dave Caughey wrote: > >> Here's what happens when I run the command on the terminal. >> >> [image: image.png] >> >> But... pgAdmin v4.30 runs fine. >> > >

Re: pgAdmin 4 v5.0 released

2021-02-25 Thread Dave Page
ng which I for one didn't realise until I started looking into this (see https://www.python.org/downloads/windows/). I've kicked off a build using Python 3.8 for testing. That claims to support back to Vista. I'll send a link once it's done. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @

Re: db restore from sql file

2021-02-22 Thread Dave Page
psql command line utility. Better yet, use the 'custom' format when you're dumping the data, as it allows for a lot more flexibility when loading. Plain dumps are normally only preferred if you want to go and manually edit them in a text editor. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: pgadmin-4.30 upgrade from 4.27

2021-02-19 Thread Dave Page
Hi On Fri, Feb 19, 2021 at 2:05 PM James B. Byrne wrote: > > > On Fri, February 19, 2021 04:33, Dave Page wrote: > > Hi > > > > On Thu, Feb 18, 2021 at 7:34 PM James B. Byrne > > wrote: > > > >> When starting pgadmin4 in a python venv I get

Re: pgadmin-4.30 upgrade from 4.27

2021-02-19 Thread Dave Page
s well as config_local.py and config_distro.py if present), eg. dpage@hal:~/git/pgadmin4$ grep "APP_REVISION = " /Users/dpage/.virtualenvs/pgatest/lib/python3.8/site-packages/pgadmin4/config*.py /Users/dpage/.virtualenvs/pgatest/lib/python3.8/site-packages/pgadmin4/config.py:APP_REVISION = 30 (adjust the path appropriately for your venv of course). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: pgadmin setup without /usr/pgadmin4/bin/setup-web.sh

2021-02-15 Thread Dave Page
b.sh --yes > > > Am 14.02.21 um 19:42 schrieb Jo Drop: > > Hi, > > thank you very much, I will try that right away. > > kind regards, > Jo > > Am 14.02.21 um 17:12 schrieb Dave Page: > > Hi > > On Sat, Feb 13, 2021 at 12:10 PM Jo Drop wrote: >

Re: pgadmin setup without /usr/pgadmin4/bin/setup-web.sh

2021-02-14 Thread Dave Page
nd then running the script with the -y option on the command line. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: v4.30 windows x86 version

2021-02-08 Thread Dave Page
ions and groups, i'm trying to avoid moving to the x64 version if i > don't have to. > You don’t need to. Just uninstall the 32 bit version and then install the 64 bit. The same config database will be used. > thanks. > > > -- > Steve Martin > Director of E

Re: pgAdmin 4 v4.30 released

2021-02-01 Thread Dave Page
ored while >>>>>comparing using Schema Diff. >>>>>- Fixed an issue when the user tries to delete multiple records in >>>>>the data grid. >>>>>- Fixed TypeError exception in schema diff when selecting two >>>>>identical objects. >>>>>- Include PostgreSQL 13 utilities in the container distribution. >>>>> >>>>> >>>>> 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 >>>>> >>>>> >>>>> >>>>> >>>> >>>> -- >>>> Z wyrazami szacunku >>>> Andrzej Gerasimuk >>>> >>> >>> >>> -- >>> Fahar Abbas >>> EnterpriseDB Corporation >>> Phone Office: +92-51-835-8874 >>> Phone Direct: +92-51-8466803 >>> Mobile: +92-333-5409707 >>> Skype ID: *live:fahar.abbas* >>> Website: www.enterprisedb.com >>> >> >> >> -- >> Z wyrazami szacunku >> Andrzej Gerasimuk >> > > > -- > Fahar Abbas > EnterpriseDB Corporation > Phone Office: +92-51-835-8874 > Phone Direct: +92-51-8466803 > Mobile: +92-333-5409707 > Skype ID: *live:fahar.abbas* > Website: www.enterprisedb.com > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: pgAdmin 4 v4.30 released

2021-01-28 Thread Dave Page
jects. >- Include PostgreSQL 13 utilities in the container distribution. > > > 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 > > > > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: Installation on APT

2021-01-28 Thread Dave Page
ified because the public key is not available: > NO_PUBKEY 4B8EC3BAABDC4346 > tom@tomdev19 Sun24 22:51 ~> > Both the pgAdmin and PostgreSQL repositories are failing because they're trying to access a repo called "tricia", which is neither a Debian or Ubuntu release codename. Try editing the repo config files for both, and changing "tricia" to "bionic", which is the corresponding Ubuntu name. Note that we don't support Linux Mint, so I can't guarantee that will work (but it probably will). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: Testing required: pgAdmin 4 with new desktop runtime

2021-01-25 Thread Dave Page
On Mon, Jan 25, 2021 at 2:00 AM Anthony DeBarros wrote: > Dave, > > On Thu, Jan 21, 2021 at 10:56 AM Dave Page wrote: > >> >> We've been working on a new runtime (based on NWjs, similar to Electron) >> to allow us to get rid of the separate server process, and

Re: Testing required: pgAdmin 4 with new desktop runtime

2021-01-25 Thread Dave Page
an 21, 2021, at 12:29 PM, Dave Page wrote: > > Hi > > On Thu, 21 Jan 2021 at 16:01, richard coleman > wrote: > >> Dave, >> >> Sounds promising, can the new beta be installed alongside the existing >> version? >> > > Only on macOS, due to the w

Re: Testing required: pgAdmin 4 with new desktop runtime

2021-01-21 Thread Dave Page
Hi On Thu, 21 Jan 2021 at 16:01, richard coleman wrote: > Dave, > > Sounds promising, can the new beta be installed alongside the existing > version? > Only on macOS, due to the way appbundles work. > Thanks, > > rik. > > On Thu, Jan 21, 2021 at 10:56

Testing required: pgAdmin 4 with new desktop runtime

2021-01-21 Thread Dave Page
elease onwards. Thank you! -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: pgAdmin 4 on Debian testing

2021-01-07 Thread Dave Page
min/pgadmin4/snapshots/2021-01-08/apt/ after they run tonight. Note that they haven't been tested at all yet, so any feedback would be welcome. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: [External] Re: pgadmin--pgagent---the process hang by unknow reasons

2020-12-01 Thread Dave Page
; > postgres=# > > > > After failed. I try to build and compile the latest version 4.2. > > Build and install successfully. But I still on unable upgrade current 3.4 > version. > > I could create extension successfully on a new database. > > > > > > postgres=# \i pgagent--3.4--4.2.sql > > Use "CREATE EXTENSION pgagent UPDATE" to load this file. > > postgres=# CREATE EXTENSION pgagent UPDATE; > > ERROR: syntax error at or near "UPDATE" > > LINE 1: CREATE EXTENSION pgagent UPDATE; > > ^ > > postgres=# CREATE EXTENSION pgagent ; > > ERROR: relation "pga_jobagent" already exists > > postgres=# > > > > > > > I think the message is wrong (which I'll fix if you can confirm) - it should be: ALTER EXTENSION pgagent UPDATE; -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: [External] Re: pgadmin--pgagent---the process hang by unknow reasons

2020-11-30 Thread Dave Page
gt; Database Engineer > > > > DB Team,ITS. Lenovo China > > Phone: 86-18910860709 > > Email:xuz...@lenovo.com > > No.6 Shangdi West Road, Haidian District Beijing, China, 100085 > > > > *发件人:* Dave Page > *发送时间:* 2020年11月26日 19:39 > *收件人:* Zhiyu ZY13

Re: Export data from a query ran by pgagent

2020-11-30 Thread Dave Page
ecution (because they can be done using the PostgreSQL wire protocol). > > Best, > > Gonzalo Rubio-Casas > > El jue, 26 nov 2020 a las 15:55, Dave Page () escribió: > >> Hi >> >> On Thu, Nov 26, 2020 at 2:42 PM Gonzalo Rubio Casas < >> gonzalo.rubio.c

Re: Export data from a query ran by pgagent

2020-11-26 Thread Dave Page
lity of a shell > script is not possible I'm afraid. > pgAgent isn't designed to do this sort of thing I'm afraid. Given that you can't use a shell script (or COPY), probably the best you could do is have the query results be dumped into a table from which the users can query the data when they

Re: pgadmin--pgagent---the process hang by unknow reasons

2020-11-26 Thread Dave Page
Thread 0x7ff74c3507e0 (LWP 23389)): > > #0 0x7ff74b003334 in __lll_lock_wait () from /lib64/libpthread.so.0 > > #1 0x7ff74affe5d8 in _L_lock_854 () from /lib64/libpthread.so.0 > > #2 0x7ff74affe4a7 in pthread_mutex_lock () from /lib64/libpthread.so.0 > > #3 0x7ff74ba979c9 in wxMutexInternal::Lock() () from > /usr/lib64/libwx_baseu-2.8.so.0 > > #4 0x7ff74c15a99d in DBconn::ClearConnections(bool) () > > #5 0x7ff74c15e908 in MainRestartLoop(DBconn*) () > > #6 0x7ff74c15f2a3 in MainLoop() () > > #7 0x7ff74c15e016 in main () > > > > > > 徐志宇(Jack) > > Database Engineer > > > > DB Team,ITS. Lenovo China > > Phone: 86-18910860709 > > Email:xuz...@lenovo.com > > No.6 Shangdi West Road, Haidian District Beijing, China, 100085 > > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: ValueError: unsupported format character 'D'

2020-11-23 Thread Dave Page
0] [wsgi:error] [pid 38774:tid > 139824286275328] [remote ::1:55110] return get_domain().gettext(*args, > **kwargs) > [Fri Nov 20 16:26:44.077750 2020] [wsgi:error] [pid 38774:tid > 139824286275328] [remote ::1:55110] File > "/usr/lib/python3.6/site-packages/pgadmin4

Re: PG Admin 4 Does not open with new version Mac OS 11

2020-11-23 Thread Dave Page
the second version part would always increase like some other > programs and tools do/did? > pgAdmin doesn't care about that. It works fine on Big Sur as a general rule (at least per our testing). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: One storage for all pgAdmin users

2020-11-18 Thread Dave Page
e moment (please feel free to log a feature request at https://redmine.postgresql.org/projects/pgadmin4/issues/new), however you should be able to fake it by creating a symlink in each user's storage directory that points to a common location. -- Dave Page Blog: http://pgsnake.blogspot

Re: v4.28 not working for me on Windows

2020-11-16 Thread Dave Page
other defect. Therefore, we do not represent that this information is > complete or accurate and it should not be relied upon as such. All > information is subject to change without notice. > -- -- Dave Page https://pgsnake.blogspot.com EDB Postgres https://www.enterprisedb.com

Re: PgAdmin 4.28 doesn't work

2020-11-16 Thread Dave Page
ver I see the following error (see screenshot in >>>>> attachments). My browser is MS Edge (WebKit), but it doesn't work also in >>>>> Chrome and Firefox. >>>>> >>>>> Tell me, pls, how Can I fix this error? >>>>> >>>> >> >> -- >> Thanks, >> Aditya Toshniwal >> pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com* >> <http://edbpostgres.com> >> "Don't Complain about Heat, Plant a TREE" >> > > > -- > Thanks, > Aditya Toshniwal > pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com* > <http://edbpostgres.com> > "Don't Complain about Heat, Plant a TREE" > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: PgAdmin 4.28 doesn't work

2020-11-16 Thread Dave Page
Should have added - we're looking at building that into the code, so users don't have to do it themselves. On Mon, Nov 16, 2020 at 9:09 AM Dave Page wrote: > Yeah, I think that may be the best workaround for us. I'm hesitant to try > to have the installer automatically "fix" the

Re: PgAdmin v4.28

2020-11-15 Thread Dave Page
Please see https://www.pgadmin.org/faq/#12 On Sun, 15 Nov 2020 at 11:58, Carl Soto wrote: > Hello, > > I've installed v4.28 and not browser window keeps loading. > -- -- Dave Page https://pgsnake.blogspot.com EDB Postgres https://www.enterprisedb.com

Re: pgAdmin 4 v4.28 released

2020-11-12 Thread Dave Page
ts in a release, and that's one that can't easily be automated. > > 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...@gmail.com> wrote: >> >

Re: pgAdmin 4 v4.28 released

2020-11-12 Thread Dave Page
ant Wizard should include foreign tables. >>- Ensure that search object functionality works with case insensitive >>string. >> >> >> 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 >> >> -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: pgadmin4 - which python

2020-11-04 Thread Dave Page
min4/pgadmin4-4.27/runtime$ > > Python 3.8 ist found. But why should there python-config? > Because that's used to figure out where all the different parts of the installation can be found. On most Linux distros, there will be a python3-devel or python3-dev or similar package that will include that. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: pgadmin4 - which python

2020-11-04 Thread Dave Page
_DIR environment variable is not set. > Please set it to a directory path under which Python 3.4 or later has been > installed and try again. > > thomas@Epsil192:~/Downloads/pgadmin4/pgadmin4-4.27/runtime$ > > The environment is set. How/What is qmake checking? > Did you

Re: pgadmin4 - which python

2020-11-03 Thread Dave Page
On Tue, Nov 3, 2020 at 11:41 AM Egon Frerich wrote: > Am 03.11.20 um 11:27 schrieb Dave Page: > > > > > > On Tue, Nov 3, 2020 at 10:24 AM Egon Frerich > <mailto:e...@frerich.eu>> wrote: > > > > I want to install pgadmin4 with Mint 19.3

Re: pgadmin4 - which python

2020-11-03 Thread Dave Page
variable is set in your own session. There shouldn't be any need to run qmake under sudo. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: Missing packages for fedora 33

2020-11-02 Thread Dave Page
ora-33-Now-Generally-Available > and we would decide later either we need to add support of Fedora 33 on > next release (4.28) of pgadmin4 or not? > > @Dave Page your thoughts on this? > I'm building a Fedora 33 build node right now, so we should have pgAdmin 4 packages for F33 in

Re: Question about open source license

2020-10-09 Thread Dave Page
egal advisor whether or not you are able to meet the requirements of all the licences. That said, the pgAdmin licence is a permissive one, so normally you can modify the code as you see fit, and include it in commercial products without having to distribute the source. -- Dave Page Blog: http://p

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-28 Thread Dave Page
Hi On Thu, Sep 24, 2020 at 7:32 PM Mark Murawski wrote: > On 2020-09-24 04:35, Dave Page wrote: > > > > > Another missing feature is double click on a column header to expand > > the > > column to fit the data. > > > > > > That 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 Dave Page
020-09-24 at 17.07.08.png] None is the default. Prevent Docking will stop you from docking/undocking tabs and panels, but still allow you to adjust splitter bars (i.e. the size of the results panel in the query tool with respect to the query editor/history). Full Lock will lock splitter bars in pla

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 Dave Page
was having the function node under the trigger node) - Some are simply limitations of webapps in general. Please feel free to log issues for any of the above that are either new features that don't already have tickets, or are reproducible bugs, if my comments don't help you resolve the difficulties you're running into - and of course, feel free to reply here with further questions etc. if you like. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: pgAdmin 4 v4.26 released

2020-09-22 Thread Dave Page
Windows, and even then it wouldn't have stopped it working. > > Thank you. > > On Mon, Sep 21, 2020 at 6:09 AM Dave Page wrote: > >> >> >> On Sat, Sep 19, 2020 at 7:21 AM Dave Page wrote: >> >>> >>> >>> On Sat, 19 Sep 2020 at 00:59, richa

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-21 Thread Dave Page
On Mon, Sep 21, 2020 at 1:35 PM Christoph Berg wrote: > Re: Dave Page > > Please try using the packages the pgAdmin development team produce. We > > started building them a few releases ago because of issues such as these > > that were not getting resolved. > >

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-21 Thread Dave Page
Hi On Mon, Sep 21, 2020 at 12:23 PM Mark Murawski wrote: > On 2020-09-21 04:30, Dave Page wrote: > > > > > What are you waiting for exactly? If there are specific features that > > prevent you from doing so, it would help to know what they are exactly. > > Hi D

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-21 Thread Dave Page
> Needless to say, there's nothing in the "preferences" to set this. > > > It's seriously mind-boggling. The only reason I've never mentioned > > > this before has been that there's even worse issues that > > overshadowed > > > this. > > > > > > Sometimes, randomly, it *does* connect immediately to the server > > once > > > you've double-clicked the "Servers" thing. The fact that this is > not > > > consistent, but (apparently) random, just further confuses me and > > > makes me (again) wonder if this program was designed purposely as > a > > > psychological experiment. > > > > Bo > > > > > > > > > > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

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

2020-09-21 Thread Dave Page
oes* connect immediately to the server once > you've double-clicked the "Servers" thing. The fact that this is not > consistent, but (apparently) random, just further confuses me and makes me > (again) wonder if this program was designed purposely as a psychological > experiment. > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake

Re: pgAdmin 4 v4.26 released

2020-09-19 Thread Dave Page
ase is in progress already. > Thanks again, > > rik. > > On Fri, Sep 18, 2020 at 4:45 AM Dave Page wrote: > >> Hi >> >> On Thu, Sep 17, 2020 at 4:22 PM Dave Page wrote: >> >>> >>> >>> On Thu, Sep 17, 2020 at 4:18 PM richard colem

Re: pgAdmin 4 v4.26 released

2020-09-18 Thread Dave Page
Hi On Thu, Sep 17, 2020 at 4:22 PM Dave Page wrote: > > > On Thu, Sep 17, 2020 at 4:18 PM richard coleman < > rcoleman.ascen...@gmail.com> wrote: > >> Akshay, >> >> Just downloaded pgadmin4-4.26-x64.exe from the official web site. When I >> go to i

Re: pgAdmin 4 v4.26 released

2020-09-17 Thread Dave Page
seem to be a digital signature on the installer. I have to wonder a) how that happened without the build failing, and b) how it got past QA? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: problem with docker image : servers.json file mapping

2020-09-11 Thread Dave Page
y mac, there are configuration options to specify what directories files can be shared from. I don't know how that's configured on other OSs. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: problem with docker image

2020-09-10 Thread Dave Page
pically, /root is not accessible to users other than root - and it should stay that way; create another directory somewhere to put the servers.json file in. > > -- > *From:* Dave Page > *Sent:* Thursday, September 10, 2020 10:04 > *To:* Mickaël

Re: problem with docker image

2020-09-10 Thread Dave Page
servers.json > > Where am I wrong ? > I suspect the container (which runs under UID 5050) cannot read files in /root on your host. The file has permissions that would allow that, but does the directory it's in? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: pgAdmin4 won't start after OS upgrade

2020-09-02 Thread Dave Page
On Wed, Sep 2, 2020 at 1:11 PM Ray O'Donnell wrote: > On 02/09/2020 08:50, Dave Page wrote: > > > > > > On Tue, Sep 1, 2020 at 5:28 PM Ray O'Donnell > <mailto:r...@rodonnell.ie>> wrote: > > > > > One thing caught my eye: the Python path in t

Re: pgAdmin4 won't start after OS upgrade

2020-09-02 Thread Dave Page
On Tue, Sep 1, 2020 at 5:28 PM Ray O'Donnell wrote: > On 01/09/2020 17:07, Dave Page wrote: > > > > > > On Tue, Sep 1, 2020 at 5:03 PM Ray O'Donnell > <mailto:r...@rodonnell.ie>> wrote: > > > > Hi Dave, > > > > Thanks for

Re: pgAdmin4 won't start after OS upgrade

2020-09-02 Thread Dave Page
/apt/ bionic-pgdg main > > On 9/1/20 9:07 AM, Dave Page wrote: > > > > On Tue, Sep 1, 2020 at 5:03 PM Ray O'Donnell wrote: > >> On 01/09/2020 16:58, Dave Page wrote: >> > Hi >> > >> > On Tue, Sep 1, 2020 at 4:33 PM Ray O'Donnell > > <m

Re: pgAdmin4 won't start after OS upgrade

2020-09-01 Thread Dave Page
On Tue, Sep 1, 2020 at 5:03 PM Ray O'Donnell wrote: > On 01/09/2020 16:58, Dave Page wrote: > > Hi > > > > On Tue, Sep 1, 2020 at 4:33 PM Ray O'Donnell > <mailto:r...@rodonnell.ie>> wrote: > > > > Hi all, > > > > I upgraded

Re: pgAdmin4 won't start after OS upgrade

2020-09-01 Thread Dave Page
p will be greatly appreciated. > Probably due to the library differences in stretch vs. buster. I would remove the existing pgAdmin packages with dpkg, then edit /etc/apt/sources.list.d/pgadmin4.list and correct the URL (change stretch to buster). Then do an apt get update before installing pgAdmin

Re: Having trouble with connecting to database via kerberos

2020-08-28 Thread Dave Page
On Fri, Aug 28, 2020 at 11:03 AM Dave Page wrote: > Hi > > On Fri, Aug 28, 2020 at 9:59 AM Haskin, Daniel J > wrote: > >> Hello! >> >> I wonder if you folks can help me. I am having the hardest time location >> documentation on, or otherwise figur

Re: Having trouble with connecting to database via kerberos

2020-08-28 Thread Dave Page
, I'll move on to figuring out how to handle Windows/Mac clients connecting with GSSAPI. Note that SSPI/GSSAPI will require that you're running pgAdmin in Desktop mode. It will not work in Server mode (because the server will typically be running under a different user account). There's a feature re

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 Dave Page
Thanks Rik! On Tue, Aug 25, 2020 at 2:12 PM richard coleman wrote: > 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

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 Dave Page
On Fri, Aug 21, 2020 at 11:23 AM wrote: > Please consider testing your software before releasing it. > https://pgsnake.blogspot.com/2020/08/testing-pgadmin.html -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

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

2020-08-25 Thread Dave Page
-review the options, in the hope that someone will have done the work we need with CEF, but unfortunately that hasn't happened yet (I last checked maybe a month back). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: PassFile in docker compose?

2020-08-03 Thread Dave Page
On Thu, Jul 23, 2020 at 9:59 AM Dave Page wrote: > Hi > > On Thu, Jul 23, 2020 at 12:57 AM Zoltan Albert wrote: > >> I'm trying to use docker compose to spin up postgres and pgAdmin >> services, and the only sticking point is a minor one: I can't seem to get >>

Re: PassFile in docker compose?

2020-07-23 Thread Dave Page
idea how you make that happen in Docker Compose though. > Tried: > - stackoverflowing > - most promising google result: > https://javaoraclesoa.blogspot.com/2020/01/pgadmin-in-docker-provisioning.html > > Nothing seemed to work. Am I missing something? Or is it really

Re: How to customize browser based pgAdmin UI?

2020-07-10 Thread Dave Page
anels, e.g. those within the query tool and debugger. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: Tablespaces created with PGAdmin4 on any Server instance in a PostgreSQL 10 Cluster are duplicated to all other local server instances on that cluster

2020-07-10 Thread Dave Page
to that same Postgres instance - which would entirely explain why tablespaces appear on all servers when created on one. > Thanks, > > Kimball Johnson > > Product Manager at Engagile.io > > > > *Version* > > 3.1 > Yikes! Please upgrade to something less prehistoric. There have been *29* releases of pgAdmin since then, some of which include critical bug fixes. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: lot of "Bad request. The CSRF tokens do not match"

2020-07-09 Thread Dave Page
one process and then later makes a request that hits the second process, things will go kaboom. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com

Re: Persisting Query tabs/contents over restart

2020-06-09 Thread Dave Page
vim before closing the window. Kind of a pain, > as everyone knows. > Or just save them? > > Any thoughts? I'm sure this has been considered many times and might be in > the backlog. > > Regards, > > -j > -- Dave Page Blog: http://pgsnake.blogspot.com Twi

pgAdmin 4 now available on PyPi

2020-06-01 Thread Dave Page
ARNING: Do not use the development server in a production environment. Use a production WSGI server instead. * Debug mode: off Enjoy! -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

64bit only for Windows?

2020-05-22 Thread Dave Page
We currently build pgAdmin as a 32 bit application on Windows. This is getting harder and harder as more of our dependencies are becoming 64bit focussed or even 64bit only. Does anyone actually require 32bit Windows support, or could we move to 64 bit? -- Dave Page Blog: http

Re: [SOLVED] Re: pgAdmin 4 + python wheel + kerberos

2020-05-07 Thread Dave Page
Hi On Thu, May 7, 2020 at 3:52 PM Stephen Frost wrote: > Greetings, > > * Dave Page (dp...@pgadmin.org) wrote: > > On Wed, May 6, 2020 at 5:20 PM Stephen Frost wrote: > > > Any chance you could share that patch..? Considering that pgAdmin4 > has, > > > sad

Re: [SOLVED] Re: pgAdmin 4 + python wheel + kerberos

2020-05-07 Thread Dave Page
t would authenticate to the database, but it certainly does > > not work with my scheme. > > This would need its own Kerberos princ and then to have k5start running > to pull out tickets for it in an ongoing manner and then whatever > process is handling the pgAgent stuff would set its KRB5CCNA

Re: Pgadmin4 Debian

2020-05-04 Thread Dave Page
. > > I wonder if this was what was causing pgadmin4 from apt.postgresql.org/ > to not start. > I doubt it. The packages I pointed you to are completely written by scratch, by me. The ones on apt.postgresql.org are very different. > > > > On 2020-04-30 15:07, Dave Page wrote: >

Re: Pgadmin4 Debian

2020-04-30 Thread Dave Page
her items of note: > > > > [pid 10122] connect(18, {sa_family=AF_INET, sin_port=htons(46311), > > sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection > > refused) > > > > There's no firewall rules or other network type access restrictions on > > this box. > > > > For example as my non-root user I can: > > nc -l -s 127.0.0.1 -p 46311 > > > > And then successfully connect to it with another nc > > > > > > > > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Drop Python 2 support in pgAdmin?

2020-04-24 Thread Dave Page
Python 2 has been unsupported for a few months now. Does anyone object to dropping Python 2 support in pgAdmin? This primarily affects our Python package - other installers and packages all use Python 3 I believe. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK

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

2020-04-21 Thread Dave Page
On Tue, Apr 21, 2020 at 1:50 PM richard coleman wrote: > 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 >

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

2020-04-21 Thread Dave Page
tle differences in the settings. It keeps track of the ID of the server from the registry, and if it finds a server listed in the registry doesn't exist, it'll auto-add it (and store the ID so it doesn't duplicate it itself). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: Issue 2519

2020-04-16 Thread Dave Page
Not according to https://redmine.postgresql.org/issues/2519 On Thu, Apr 16, 2020 at 11:19 AM Michael Shapiro wrote: > Any progress on this issue? > > On Thu, Apr 2, 2020 at 6:21 AM Michael Shapiro > wrote: > >> What is the status of https://redmine.postgresql.org/issues/2

Re: Proposal: Drop support for Internet Explorer

2020-04-14 Thread Dave Page
ut Akshay also spotted it before committing:-) > > > On 2020-04-14 7:46 a.m., Dave Page wrote: > > Ooops. Thanks for catching that. Here it is. > > > > On Tue, Apr 14, 2020 at 3:45 PM Neel Patel > <mailto:neel.pa...@enterprisedb.com>> wrote: > > &g

Re: Proposal: Drop support for Internet Explorer

2020-04-14 Thread Dave Page
Ooops. Thanks for catching that. Here it is. On Tue, Apr 14, 2020 at 3:45 PM Neel Patel wrote: > Hi Dave, > > Looks like patch is missing in attachment. > > Thanks, > Neel Patel > > > On Tue 14 Apr, 2020, 6:53 PM Dave Page, wrote: > >> Here's an updated p

Re: Proposal: Drop support for Internet Explorer

2020-04-09 Thread Dave Page
recated or unsupported browser. CCing Akshay for a review :-) -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company Warn_if_using_a_deprecated_or_unsupported_browser.patch Description: Binary data

Re: Proposal: Drop support for Internet Explorer

2020-04-08 Thread Dave Page
just a suspicion. > > Just something to keep in mind, > > rik. > > On Tue, Apr 7, 2020 at 8:00 AM Dave Page wrote: > >> >> >> On Tue, Apr 7, 2020 at 12:41 PM Dave Caughey wrote: >> >>> Check the analytics... I think you'll find dropping

Re: Proposal: Drop support for Internet Explorer

2020-04-07 Thread Dave Page
mplaint from my users. > > Cheers, > Dave > > On Tue., Apr. 7, 2020, 3:36 a.m. Dave Page, wrote: > >> All, >> >> Internet Explorer has long been superseded by Microsoft Edge, and even >> that has recently moved to using Chromium as it's core engine. Version 1

Re: Export Error

2020-04-07 Thread Dave Page
e". Any thoughts? >>> Thanks. >>> >>> Please enable logging and send the pgAdmin log file. Please refer: >> https://www.pgadmin.org/faq/#8 >> >> Thanks, >> Khushboo >> >> >> > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Proposal: Drop support for Internet Explorer

2020-04-07 Thread Dave Page
that we would not test with it, and anyone reporting a bug with it would be told to use an alternate browser. Objections/comments please? Thanks! -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Project server upgrades

2020-04-06 Thread Dave Page
The webserver and developer servers for the pgAdmin project are going to have OS upgrades this afternoon. There maybe some downtime as a result. Regards, Dave. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise

<    1   2   3   4   5   >