Re: [pgadmin-support] a bug report: pgAdmin4 only shows splashscreen, no UI, no error

2017-06-15 Thread Dave Page
ould disable that by creating a file called config_local.py alongside config.py in the web/ directory of the installation, containing: UPGRADE_CHECK_ENABLED = False I'll create a ticket to have proxy authentication support added. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @p

Re: [pgadmin-support] a bug report: pgAdmin4 only shows splashscreen, no UI, no error

2017-06-15 Thread Dave Page
n issue with certain configurations of Windows + proxy server. Please try the build at https://developer.pgadmin.org/~dpage/pgadmin4-1.5-x86.exe. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company --

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Dave Page
ttps://xhr.spec.whatwg.org/. > > look like your loading something via ajax with async:false Yeah, that one is on my TODO to fix. > > > -Original Message- > From: Dave Page [mailto:dp...@pgadmin.org] > Sent: 14 June 2017 14:44 > To: Mike Surcouf > Cc: Bruno

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Dave Page
tions/3054060/very-slow-remote-page-load-performance-in-qtwebkit-windows > > -Original Message- > From: pgadmin-support-ow...@postgresql.org > [mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Dave Page > Sent: 14 June 2017 14:17 > To: Bruno Friedmann > Cc:

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Dave Page
n ALL platforms (IE:Mac, > Windows, Linux) before releasing a new version. * > We do. However we're mostly testing in VMs (because it's not always practical for us to have multiple machines) which we expect to be slow, so don't necessarily notice such problems. -- Dave Page Blog: http:/

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Dave Page
On Wed, Jun 14, 2017 at 1:55 PM, Bruno Friedmann <br...@ioda-net.ch> wrote: > On mercredi, 14 juin 2017 10.13:44 h CEST Dave Page wrote: >> On Wed, Jun 14, 2017 at 9:07 AM, Mike Surcouf <mi...@surcouf.co.uk> wrote: >> > Static resources will be good for cach

Re: [pgadmin-support] Serious feedback and questions about the future of pgAdmin.

2017-06-14 Thread Dave Page
Hi On Tue, Jun 13, 2017 at 5:52 PM, Shira Bezalel <sh...@sfei.org> wrote: > Hi Dave. > > On Mon, Jun 12, 2017 at 1:38 AM, Dave Page <dp...@pgadmin.org> wrote: >> >> Hi >> >> On Sun, Jun 11, 2017 at 6:42 PM, Jack Royal-Gordon <jac...@pobox.com> &g

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Dave Page
istent. That hints to me that the network side is what is less performant - obviously the resolver, but I suspect also connection setup which is why I have high hopes for web packing. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Ent

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Dave Page
ignificantly reduce the number of round-trips between the browser and client, as well as the bandwidth required. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing l

Re: [pgadmin-support] Serious feedback and questions about the future of pgAdmin.

2017-06-12 Thread Dave Page
for a "pgAdmin V", taking everything you've learned but improving on it heavily?" To which the answer is that having invested $1M+ in pgAdmin 4, no, we're not going to just ditch it. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.co

Re: [pgadmin-support] Serious feedback and questions about the future of pgAdmin.

2017-06-12 Thread Dave Page
egards to any of this, I'd > like to hear it. In the past, I've looked through the miserable > "alternatives", so it's probably pointless to tell me about any of those, > but if there is some sort of alternative that you know of, which is heavily > polished and maintained and trus

Re: [pgadmin-support] No SQL errors visible in pgAdmin 4 1.5

2017-06-07 Thread Dave Page
"config.py" > and add below config option in it, > FILE_LOG_LEVEL = logging.DEBUG > > Restart pgAdmin4 and try to re-produce the issue again. The file need an import for the logging module won't it? I do it this way: from config import * CONSOLE_LOG_LEVEL = DEBUG FILE_LOG_LEVEL = DEBUG --

Re: [pgadmin-support] remove the older pgAdmin 1.4 that came with the PGSQL installation?

2017-06-01 Thread Dave Page
ll me how to do this. Not with PG 9.6 or below I'm afraid. The PG 10.0 installers will allow component selection though, so you will be able to remove pgAdmin in the future (or only install that, or just command line tools, or whatever). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake

Re: [pgadmin-support] postgis geometry type not displayed correctly

2017-05-30 Thread Dave Page
being translated to "MultiPolygon, 3739". Any ideas or > should I be asking this on the postgis list? > > Thanks, > Rich > > -- > Richard W. Greenwood, PLS > www.greenwoodmap.com -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http:/

Re: [pgadmin-support] pgAdmin4 speed

2017-05-25 Thread Dave Page
;> I'm running the python server script and then using pgAdmin4 in a web >> browser. I suggest that folks who are bothered by the speed (lack of) in >> standalone mode give the server + browser setup a try. The server is >> launched with a single command: >> >>python

Re: [pgadmin-support] Can I use the same sqlite database for update pgadmin4 version?

2017-05-25 Thread Dave Page
On Thu, May 25, 2017 at 9:27 AM, Lazaro Garcia <lazaro3...@gmail.com> wrote: > Hello, for migrating pgadmin4 1.4 to 1.5 can I use the same sqlite database > used with 1.4? Yes, it'll be automatically updated as required. -- Dave Page Blog: http://pgsnake.blogspot.com Twitt

Re: [pgadmin-support] Start of pgAdmin 1.5 takes longer then in 1.4

2017-05-22 Thread Dave Page
issue on Windows that's causing this and some similar reports we've heard of general slowness that just aren't familiar to us. In any case, that doesn't explain the difference between 1.4 and 1.5. I can't see anything in the changelog that I would expect to make a material differenc

Re: [pgadmin-support] Popup message always that PgAdmin 3 starts

2017-05-22 Thread Dave Page
You'd only see that with a debug build. You should rebuild in release mode. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK:http://www.enterprisedb.com The Enterprise PostgreSQL Company > On 22 May 2017, at 14:40, Carlos Eucario <carlos.euca...@gmail.com&

[pgadmin-support] pgAdmin 4 v1.5 Released!

2017-05-19 Thread Dave Page
output For more information, checkout the online documentation [https://www.pgadmin.org/docs/pgadmin4/1.x/], the screenshots [https://www.pgadmin.org/screenshots/], and of course the download page [https://www.pgadmin.org/download/]. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter

Re: [pgadmin-support] making me love pgAdmin III

2017-05-19 Thread Dave Page
On Fri, May 19, 2017 at 10:56 AM, Tomek wrote: >>> You don't care what You users say about Your software??? That's a nice >>> statement... >> >> Twisting my words is a great way to make your point. Kudos. > > Twisting... Saying "I'm not going to lose sleep over it" means what

Re: [pgadmin-support] making me love pgAdmin III

2017-05-19 Thread Dave Page
On Fri, May 19, 2017 at 7:36 AM, Tomek <to...@apostata.org> wrote: > 18 maja 2017 22:43 - "Dave Page" <dp...@pgadmin.org>: > >> On 18 May 2017, at 21:09, Eric Hill <eric.h...@jmp.com> wrote: >> >>> Hey, >>> >>>

Re: [pgadmin-support] making me love pgAdmin III

2017-05-18 Thread Dave Page
> On 18 May 2017, at 21:09, Eric Hill wrote: > > Hey, > > I don’t mean to hurt anyone’s feelings or anything, but is it not obvious to > everyone that pgAdmin 4 (I have version 1.4) is bloody horrendous? It is > absolutely as slow as Christmas. It’s use of screen

Re: [pgadmin-support] pgAdmin 1.4 on Windows 7 x64

2017-05-12 Thread Dave Page
ig. I've created a ticket at https://redmine.postgresql.org/issues/2398 and assigned it to Neel to investigate further. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: [pgadmin-support] Centos 7 missing pgadmin dependency

2017-05-12 Thread Dave Page
nstalled python-passlib (it came from the EPEL repo), I was able > to run pgadmin4 successfully in the Centos desktop (I use Xfce) via the > Application menu. > > Please update the dependencies for pgadmin4-v1 in the RHEL7/Centos7 to > include python-passlib. > > Thanks, > Mat

Re: [pgadmin-support] pgAdmin 1.4 on Windows 7 x64

2017-05-11 Thread Dave Page
On Wed, May 10, 2017 at 10:14 AM, Mike Surcouf <mi...@surcouf.co.uk> wrote: > I cant find any combination of exceptions that works > :-( Any chance you can install Wireshark and see if that gives any clues about what is happening? -- Dave Page Blog: http://pgsnake.blogspot

Re: [pgadmin-support] pgAdmin 1.4 on Windows 7 x64

2017-05-10 Thread Dave Page
out adding ::1 to bypass? > > > *From:* Dave Page [mailto:dp...@pgadmin.org] > *Sent:* 09 May 2017 21:06 > *To:* Mike Surcouf > *Cc:* pgadmin-support@postgresql.org > *Subject:* Re: [pgadmin-support] pgAdmin 1.4 on Windows 7 x64 > > > > > > > > On Tue, May 9, 201

Re: [pgadmin-support] pgAdmin 1.4 on Windows 7 x64

2017-05-10 Thread Dave Page
l worked. I think the next step is to try disabling the proxy. If that works, we then need to figure out a real solution, but at least it'll point us in the right direction. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Ent

Re: [pgadmin-support] pgAdmin 1.4 on Windows 7 x64

2017-05-09 Thread Dave Page
rt and ip of the ping?* > Hmm, OK. It connects to "localhost", but the port number is random for both security reasons and to support multiple users on the same machine. If you disable the proxy server temporarily, does that fix it? -- Dave Page Blog: http://pgsnake.blogspot.c

Re: [pgadmin-support] pgAdmin 1.4 on Windows 7 x64

2017-05-09 Thread Dave Page
it does, it'll hide the splash screen and display the main window. There was a bug in this check which I fixed in 1.4 if memory serves. So, I wonder if there's something in your network setup that's preventing it from responding as expected. What is in your hosts file? Do you have IPv4 enabled?

Re: [pgadmin-support] pgAdmin 1.4 on Windows 7 x64

2017-05-09 Thread Dave Page
expect that to be an issue. > I am installing as administrator for use by non admin user. > Does it run from the admin account you installed it under? Also, long shot but is there anything in the event logs? > > > Sorry I know the above is not much to go on. > > > &g

Re: [pgadmin-support] pgAdmin 1.4 on Windows 7 x64

2017-05-08 Thread Dave Page
A%\pgAdmin (and if so, can you send it)? You may need to remove the 1.3 log first. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: [pgadmin-support] The Synonym Dialog

2017-05-05 Thread Dave Page
Hi > On 5 May 2017, at 21:48, Zhou, Warren wrote: > > Hello, All: > > The online help for pgAdmin 4 has “The Synonym Dialog” in Managing Database > Objects section, and one of our developers wants to create synonyms using the > “The Synonym Dialog” tool, but she

Re: [pgadmin-support] pgadmin4-1.4

2017-04-19 Thread Dave Page
-1.2 > and 4-1.3. These issues have disappeared. You did a great job getting the > installation issues addressed. Thanks for the hard work. > > > > Lance Campbell -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-04-05 Thread Dave Page
path is: ~/.virtualenvs/test/lib/python2.7/site-packages/pgadmin4/pgadmin/__init__.py -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@p

Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load

2017-04-04 Thread Dave Page
gt; Not sure if that's relevant in any way to the to the load issue. There is > still space on the disk.) > > Thanks for your support on this issue. I'll advise if anything changes. > > > Regards, > Peter Johnson > > > -Original Message- From: Dave Page > Sent:

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-04-04 Thread Dave Page
entire config (it'll ignore the pgAdmin specific parts). This is handled in web/pgadmin/__init__.py, around line 144: app.config.from_object(config) app.config.update(dict(PROPAGATE_EXCEPTIONS=True)) I don't know why it's ignoring it - but as I said upthread, I've never had to use it. It just works

Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load

2017-04-03 Thread Dave Page
ut 50% of the time & >> didn't load in the other cases. In the unsuccessful load cases, most, >> but not all, times there was an error msg. >> "Error loading script". But the nominated script varied each time. >> >> Thanks for your continuing investig

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-04-03 Thread Dave Page
fig_local.py (create one alongside config.py if needed). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your su

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-04-03 Thread Dave Page
x well enough to suggest specifics for that server. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to

Re: [pgadmin-support] Building runtime-only pgAdmin4

2017-03-30 Thread Dave Page
gh I honestly don't know about Slackware which Rich was trying to use). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresq

Re: [pgadmin-support] Building runtime-only pgAdmin4

2017-03-30 Thread Dave Page
e a daunting task to configure manually. Why are you trying to build by hand? It's really not expected that end-users do that; it should only be packagers and developers who have to do it that way. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.ente

Re: [pgadmin-support] Building runtime-only pgAdmin4

2017-03-29 Thread Dave Page
On Wed, Mar 29, 2017 at 12:46 PM, Rich Shepard <rshep...@appl-ecosys.com> wrote: > On Wed, 29 Mar 2017, Dave Page wrote: > >> What about the Python parts? > > > Dave, > > Other than Python-2.6 or more recent I don't see other python parts in the > README. I

Re: [pgadmin-support] Building runtime-only pgAdmin4

2017-03-29 Thread Dave Page
how to successfully build a runtime-only > pgAdmin4. Have you followed the instructions in the README? https://git.postgresql.org/gitweb/?p=pgadmin4.git;a=blob;f=README -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgr

Re: [pgadmin-support] pgAdmin 4 Connection to the server has been lost.

2017-03-28 Thread Dave Page
d > shows updated information statistics and dependencies are okay. > > > > On the new server, the properties and sql are shown correctly. > > > > Is there any way to fix this? pgAdmin 4 doesn't support PostgreSQL 9.1. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake

Re: [pgadmin-support] Accessing PgAdmin UI (v4.1.3) through web browser

2017-03-28 Thread Dave Page
wrong credentials (e.g. a bad password), >> or your browser doesn't understand how to supply the credentials required. >> >> Is there some switch in v4.1.3 (MacOS) to change so I can still use web >> browser UI? >> >> Thank you, >> Kind Regards >> ~Maciek >

Re: [pgadmin-support] Copy query from a query tab

2017-03-27 Thread Dave Page
intend to), but it's a significant amount of work. As for the inability copy, that's a bug - please log it at https://redmine.postgresql.org/projects/pgadmin4/issues/new. I took a quick look, but removing the normal classes we use to prevent copying of parts of the UI that really shouldn'

Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load

2017-03-24 Thread Dave Page
gine solves the original problems, it has it's own set. We're currently trying a PoC with another option, as well as thinking through some other ideas... Apologies for the inconvenience in the meantime. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://ww

Re: [pgadmin-support] pgadmin4 sig?

2017-03-21 Thread Dave Page
Hi On Tue, Mar 21, 2017 at 3:01 PM, Ray Stell <ste...@cns.vt.edu> wrote: > Sorry, what's the problem here? Have you changed your gpg key? > > $ gpg --recv 698F1519 > gpg: requesting key 698F1519 from hkp server keyserver.cns.vt.edu > gpg: key 698F1519: "Dave Page <dp

Re: [pgadmin-support] installation question

2017-03-17 Thread Dave Page
s, but it should go under here: > > /usr/lib/python2.7/site-packages/pgadmin4-web/config_local.py > > on RHEL 7. Just to be clear, you should only need to create/edit that if you're trying to setup pgAdmin to run in server mode behind a webserver. It should run out of the box

Re: [pgadmin-support] Font size on PgAdmin 4 1.2 for Mac?

2017-03-14 Thread Dave Page
On Tue, Mar 14, 2017 at 3:20 PM, Ness Blackbird <n...@peoplecanprogram.com> wrote: > Ah! I feel like I've gotten new glasses :) :-) > On 3/14/17 8:07 AM, Dave Page wrote: >> >> On Tue, Mar 14, 2017 at 2:57 PM, Ness Blackbird >> <n...@peoplecanprogram.com> wro

Re: [pgadmin-support] Font size on PgAdmin 4 1.2 for Mac?

2017-03-14 Thread Dave Page
On Tue, Mar 14, 2017 at 3:18 PM, Khushboo Vashi <khushboo.va...@enterprisedb.com> wrote: > > > On Mar 14, 2017 8:45 PM, "Dave Page" <dp...@pgadmin.org> wrote: > > On Tue, Mar 14, 2017 at 3:12 PM, Khushboo Vashi > <khushboo.va...@enterprisedb.com> wrote

Re: [pgadmin-support] Font size on PgAdmin 4 1.2 for Mac?

2017-03-14 Thread Dave Page
On Tue, Mar 14, 2017 at 3:12 PM, Khushboo Vashi <khushboo.va...@enterprisedb.com> wrote: > > > On Mar 14, 2017 8:38 PM, "Dave Page" <dp...@pgadmin.org> wrote: > > On Tue, Mar 14, 2017 at 2:57 PM, Ness Blackbird > <n...@peoplecanprogram.com> wrote:

Re: [pgadmin-support] Font size on PgAdmin 4 1.2 for Mac?

2017-03-14 Thread Dave Page
no menu option to restore the font > size? Do I need to reinstall? Upgrade to 1.3 (there's an issue in the 1.2 build that prevents scaling up again), then press cmd-plus - you may need shift as well to get + instead of =, depending on your keyboard. -- Dave Page Blog: http://pgsnake.blogspot.com

Re: [pgadmin-support] PGAdmin Installation x86 or x64 which is it?

2017-03-13 Thread Dave Page
re was an unexpected delay). If you install using the PostgreSQL installers, then that is how you should upgrade. Various companies/groups offer packages that include pgAdmin, and none of them offer compatibility with other packages. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake

Re: [pgadmin-support] Startup problem pgadmin4 V1.2 on osx 10.10.5 Yosemite

2017-03-10 Thread Dave Page
works when gatekeeper was set to „anywhere“ (at least once) Very weird - I've never seen that on my test machines, which include both 10.9 and 10.12 VMs, snapshotted immediately following a fresh installation so I know I'm testing on a completely clean environment. -- Dave Page Blog: http://pgsnake.

[pgadmin-support] pgAdmin 4 v1.3 Released!

2017-03-10 Thread Dave Page
ion and display of certain data types were also resolved. Changes: https://redmine.postgresql.org/versions/46 Download: https://www.pgadmin.org/download/ Regards, Dave. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake -- Sent via pgadmin-support mailing list (pgadmin-supp

Re: [pgadmin-support] Startup problem pgadmin4 V1.2 on osx 10.10.5 Yosemite

2017-03-10 Thread Dave Page
upport/pgadmin not helped >> >> ist there a solution to this problem? >> >> thanks >> >> Attila >> >> >> >> >> -- >> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) >> To make changes to your subscri

Re: [pgadmin-support] Disable the "Save Password" checkbox in PGAdmin4 1.1

2017-03-07 Thread Dave Page
in config.py that the administrator can override in config_local.py to disable password saving. Please add a feature request at https://redmine.postgresql.org/projects/pgadmin4/issues/new Thanks! -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.en

Re: [pgadmin-support] unable to restore database

2017-03-03 Thread Dave Page
mailing list (pgadmin-support@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgadmin-support > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreS

Re: [pgadmin-support] editable views

2017-03-02 Thread Dave Page
nt when you consider what we might have to do to figure out if a given view is updateable. Please log a feature request on Redmine if there isn't one there already for it. Thanks. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The En

Re: [pgadmin-support] SQL Editor via the View Data context-menu

2017-02-28 Thread Dave Page
the long term (and we intend to), but it's a significant amount of work. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)

Re: [pgadmin-support] python version, desktop mode (pgAdmin4)

2017-02-27 Thread Dave Page
or whatever the correct package name is). I'd strongly suggest using Qt5 though, in which case you want: sudo apt-get install libqt5webkit5-dev -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: [pgadmin-support] Mac OS X error for pgAdmin 4.1.2

2017-02-22 Thread Dave Page
wrote: > > > On Wed, Feb 22, 2017 at 5:19 PM, Dave Page <dp...@pgadmin.org> wrote: > >> So why does it work on my MacOS 10.9 test system? >> >> Right, the link below says that the library validation starts from 10.10 ( > https://developer.apple.com/library

Re: [pgadmin-support] Mac OS X error for pgAdmin 4.1.2

2017-02-22 Thread Dave Page
n 1.0.0, current version 1.2.8) >>>> >>>> /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current >>>> version 1238.0.0) >>>> >>>> Thank you, >>>> Kind Regards >>>> ~Maciek >>>> >>&g

Re: [pgadmin-support] pgAdmin 4.1.2 Windows

2017-02-22 Thread Dave Page
tures NZ > > Telephone Direct (NZ) +64 (0) 3 482 2473 <+64%203-482%202473> > > > > [image: SS with Custom] > > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: [pgadmin-support] Mac OS X error for pgAdmin 4.1.2

2017-02-21 Thread Dave Page
dylib: code signature invalid for '/usr/lib/libssl.1.0.0.dylib' Initial connection failed. Retrying in 2 seconds. Initial connection failed. Retrying in 3 seconds. Initial connection failed. Retrying in 4 seconds. Initial connection failed after multiple attempts. Aborting. On Tue, Feb 21, 20

Re: [pgadmin-support] Mac OS X error for pgAdmin 4.1.2

2017-02-21 Thread Dave Page
k you, > Kind Regards > ~Maciek > > On 20 February 2017 at 10:48, Dave Page <dp...@pgadmin.org> wrote: >> >> Hi >> >> On Mon, Feb 20, 2017 at 7:43 AM, matshyeq <matsh...@gmail.com> wrote: >> > Hi Dave, >> > >> > Not sure wha

Re: [pgadmin-support] PgAdmin4 Dmode save layouts

2017-02-20 Thread Dave Page
iew state. This is on the todo list: https://redmine.postgresql.org/issues/1253 > Is there any way to fix this? Send a patch? :-) -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing

Re: [pgadmin-support] 4th Try: pgadmin4 install, launch fail

2017-02-17 Thread Dave Page
packages/pgadmin4-web/config_local.py LANGUAGES = { 'en': 'English' } EOF -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support

Re: [pgadmin-support] PG Admin 4 domain

2017-02-16 Thread Dave Page
ure that authentication is enabled, otherwise you're opening pgAdmin (and any saved passwords etc) to anyone on your network. For production use, you should use Apache or similar per the instructions I just posted. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: h

Re: [pgadmin-support] PG Admin 4 domain

2017-02-16 Thread Dave Page
deployment.html for running a server deployment. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: [pgadmin-support] PG Admin 4 domain

2017-02-16 Thread Dave Page
uite what you're asking though? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: [pgadmin-support] Auto rollback option

2017-02-14 Thread Dave Page
y - that would change a setting that's been the default for 15 years in pgAdmin 3 & 4 (probably longer, as it was also the default in pgAdmin 1 & 2), in response to a single request. It would help you, but probably confuse a lot of other users. -- Dave Page Blog: http://pgsnake.b

Re: [pgadmin-support] pgAdmin4 and Archlinux

2017-02-14 Thread Dave Page
st couple of months I see nothing like > this, but that may be due to the use of Archlinux. > > So, I'm not pointing at pgAdmin4, but would anyone have any suggestions > about what is going on, or what I must do to locate the problem? It was almost certainly an update to the Jinja

Re: [pgadmin-support] Fwd: where is the Graphical Query Builder on pgAdmin 4 v1.1 for Mac

2017-02-10 Thread Dave Page
LLVM > 8.0.0 (clang-800.0.34)] > Flask Version > 0.11.1 > Application Mode > Desktop > Current User > pgadm...@pgadmin.org > > > > > > > > > > > > > > > > > > > Thank you, > > Susan Leighton > -- Dave Pag

Re: [pgadmin-support] 4th Try: pgadmin4 install, launch fail

2017-02-09 Thread Dave Page
gt; >> My sincere apologies for the typo below; it is unhelpful to add >> errors >> into debug data. >> >> Anyway, I am at your service for further debug attempts. >> >> >> Stan >> >> >> >> On Wed, 2017-02-01 at 09:25 +, Dave

Re: [pgadmin-support] Ctrl+f doesn't work

2017-02-08 Thread Dave Page
On Wed, Feb 8, 2017 at 10:27 AM, Graham Jackson <gjackson...@gmail.com> wrote: > Hi folks, > > Ctrl+f doesn't work in pgadmin 4. Can you help? > > I'm using: > Pgadmin4.1 > Windows 7 professional 64bit Ctrl+F was added in 1.2, which is being released later this week.

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-02-01 Thread Dave Page
On Wed, Feb 1, 2017 at 10:20 AM, Ashesh Vashi <ashesh.va...@enterprisedb.com > wrote: > On Wed, Feb 1, 2017 at 3:44 PM, Dave Page <dp...@pgadmin.org> wrote: > >> On Wed, Feb 1, 2017 at 10:11 AM, Harshal Dhumal >> <harshal.dhu...@enterprisedb.com> wrote: >&g

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-02-01 Thread Dave Page
browser%2Fbrowser.css ? I can reproduce that just by pointing my browser at a dev server (e.g. werkzeug). No Apache or nginx needed. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadm

Re: [pgadmin-support] 4th Try: pgadmin4 install, launch fail

2017-02-01 Thread Dave Page
ime for this :-). Unfortunately I doubt the compile route will help here. The Python code and the runtime are independent pieces of code - the runtime should locate the Python code based on it's configuration, not any build settings. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake E

Re: [pgadmin-support] Building pgadmin4-1.1: Python3 virtual wrapper

2017-02-01 Thread Dave Page
k - it should be virtualenvwrapper not virtualenv-wrapper. Sorry for the inconvenience. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@p

Re: [pgadmin-support] Desktop application don't look well in Windows 10.

2017-01-31 Thread Dave Page
p#6 > Sorry if this not is the way to ask help. It's exactly the right way to ask for help :-) -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (

Re: [pgadmin-support] 4th Try: pgadmin4 install, launch fail

2017-01-30 Thread Dave Page
simply launching the executable in the run dir, but it could not find > pgAdmin4.py. I altered the .ini file to point exactly to the dir where > pgAgmin4.py is, but same error. The .ini file is for configuring the desktop runtime. It won't have any effect on the Python code. -- Dave Pag

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-01-30 Thread Dave Page
pgadmin4 what its base URL is ? You can tell it the directory root (though you shouldn't need to), but I know of no way to give it the base URL. Normally it figures it out itself - but then normally we also wouldn't put Apache behind Nginx, but just setup SSL directly on Apache. -- Dave Page Blog:

Re: [pgadmin-support] Function not displaying PARALLEL SAFE on SQL tab

2017-01-18 Thread Dave Page
2) > $function$; > > > > psql output: > > mydb=# \sf st_intersects (geometry,geometry) > CREATE OR REPLACE FUNCTION public.st_intersects(geom1 geometry, geom2 > geometry) > RETURNS boolean > LANGUAGE sql > IMMUTABLE PARALLEL SAFE > AS $function$SELECT $1

Re: [pgadmin-support] python version, desktop mode (pgAdmin4)

2017-01-12 Thread Dave Page
dmin in it. We don't have any Ubuntu packages for this yet, though you can install the EDB PostgreSQL 9.6 installers which include pgAdmin 4. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: [pgadmin-support] PgAdmin4 crashing on Windows 10

2017-01-05 Thread Dave Page
hit) FROM pg_stat_database WHERE datname = (SELECT > datname FROM pg_database WHERE oid = 3560733)) AS "Hits" > 2017-01-04 15:40:44,819: INFO werkzeug: 127.0.0.1 - - [04/Jan/2017 15:40:44] > "GET /dashboard/bio_stats/3/3560733 HTTP/1.1" 200 - Please try the test build a

Re: [pgadmin-support] Restoring Db

2016-12-26 Thread Dave Page
is no time to develop my self. However I tried > to contact Dave Page and other supporters. No one gives me a procedure how > to participate to the project... I am just sharing my pain :-) Do not want > you to take from your time. > Wishing you happy holidays. > > Kind regards, >

Re: [pgadmin-support] Date format in dashboard

2016-12-21 Thread Dave Page
version 1.0 installation and the timestamps appeared as I > expected them to. I am also using Postgres version 9.2.15. > > It's just a minor issue, but if it could be fixed, that would be great. > > Thanks Thanks for the report - logged, and fixed already :-) https://redmine.po

Re: [pgadmin-support] Password change

2016-12-16 Thread Dave Page
work out how Flask-Security generates the hash). If you can answer my earlier question about where the form submits to, then maybe I can figure out what is preventing it working properly for you. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterpr

Re: [pgadmin-support] Password change

2016-12-16 Thread Dave Page
change the pass using SHH. > > > > SHH? > > > > SSH/Putty. > Oh - that won't really help much, as the password is stored in a hashed form in the configuration database. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: [pgadmin-support] Cannot compile pgadmin4 mainline

2016-12-16 Thread Dave Page
ly a non-starter. There are so many different ways things could be setup, that vary even between different versions of distros that I wouldn't be practical for us to deal with. That's why we try to leave those details up to the packagers. -- Dave Page Blog: http://pgsnake.blogspot

Re: [pgadmin-support] Password change

2016-12-16 Thread Dave Page
ate the host/domain name, but please give the exact paths). > I don’t know. I’m trying, thought, to change the pass using SHH. > SHH? > > > I have no idea how. Any ideas? > > > > > > Thank you > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: [pgadmin-support] Cannot compile pgadmin4 mainline

2016-12-13 Thread Dave Page
1 markm markm 154 Nov 1 13:11 flask_wtf > > > I'm using the same path as last time, but it cannot find what it needs... The Python Path setting should include all directories that have the Python components in them. From what I can see above, shouldn't it be set to /home/markm/.virtualenvs/pg

Re: [pgadmin-support] Cannot compile pgadmin4 mainline

2016-12-12 Thread Dave Page
error: expected ',' or '...' before 'action' > void triggerWebViewWindowEvents(QWebEnginePage::WebAction action); >^ > Makefile:398: recipe for target 'pgAdmin4.o' failed > make: *** [pgAdmin4.o] Error 1 Hmm, seems we missed a macro around that declaration. I've pu

Re: [pgadmin-support] Docs for contributing a patch?

2016-12-07 Thread Dave Page
d. Of course, if you have any further questions, feel free to ask (the pgadmin-hackers list may be a better forum for that sort of discussion). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent

Re: [pgadmin-support] Bug in pgAdmin 3 1.23.0a LTS

2016-12-06 Thread Dave Page
I put a build at https://developer.pgadmin.org/~dpage/pgadmin4-1.1-x86.exe. There's a Mac build there as well for anyone that wants it: https://developer.pgadmin.org/~dpage/pgadmin4-1.1.dmg Both are *completely untested*. On Mon, Dec 5, 2016 at 2:12 AM, Dave Page <dp...@pgadmin.org> wrote

Re: [pgadmin-support] Bug in pgAdmin 3 1.23.0a LTS

2016-12-04 Thread Dave Page
Oh sorry - I forgot there's a change in the required dependencies for Python (so you should roll back your changes). When I'm back in the office tomorrow, I'll see if I can roll you a custom build. Please remind me if I forget! Thanks. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter

Re: [pgadmin-support] Question on deploy from wheel

2016-12-04 Thread Dave Page
Hi That doesn't sound unreasonable on the face of it. Please log a feature request: https://redmine.postgresql.org/projects/pgadmin4/issues/new Thanks. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK:http://www.enterprisedb.com The Enterprise PostgreSQL

Re: [pgadmin-support] Bug in pgAdmin 3 1.23.0a LTS

2016-12-02 Thread Dave Page
On Sat, Dec 3, 2016 at 2:44 AM, Andreas <maps...@gmx.net> wrote: > Am 03.12.2016 um 03:13 schrieb Dave Page: >> >> On Sat, Dec 3, 2016 at 1:41 AM, Andreas <maps...@gmx.net> wrote: >>> >>> Am 03.12.2016 um 02:00 schrieb Dave Page: >>>> >&

  1   2   3   4   5   6   7   8   9   10   >