Re: Navigation through edit screen is very difficult

2018-08-09 Thread Dave Page
min4/issues/new) or better yet, patches are welcome :-) > > Regards > Calle > > On Thu, 9 Aug 2018 at 17:31, Dave Page wrote: > >> >> >> On Thu, Aug 9, 2018 at 3:49 PM, Rob Richardson >> wrote: >> >>> Thank you, but that did not work.

Re: Navigation through edit screen is very difficult

2018-08-09 Thread Dave Page
r the record count value, or should config_local.py just > contain the one line? > It only needs to contain one line. Copying config.py isn't a good idea as it's contents will change when you next upgrade. > > On Thursday, August 9, 2018, 10:27:21 AM EDT, Dave Page > wr

Re: Navigation through edit screen is very difficult

2018-08-09 Thread Dave Page
any one time to 10 million, effectively disabling on demand loading for tables with < 10M rows. Of course, you can adjust that number to something lower (or higher) if you prefer. The default is 1000. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Test - ignore

2018-08-07 Thread Dave Page
1234 -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: [pgagent] Instatallation destination?

2018-07-24 Thread Dave Page
11/share/postgresql/extension/pgagent.co ntrol -- Up-to-date: /Library/PostgreSQL/11/share/postgresql/extension/pgagent.co ntrol -- Installing: /Library/PostgreSQL/11/share/postgresql/extension/pgagent--3 .4--4.0.sql -- Installing: /Library/PostgreSQL/11/share/postgresql/extension/pgagent--u npac

Re: [pgagent] regression test

2018-07-20 Thread Dave Page
Ports doesn't play nicely with /dev/null). Use bash-fu instead. - Add some usage notes to the README file. Thanks again! -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: [pgagent] patch: link with -pthread

2018-07-20 Thread Dave Page
> Neel Patel > > On Fri, Jul 20, 2018 at 4:03 PM, Dave Page wrote: > >> >> >> On Fri, Jul 20, 2018 at 11:12 AM, Christoph Berg wrote: >> >>> Re: Dave Page 2018-07-20 >> isg5-upf...@mail.gmail.com> >>> > Yes, at minimum I suspect

Re: [pgagent] patch: link with -pthread

2018-07-20 Thread Dave Page
On Fri, Jul 20, 2018 at 11:12 AM, Christoph Berg wrote: > Re: Dave Page 2018-07-20 isg5-upf...@mail.gmail.com> > > Yes, at minimum I suspect. Does it complain if it's there on x86 Linux? > > Christoph said he needed it on non-x86 archs. > > It's needed on non-x

Re: [pgagent] patch: link with -pthread

2018-07-20 Thread Dave Page
, 0 failed, 0 skipped == > > Is this only required in case of linux right ? I can work on this - Should > we skip linking in case of Mac and windows ? > Yes, at minimum I suspect. Does it complain if it's there on x86 Linux? Christoph said he needed it on non-x86 arc

Re: [pgagent] Instatallation destination?

2018-07-20 Thread Dave Page
nt--4.0.sql -- Installing: /Library/PostgreSQL/11/share/postgresql/extension/pgagent.control -- Up-to-date: /Library/PostgreSQL/11/share/postgresql/extension/pgagent.control -- Installing: /Library/PostgreSQL/11/share/postgresql/extension/pgagent--3.4--4.0.sql -- Installing: /Library/PostgreSQL/11/share

Re: [pgagent] patch: link with -pthread

2018-07-20 Thread Dave Page
on > That throws a nice warning on macOS (unused-command-line-argument) as I suspected it might. I'll bet Windows barfs on it too. Neel, can you look and see what is the best solution here please? I'm guessing you still have build environments for all platforms from the Boost work you did.

Re: [pgagent] patch: supported cmake version

2018-07-20 Thread Dave Page
5,7 @@ Building pgAgent > > You will need: > > > > - A C/C++ compiler, such as GCC or Microsoft Visual C++ on Windows. > > -- CMake 2.6 (from www.cmake.org) > > +- CMake 3.3 or higher (from www.cmake.org) > > - A Boost library 1.41 or higher installation > &g

Re: Help with pgagent

2018-07-13 Thread Dave Page
t change what the agent is doing mid-job. You'd need to kill the agent and restart it if it's got stuck somehow. It *should* automatically cleanup the zombie job and re-schedule as appropriate. > > Thanks > > AJ > > > > > ‐‐‐ Original Message ‐‐‐ > O

Re: Help with pgagent

2018-07-13 Thread Dave Page
hould have run but did not, please share the data and we may be able to see why. > > Also does anyone have a technical overview of how it works? > Not really, unfortunately. > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: 401 Unauthorized on first run of pgadmin4

2018-07-13 Thread Dave Page
ry to connect without using the security key. Running under the runtime as Khushboo suggests should prevent that happening. In server mode, you should always be redirected to the login page if you need to authenticate (and the security key isn't used). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: Query Tool Initialize Error

2018-07-13 Thread Dave Page
On Fri, Jul 13, 2018 at 1:20 AM, Duffey, Blake > wrote: > >> Launching pgAdmin 4 ver 3.1 against PG 9.5 >> >> >> >> User selects servers, database, schema >> >> >> >> Clicks Tools | Query Tools >> >> >> >> Is immediately

Re: Cannot install pgAdmin 4.1 in Windows Server 8 R2

2018-07-12 Thread Dave Page
r VC Runtime, I get message that > VC Runtime is already installed. > > > > In time: I’m administrator of the machine, and already tried the setup > with “Run as Administrator” and also doesn’t Works. > > > > How to solve this issue? > Did you install the 32bit

Re: pgAgent v4.0.0 Released

2018-07-12 Thread Dave Page
2fiber > Linkedin : https://www.linkedin.com/in/yujie-wang-61a129a0/ > > On Thu, Jul 12, 2018 at 9:00 AM, Dave Page wrote: > >> The pgAdmin Development Team are pleased to announce the release of >> pgAgent v4.0.0. >> >> pgAgent is a job scheduler for Postgre

pgAgent v4.0.0 Released

2018-07-12 Thread Dave Page
"succeeded" flag on job steps which could prevent failure of steps causing the following steps to fail [Sanket Mehta] -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: PA4 - disable dashboard?

2018-07-06 Thread Dave Page
t; I suppose that it's working in that background, so I can disable with > changing to other tab. > > It would be nice if I can hold it, or disable it permanently with key > pressing. > > > Do you know about any option for this? > Just close the tab. -- Dave Page Blo

Re: no grid displayed in Chrome

2018-07-05 Thread Dave Page
nnection is in fact working correctly. > > It seems like maybe there is something in Chrome that is cached that is > messing things up, possibly? Any ideas how to get things working properly > in v3.1? > Possibly. Try holding down Control and clicking the Refresh button to do a hard-re

Re: Accesskey

2018-07-04 Thread Dave Page
> On 4 Jul 2018, at 11:55, Khushboo Vashi > wrote: > > Accesskey specifies the shortcut key(s) to activate/focus an element. For > example, on Linux, it is Alt+Shift, on MacOS it is Ctrl + Alt. Usually :-). It actually depends on what browser is used. > So, if you set the shortcut in pgAdmi

Re: Bytea as "Binary Data"

2018-07-02 Thread Dave Page
o be able to try to detect the data type, so if we find it's actually an image for example, we can display it (and potentially have an editor cell that allows you to replace it). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: pgAdmin 4 v3.1 Released

2018-06-28 Thread Dave Page
> This should contain the missing files and fixes to the wheel requirements. > > Sorry about that - stupid case-sensitivity bug in a script :-( > > > On Thu, Jun 28, 2018 at 1:08 PM, Dave Page wrote: > >> I've found the issue. Working on the fix... >> >> O

Re: pgAdmin 4 v3.1

2018-06-28 Thread Dave Page
; > Dr N D Tucker > > > > Software Architect to Specialised Structures > > > > [image: ss_LR] > > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: pgAdmin 4 v3.1 Released

2018-06-28 Thread Dave Page
- stupid case-sensitivity bug in a script :-( On Thu, Jun 28, 2018 at 1:08 PM, Dave Page wrote: > I've found the issue. Working on the fix... > > On Thu, Jun 28, 2018 at 1:04 PM, Murtuza Zabuawala enterprisedb.com> wrote: > >> Do you have any web server installed? >

Re: pgAdmin 4 v3.1 Released

2018-06-28 Thread Dave Page
/flask/app.py", line >>>>> 1540, in handle_exception >>>>> reraise(exc_type, exc_value, tb) >>>>> File "/usr/local/lib/python3.6/site-packages/flask/_compat.py", >>>>> line 33, in reraise >>>>> raise value &g

pgAdmin 4 v3.1 Released

2018-06-28 Thread Dave Page
are expected to be available on the postgresql.org repositories within the next few days. -- Dave Page pgAdmin Project Lead

Re: ViewData Updates with validations

2018-06-20 Thread Dave Page
ere a way this can be enabled? > Constraints are enforced by the backend database. It is not possible for pgAdmin to bypass them unless it were to explicitly disable them (which it makes no attempt to do). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://

Re: pgAdmin4 - Browser command

2018-06-08 Thread Dave Page
x27;s URL in the default browser, not with the browser command, that is > configured in the "pgAdmin 4 Configuration/Runtime" menu. > This has already been fixed for the next release: https://redmine.postgresql.org/issues/ Thanks! -- Dave Page Blog: http://pgsnake.blogspot.com T

Nightly snapshot builds

2018-05-25 Thread Dave Page
omated and developer testing at commit time). If reporting an issue, please be clear which snapshot you're using. The system will keep the 5 most recent builds at any time. Thanks! -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com

Re: issue running on Windows 2012/Citrix XenApp

2018-05-25 Thread Dave Page
, I just get ‘page cannot be displayed’. This persists even > after a system reboot. If I uninstall 4 v3 and re-install, it works again > (but only that single first time). I can’t seem to get the system to > generate any kind of pgAdmin log file. > > > > Am open to suggesti

Re: Periodic Query Tool Initialize Error

2018-05-25 Thread Dave Page
V3.0 on a Windows 10 desktop and in an Firefox >> 60.0.1 >> browser. >> >> >> >> -- >> Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support >> -f2191615.html >> >> > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: Could SOMEONE please get me off this mailing list?

2018-05-18 Thread Dave Page
dmin-support" header at the top of the message in their web interface? If you're not using the Gmail interface and your MUA doesn't show it, you can inspect the message headers which include the link. Look for the List-Unsubscribe: line. -- Dave Page Blog: http://pgsnake.blogs

Re: SQL_ASCII support (or lack thereof)

2018-05-18 Thread Dave Page
>> SET client_encoding TO SQL_ASCII; >> ALTER DATABASE tms_production >> SET standard_conforming_strings TO off; > > > To replicate the issue; > >- create a table with a text field. > - paste some valid ASCII.1252, but invalid UTF8 data into it. >

Re: SQL_ASCII support (or lack thereof)

2018-05-17 Thread Dave Page
ay be able to figure out the issue and work around it. It's worth noting though that it's usually a bad idea to use SQL_ASCII (that's not intended as an excuse, just as some advice). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: User account and settings storage in other database than SQLite

2018-05-04 Thread Dave Page
of the other things on the todo list. Please do add a feature request to the tracker though (https://redmine.postgresql.org/projects/pgadmin4/issues/new) for future consideration. If you want to work on it yourself, we'll certainly support that. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: User account and settings storage in other database than SQLite

2018-05-03 Thread Dave Page
any way to set up pgAdmin with other database than SQLite? > (Postgresql preferable) > This is not currently possible; however, the usage of SQLite is quite minimal. Have you done any load testing that shows it is actually a bottleneck, or are you speculating at this point? Certainly there will be a

Re: pgadmin4.3 - login failure

2018-04-20 Thread Dave Page
On Fri, Apr 20, 2018 at 1:13 PM, Dave Page wrote: > I've asked the Debian/Ubuntu package maintainer to look into this. > And he tells me that updated packages will be published to the mirrors shortly. > > On Fri, Apr 20, 2018 at 10:23 AM, frankgard familie-gard.de>

Re: pgadmin4.3 - login failure

2018-04-20 Thread Dave Page
> kind of "dirty hack", but be aware that I don't know the "deeper > consequences" of doing so. > > Hope this helps. > > Cheers, > Frank. > > > > -- > Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin- > support-

Re: My pgAdmin is broken

2018-04-20 Thread Dave Page
> transmission and its attachments without reading or saving. Thank you. >> >> >> > > > -- > dme > > > *Derek Ealy* > Sr. Software Architect > > NovaWurks, Inc. > 10772 Noel Street > <https://maps.google.com/?q=10772+Noel+Street%C2%A0+Los+Alamitos,+CA+90720&entry=gmail&source=g> > Los Alamitos, CA 90720 > <https://maps.google.com/?q=10772+Noel+Street%C2%A0+Los+Alamitos,+CA+90720&entry=gmail&source=g> > P: 562.340.6270 <562.340.6270%20x%20700> > F: 877.353.7537 > C: 310.936.4070 <801.319.4613> > > www.novawurks.com > > CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company > confidential information proprietary to NovaWurks Corporation or its > customers and may be confidential, legally privileged, and protected by > law. If you are not the intended recipient you may not use, disclose, > distribute, copy, print, or rely on this e-mail. If you have received this > transmission in error please notify the sender and destroy the original > transmission and its attachments without reading or saving. Thank you. > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: pgAdmin 4 version 3 missing exit button.

2018-04-18 Thread Dave Page
gt; On Wed, Apr 18, 2018 at 1:30 AM, richard coleman < > rcoleman.ascen...@gmail.com> wrote: > >> pgAdmin4 version 3 looks better than the previous versions. There >> appears to be a major oversight, there is no quit/exit/end button. You >> have to g

Re: pgAdmin 4 3.0 - bug when browsing on trigger functions

2018-04-17 Thread Dave Page
/ > pgadmin/browser/server_groups/servers/databases/schemas/functions/__init__.py", > line 1053, in sql > ) + '(' + res['rows'][0]['func_args'] + ')' > KeyError: ‘nspname' > > > Docker version: > Version: 3.0 > Copyright: Copyright 2013 - 2018, The pgAdmin Development Team > Python Version: 3.6.5 (default, Mar 31 2018, 01:52:14) [GCC 6.4.0] > Flask Version: 0.12.2 > Application Mode: Server > Current User: pgad...@example.com > > > Kind Regards, > Alan. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: pgadmin 4 v3.0 installation

2018-04-16 Thread Dave Page
now, and either leave the existing version in place, or run the installer from Add/Remove programs and uninstall the pgAdmin component of PostgreSQL, or, there should be updated PostgreSQL installers available with pgAdmin 4 v3.0 in a few days which you can use to upgrade your PostgreSQL installation. --

pgAdmin 4 v3.0 released!

2018-04-13 Thread Dave Page
for Windows and macOS are available now, along with a Python Wheel, Docker Container and source code tarball from: https://www.pgadmin.org/download/ RPM and DEB packages are expected to be available on the postgresql.org repositories within the next few days. -- Dave Page pgAdmin Project

Re: Faded text in pgAdmin 4 2.0/Win Server 2008r2

2018-03-14 Thread Dave Page
On Wed, Mar 14, 2018 at 11:12 AM, noAnymous < vhwftl1rzizurxvgg...@discardmail.com> wrote: > Hi Dave, > > > Dave Page-7 wrote > > Please try the test build at > > https://developer.pgadmin.org/~dpage/pivotal/pgadmin4-3.0-dev-x86.exe > > did so and the fonts lo

Re: Faded text in pgAdmin 4 2.0/Win Server 2008r2

2018-03-13 Thread Dave Page
blem. Setting the color depth to 32 bit (and restarting pgAdmin4) > resulted the fonts being readable. > > @pgAdmin devs: Please make pgAdmin4 always render readable fonts - also in > 16 bit color depth. THX. > > HTH > > > > -- > Sent from: http://www.postgresql-ar

Re: "The application server could not be contacted" error during start as App-V application.

2018-03-13 Thread Dave Page
believe this is inappropriate. >> >> I'm pretty sure this is the old bug of pgAdmin: >> https://stackoverflow.com/questions/43211296/pgadmin4-postgr >> esql-application-server-could-not-be-contacted/43234250 >> >> There were complaints earlier: >> h

Re: PGAdmin4 2.1 OSX bloat

2018-02-22 Thread Dave Page
>>> 4.app" and Get Info its size, which shows 621.1MB. >>> >>> I'm using Mac OS 10.12 Sierra. >>> >>> Perhaps the PgAdmin application proper is about 184MB as you said, in >>> which case it may be the combined size of that plus s

Re: pgAdmin 4 in an unprivileged lxc container

2018-02-09 Thread Dave Page
m/r/dpage/pgadmin4/? I know it's CentOS based not Debian, but... > > As a consequence, I cannot run the installer as 'root' as it is mapped to > an unprivileged user on the host. All I can do is 'sudo' the commands. > > By the way, does pgAdmin

Re: Revamped runtime vs. Version number

2018-02-01 Thread Dave Page
wrote: > > As Melvin, I am too in favor of "version number to 3.0 for the next > release". > > Paolo > > 2018-02-01 16:00 GMT+01:00 Ashesh Vashi : > >> >> >> On Feb 1, 2018 8:15 PM, "Dave Page" wrote: >> >> So there'

Re: Revamped runtime vs. Version number

2018-02-01 Thread Dave Page
On Thu, Feb 1, 2018 at 3:17 PM, Robert Eckhardt wrote: > > > On Thu, Feb 1, 2018 at 9:45 AM, Dave Page wrote: > >> So there's been nothing but positive feedback about the PoC revamped >> runtime I asked folks on the lists to test. Thank you to everyone that did >

Revamped runtime vs. Version number

2018-02-01 Thread Dave Page
e detected much more quickly. - Cleaned up a bunch of redundant code. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: pgadmin4 from apt.postgresql.org - ubuntu xenial - solved

2018-01-31 Thread Dave Page
brings up a splash screen before failing as described below > > > > > I presume this is the gui version > > But the procedure above activates what I believe is the web version > > Could you confirm my thinking on this Yes, essentially (though in true web mod

Re: pgadmin4 from apt.postgresql.org - ubuntu xenial

2018-01-31 Thread Dave Page
> On 31 Jan 2018, at 20:59, Tony Bazeley wrote: > > Hi all, > > I've tried to install pgadmin4 from apt.postgresql.org and get the error > below. > I'm no python expert but both python-flask and python3-flask packages are > installed. > > Would appreciate any thoughts on what I should try n

Re: Problems on MacOS High Sierra

2018-01-31 Thread Dave Page
equest a hard-copy > version. > > TMLEP may monitor email traffic data and also the content of emails for > compliance purposes and to protect its business. > > > > *From: *Dave Page > *Date: *Wednesday, 31 January 2018 at 13:49 > *To: *Steve Hawes > *Cc: *"pg

Re: Fwd: pgAdmin4 2.1 on apt.postgresql.org

2018-01-31 Thread Dave Page
On Wed, Jan 31, 2018 at 11:48 AM, Christoph Berg wrote: > Re: Dave Page 2018-01-26 khbvpxvjhzqwc48t2qa4l...@mail.gmail.com> > > For those that may not watch -announce > > > > -- Forwarded message -- > > From: Christoph Berg > > Date: Thu,

Re: Problems on MacOS High Sierra

2018-01-31 Thread Dave Page
ve late or incomplete, or contain viruses. > The sender therefore does not accept liability for any errors or omissions > in the contents of this message, which arise as a result of e-mail > transmission. If verification is required please request a hard-copy > version. > > TMLEP may monitor email traffic data and also the content of emails for > compliance purposes and to protect its business. > > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: What pgAdmin version(s) needed these tables/functions?

2018-01-31 Thread Dave Page
gadmin_views > > pgadmin_get_col_def() > pgadmin_get_desc() > pgadmin_get_handler() > pgadmin_get_pgdesc() > pgadmin_get_rows() > pgadmin_get_sequence() > pgadmin_get_type() > > Wow, that takes me back. They're from pgAdmin 1 iirc, and haven't been used in 15+ ye

Re: PGAdmin Version 2.1

2018-01-30 Thread Dave Page
objects like these to be permanently hidden? It's quite reasonable to want to see them - they can be quite useful when writing stored procedures that deal with rows for example. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: PGAdmin Version 2.1

2018-01-30 Thread Dave Page
erything else.* > No - if you switch on "Show system objects", it will display system objects such as row types. That's the whole point of the switch (which is off by default). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: PGAdmin Version 2.1

2018-01-30 Thread Dave Page
-declarations.html#PLPGSQL-DECLARATION-ROWTYPES -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: Request for feedback: Alternate desktop runtime architecture

2018-01-29 Thread Dave Page
browser are you using? > > Aside from that, I'm not seeing anything here of concern. Nice job. > > Anthony > > > On January 23, 2018 at 9:48:43 AM, Dave Page (dp...@pgadmin.org) wrote: > > All, > > As you may know, the most troublesome part of pgAdmin 4 has bee

Fwd: pgAdmin4 2.1 on apt.postgresql.org

2018-01-26 Thread Dave Page
Mönchengladbach Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer pgp fingerprint: 5C48 FE61 57F4 9179 5970 87C6 4C5A 6BAB 12D2 A7AE -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: Request for feedback: Alternate desktop runtime architecture

2018-01-24 Thread Dave Page
orks on Win 7 Enterprise 64 bit. I’ll test on Win >> 10 Enterprise 64 bit tomorrow. Be interesting to see if it will show >> notifications on the Win 10 box. >> >> I’ll test some more tomorrow and send any feedback. >> >> Thanks for all the effort. >> >>

Request for feedback: Alternate desktop runtime architecture

2018-01-23 Thread Dave Page
ept at the moment, for which I would appreciate any feedback. Windows and Mac builds can be found here: https://developer.pgadmin.org/~dpage/runtime-revamp/ and the GIT branch can be found here: https://git.postgresql.org/gitweb/?p=pgadmin4.git;a=shortlog;h=refs/heads/runtime-revamp Thanks! --

Re: Search Objects - redux

2018-01-22 Thread Dave Page
, but I don't know whether it'll work. It should be obvious if not. > > > Stefan > > > > *From: *Dave Page > *Date: *Monday, January 22, 2018 at 2:57 AM > *To: *Stefan Zauchenberger > *Cc: *"pgadmin-support@lists.postgresql.org" postgresql.org>

Re: Search Objects - redux

2018-01-22 Thread Dave Page
Hi On Thu, Jan 18, 2018 at 5:43 PM, Stefan Zauchenberger wrote: > Thanks for the update, Dave. > > Is there anything we can do to help? > Not really, unless you want to work on the feature yourself (which would be more than welcome). > > On Thu, Jan 18, 2018 at 11:14 AM

Re: Search Objects - redux

2018-01-18 Thread Dave Page
t feature soon? > I dream of it as a separate tab with a search bar like in the online help. > Clicking on the items found would jump to the clicked database object in the > tree view. And since I am at it: It would also be nice to have such jumps > from the Dependencies and from the Dependents tab. > Happy computing...Frank > > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: pgAdmin4 v2.1 pip-wheel does not install flask_htmlmin

2018-01-14 Thread Dave Page
: No module named flask_htmlmin > > > > Maybe there was a change at Oct 10, 2017 in requirements.txt without > adding the module to pkg/pip/setup_pip.py . > There was indeed - sorry about that. I've updated the package. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: pgadmin Windows has no option to edit configuration files...

2018-01-12 Thread Dave Page
dangerous and you could easily break a system doing it. It was also quite fragile, as it required the adminpack package which it used to completely re-write the config files, which had to be manually parsed and re-generated in order to (attempt) to keep any comments etc. -- Dave Page Blog: http:

Re: pgAdmin 4 v2.1 released!

2018-01-11 Thread Dave Page
be > built as 64bit - just the downside of having to maintain 2 builds instead > of 1. > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company

Re: pgAdmin 4 v2.1 released!

2018-01-11 Thread Dave Page
On Thu, Jan 11, 2018 at 3:13 PM, André Verwijs wrote: > is there a 64-bit version available for MS-Windows..?? > No, just use the 32bit version. There's no real benefit from having it be built as 64bit - just the downside of having to maintain 2 builds instead of 1. -- Dave Page

pgAdmin 4 v2.1 released!

2018-01-11 Thread Dave Page
also added a new distribution in the form of a Docker Container. See the Docker Hub repo for more information: https://hub.docker.com/r/dpage/pgadmin4/ Download your copy of pgAdmin here: https://www.pgadmin.org/download Regards, Dave -- Dave Page pgAdmin Development Team

Re: pre-configure configuration for use in Docker environment for development

2018-01-10 Thread Dave Page
. This way, > the developer does not have to add a server in pgAdmin each time. > > Is this possible? > Not at present I'm afraid. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: color preferences missing in settings

2018-01-08 Thread Dave Page
On Mon, Jan 8, 2018 at 9:44 AM, Khushboo Vashi < khushboo.va...@enterprisedb.com> wrote: > > > On Mon, Jan 8, 2018 at 3:09 PM, Dave Page wrote: > >> >> >> On Mon, Jan 8, 2018 at 9:37 AM, Khushboo Vashi < >> khushboo.va...@enterprisedb.com> wrot

Re: color preferences missing in settings

2018-01-08 Thread Dave Page
On Mon, Jan 8, 2018 at 9:37 AM, Khushboo Vashi < khushboo.va...@enterprisedb.com> wrote: > > > On Mon, Jan 8, 2018 at 3:00 PM, Dave Page wrote: > >> >> >> On Mon, Jan 8, 2018 at 9:24 AM, Khushboo Vashi < >> khushboo.va...@enterprisedb.com> wrot

Re: color preferences missing in settings

2018-01-08 Thread Dave Page
on 2.0 of pgadmin 4. >> >> Logged the issue. RM #2990 <https://redmine.postgresql.org/issues/2990> > Why? It's not a bug. This feature will be in 2.1: https://redmine.postgresql.org/issues/1383 -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: PGAdmin 4 2.0 fails to read views

2018-01-02 Thread Dave Page
that is man-made or a postGIS view- > like > "geometry_columns". > > Have tried installing PGAdmin 4 on a Win 10 machine as well as on a Win 7 > machine, same issue. > > Before I dig deeper I'd like to query whether this is some sort of known > issue or if I'm ha

Re: Enums printout - possible bug

2017-12-18 Thread Dave Page
> On Mon, Dec 18, 2017 at 3:13 PM, Dave Page wrote: > >> Hi >> >> Looks like there's a TZ issue in the datatype test: >> >> == >> FAIL: runTest (pgadmin.feature_tests.pg_data >&

Re: Faded text in pgAdmin 4 2.0/Win Server 2008r2

2017-12-18 Thread Dave Page
ps://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3FLinkId%3D550986&data=02%7C01%7Cedsonrichter%40hotmail.com%7C0f2373d3290a4291d8c008d538e1c178%7C84df9e7fe9f640afb435%7C1%7C0%7C636477464621270447&sdata=CD7PjVmTG1053sUJy5U%2FCuQqKNFb6VE8XB5cptB

Re: Enums printout - possible bug

2017-12-18 Thread Dave Page
7 at 5:24 PM, Harshal Dhumal < >> harshal.dhu...@enterprisedb.com> wrote: >> >>> >>> -- >>> *Harshal Dhumal* >>> *Sr. Software Engineer* >>> >>> EnterpriseDB India: http://www.enterprisedb.com >>> The Enterprise PostgreSQ

Re: pre-populate pgadmin4 configuration (server, for example)

2017-12-13 Thread Dave Page
which are installed locally but user has to add remote Postgres servers > manually in server list. > > > > Thanks in advance. > Blake > > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: Enums printout - possible bug

2017-12-08 Thread Dave Page
Nice! Thanks. Sent from my iPad > On 9 Dec 2017, at 06:20, Harshal Dhumal > wrote: > > >> On Sat, Dec 9, 2017 at 11:30 AM, Dave Page wrote: >> Hi >> >> Yeah, that one is in my list to work on. Have you specifically tested it >&

Re: Enums printout - possible bug

2017-12-08 Thread Dave Page
t; Thanks, > > > -- > *Harshal Dhumal* > *Sr. Software Engineer* > > EnterpriseDB India: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > On Sat, Dec 9, 2017 at 10:45 AM, Dave Page wrote: > >> Murtuza, can you investigate please? >> >

Re: Enums printout - possible bug

2017-12-08 Thread Dave Page
ion Mode *Desktop > > > > Pg Version: 10.1 > > Regardless this one, many thanks for your great job pgAdmin Team! > > > > > > Best regards, > > *Bartosz Dmytrak* > > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: Faded text in pgAdmin 4 2.0/Win Server 2008r2

2017-11-28 Thread Dave Page
On Fri, Nov 3, 2017 at 9:10 AM, Dave Page wrote: > Quick update on this - no matter what interface we tried, my Windows PC > (which claims to support 4K) refused to talk to a 4K monitor. We've > therefore ordered a Windows laptop with 4K display. I'm travelling for the > ne

Re: pgAdmin 4 | Changing Mail From information!

2017-11-28 Thread Dave Page
; Thank you and best regards, > > > Đỗ Ngọc Trí *Cường* (Mr.) | *Software Development Department* | +84 28 > 3715 5325 <+84%2028%203715%205325> > > -- > *From: *"Murtuza Zabuawala" > *To: *"Đỗ Ngọc Trí Cường" > *Cc:

Re: pgAdmin 4 crash on startup

2017-11-28 Thread Dave Page
Pixel: Not Available > Memory Address: 0xFFB0-0xFFEF > Driver: c:\windows\system32\drivers\vmbusvideom.sys (6.1.7601.17514, > 22.00 KB (22,528 bytes), 2011-05-20 12:34) > > The Virtual Machine is running under Hyper-V on Windows 2008 R2. > > Kind regards, > Gareth Marshall > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: Installing pgAdmin 4 in Runtime Mode (stand alone) in Linux

2017-11-27 Thread Dave Page
> hopefully someone can create official .deb packages now the dependencies > are documented! > Thanks - I've added an item to my todo to improve that part of the docs. > > Kind regards > Floris Sluiter > Human Data Associates > > > On Nov 24, 2017 20:31, "D

Re: pgAdmin 4 | Changing Mail From information!

2017-11-27 Thread Dave Page
> You should be able to set MAIL_DEFAULT_SENDER to an appropriate address in your environment. There is a full list of available config options at http://pythonhosted.org/Flask-Mail/ which should work in addition to those shown in config.py. As a sidenote, you should create config_distro.py (alongside config.py) to contain the required settings. Don't edit config.py itself. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: Installing pgAdmin 4 in Runtime Mode (stand alone) in Linux

2017-11-24 Thread Dave Page
Hi We don’t advise changing config.py as an upgrade will overwrite it. Instead, create a file called config_local.py in the same directory, and put the change in there. That file (if present) is read after config.py and can override the defaults. Thanks for the helpful blogs guys! -- Dave

Re: pgAdmin4 behind HTTPs

2017-11-22 Thread Dave Page
On Wed, Nov 22, 2017 at 8:49 AM, Stefan Tzeggai wrote: > > Hi > > Am 21.11.2017 um 21:09 schrieb Dave Page: > > > > > >> On 21 Nov 2017, at 20:06, Stefan Tzeggai > wrote: > >> > >> Hi > >> > >> I installed pgAdmin4 2

Re: pgAdmin4 behind HTTPs

2017-11-21 Thread Dave Page
> On 21 Nov 2017, at 20:06, Stefan Tzeggai wrote: > > Hi > > I installed pgAdmin4 2.0 in SERVER-Mode. It listens on Port 5050 by default. > > Now I configured Apache2 to proxy external https access to localhost:5050 > >> ProxyPass / http://localhost:5050/ timeout=600 >> ProxyPassRe

Re: Windows testing required: Updated runtime

2017-11-16 Thread Dave Page
and can be moved to a different window, but the following > error was generated and the window was blank. > > > > Cheers, > George > > On 06/07/2017 9:59 AM, Dave Page wrote: > > All, > > I've put an interim build of pgAdmin 4 at https://developer.pgadmin. >

Re: text showing through menu drop down

2017-11-14 Thread Dave Page
g > representation and does not represent the views of Angus Council. Emails > may be monitored for security and network management reasons. Messages > containing inappropriate content may be intercepted. Angus Council does not > accept any liability for any harm that may be caused to

Re: Accessibility Issues with PostgreSQL pgAdmin 1.22.2

2017-11-08 Thread Dave Page
t; if it can be used as effectively by people >> with >> disabilities as by those without./ >> >> >> >> Thank you in advance for all of your help in this matter. >> >> >> >> Laura >> >> >> >> Laura A. Hoffman | CWS >> >> Program Level Systems Engineering (PLSE) >> >> Section 508| DHS OBIM >> >> Office: (202) 637-9699 Ext. 611 >> >> Email: _laura.a.hoff...@associates.ice.dhs.gov_ >> >> >> >> > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: Faded text in pgAdmin 4 2.0/Win Server 2008r2

2017-11-03 Thread Dave Page
t 18, 2017 at 1:18 PM, Dave Page wrote: > Thanks. FYI, I'm now trying to test with a Windows 10 PC as the client, on > a hi-dpi screen. Typically though, the PC and screen are refusing to talk > to each other right now :-(. If that works, I'll have to dig out a copy of >

Re: Output format of explain

2017-11-02 Thread Dave Page
other formats, you can run the explain query directly, e.g. EXPLAIN SELECT ... -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: F5 - irritating behaviour

2017-11-02 Thread Dave Page
> Is there a way to get Ctl-E back as it was on pgadmin3? > I honestly had no idea Ctrl+E worked in pgAdmin III. The documented key was F5 there too. We are looking into the idea of making shortcut keys configurable, so that may solve this. -- Dave Page Blog: http://pgsnake.blogspot.

<    1   2   3   4   5   6   >