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

2017-06-15 Thread Dave Page
dmin.org. You could 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.

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

2017-06-15 Thread Dave Page
ations 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 -- Sent via pgadmin-support maili

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

2017-06-14 Thread Dave Page
> https://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 Friedm

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

2017-06-14 Thread Dave Page
-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: pgAdmin Support > Su

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

2017-06-14 Thread Dave Page
ndows, 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://pgsnake.

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

2017-06-14 Thread Dave Page
On Wed, Jun 14, 2017 at 1:55 PM, Bruno Friedmann 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 wrote: >> > Static resources will be good for caching :-) I would expect to see >> > performance gain

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 wrote: > Hi Dave. > > On Mon, Jun 12, 2017 at 1:38 AM, Dave Page wrote: >> >> Hi >> >> On Sun, Jun 11, 2017 at 6:42 PM, Jack Royal-Gordon >> wrote: >> > Hi, >> > >> > First,

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

2017-06-14 Thread Dave Page
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 Enterprise PostgreSQ

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

2017-06-14 Thread Dave Page
s will significantly 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 mai

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

2017-06-12 Thread Dave Page
dmin 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.enterpri

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

2017-06-12 Thread Dave Page
t; If you have anything promising to tell me in regards 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 th

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

2017-06-07 Thread Dave Page
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 -- Dave Page Blog: http:/

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

2017-06-01 Thread Dave Page
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 Enterpr

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

2017-05-30 Thread Dave Page
On Tue, May 30, 2017 at 8:51 PM, Dave Page wrote: >> >> Khushboo, can you look into this please (and log and RM to go with it >> if required)? >> >> Thanks. >> >> On Tue, May 30, 2017 at 4:09 PM, Richard Greenwood >> wrote: >> > I do

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

2017-05-30 Thread Dave Page
Polygon, 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://www.enterprisedb.com The

Re: [pgadmin-support] pgAdmin4 speed

2017-05-25 Thread Dave Page
On Thu, May 25, 2017 at 4:14 PM, Shira Bezalel wrote: > > On Thu, May 25, 2017 at 1:06 PM, Dave Page wrote: >> >> It's starting to become clear that the speed issues we've had reported >> are specific to the desktop runtime under Windows - which explains why &

Re: [pgadmin-support] pgAdmin4 speed

2017-05-25 Thread Dave Page
g 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 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 Twitter: @pgsnake Enterprise

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

2017-05-22 Thread Dave Page
x27;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 difference. Ashesh

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 wrote: > &g

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

2017-05-19 Thread Dave Page
column in query 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.blogs

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 - in case > of some

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

2017-05-19 Thread Dave Page
On Fri, May 19, 2017 at 7:36 AM, Tomek wrote: > 18 maja 2017 22:43 - "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 >>&g

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 real-estate is poor. I

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

2017-05-12 Thread Dave Page
d 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
(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, > Matt >

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 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.com Twitter: @pgsnake Enterpris

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

2017-05-10 Thread Dave Page
On Wed, May 10, 2017 at 9:32 AM, Mike Surcouf wrote: > Disabling proxy in IE does fix this. > > However I cant do this as I lose internet access. > > Adding localhost or 127..0.0.1 to bypass lsit doesn’t work either. > Interesting. What about adding ::1 to bypass? >

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

2017-05-10 Thread Dave Page
e 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 Enterprise PostgreSQL Company

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

2017-05-09 Thread Dave Page
t; 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.com Twitter: @pgsnake EnterpriseD

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

2017-05-09 Thread Dave Page
x27;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? Wh

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

2017-05-09 Thread Dave Page
e 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. > > > > *From:* Dave P

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

2017-05-08 Thread Dave Page
k on Start menu pgAdmin shortcut > 10. Hangs on splash screen again > 11. Uninstall 1.4 and install 1.3 again > 12. It works again. > > Seems I am stuck at 1.3. > Odd - it works for me on the same platform. Is there a log file left in %APPDATA%\pgAdmin (and if so,

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 was unable to. I told her tha

Re: [pgadmin-support] pgadmin4-1.4

2017-04-19 Thread Dave Page
se 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 Enterprise PostgreSQ

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-04-05 Thread Dave Page
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@postgres

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

2017-04-04 Thread Dave Page
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: Tuesday, Apri

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-04-04 Thread Dave Page
'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 ju

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

2017-04-03 Thread Dave Page
; >> 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 investigations. >> >

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-04-03 Thread Dave Page
he systemd file, > and use ngx_http_uwsgi_module for proxying. but that won't be a generic > solution for other proxy servers. If it won't figure it out automatically as it does with Apache, you could try forcing it by adding: APPLICATION_ROOT='/foo/bar/whizz' to your config_

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-04-03 Thread Dave Page
ugh 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 your subscr

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

2017-03-30 Thread Dave Page
7;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@postgresql.org) To

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

2017-03-30 Thread Dave Page
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.enterprisedb.com

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

2017-03-29 Thread Dave Page
On Wed, Mar 29, 2017 at 12:46 PM, Rich Shepard 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. Installed here are: > >

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

2017-03-29 Thread Dave Page
On Wed, Mar 29, 2017 at 12:19 PM, Rich Shepard wrote: > On Wed, 29 Mar 2017, Dave Page wrote: > >> Have you followed the instructions in the README? > > > Dave, > > Yes. in the section titled, Building. > > "To build the runtime, the following packages mu

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

2017-03-29 Thread Dave Page
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 PostgreSQL Company -- Sent v

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

2017-03-28 Thread Dave Page
ependencies 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 EnterpriseDB UK: http://w

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

2017-03-28 Thread Dave Page
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 > > -- Dave Page Blog: http://pgsnake

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

2017-03-27 Thread Dave Page
d 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
riginal 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://www.ent

Re: [pgadmin-support] pgadmin4 sig?

2017-03-21 Thread Dave Page
Hi On Tue, Mar 21, 2017 at 3:01 PM, Ray Stell 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 " not changed > gp

Re: [pgadmin-support] installation question

2017-03-17 Thread Dave Page
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 in desktop mode. -- Dave

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 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 >> wrote: >>> >>> I have accidentally made my fon

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 wrote: > > > On Mar 14, 2017 8:45 PM, "Dave Page" wrote: > > On Tue, Mar 14, 2017 at 3:12 PM, Khushboo Vashi > wrote: >> >> >> On Mar 14, 2017 8:38 PM, "Dave Page" wrote: >> >> O

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 wrote: > > > On Mar 14, 2017 8:38 PM, "Dave Page" wrote: > > On Tue, Mar 14, 2017 at 2:57 PM, Ness Blackbird > wrote: >> I have accidentally made my font too small on PgAdmin 4 1.2 on Mac. I did >> this by

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

2017-03-14 Thread Dave Page
t; 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 Twitter: @pgsnake Ente

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

2017-03-13 Thread Dave Page
pected 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 Enterpri

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

2017-03-10 Thread Dave Page
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.blogspot.com Twitte

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

2017-03-10 Thread Dave Page
tion 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

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

2017-03-10 Thread Dave Page
lem? >> >> thanks >> >> Attila >> >> >> >> >> -- >> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgadmin-sup

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

2017-03-07 Thread Dave Page
strator 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.enterprisedb.com The Enterprise Postgre

Re: [pgadmin-support] Wrong column ordering in Tree Control

2017-03-03 Thread Dave Page
integer field which it's actual position is lower in > order, > is mistaken placed in top position as the first one. > This has already been fixed for 1.3: https://redmine.postgresql.org/issues/2185 -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake Enterprise

Re: [pgadmin-support] unable to restore database

2017-03-03 Thread Dave Page
n't released with known critical issues. Sometimes issues only show up in certain configurations, and it's impossible for us to test every feasible combination of scenarios. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterpr

Re: [pgadmin-support] unable to restore database

2017-03-03 Thread Dave Page
;> Do you have a suggestion how to use the Backup and Restore tools in >> pgAdmin4? >> Environment: pgAdmin4 1.2, Windows 10 >> >> Regards, Daniel >> >> >> -- >> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) >&

Re: [pgadmin-support] editable views

2017-03-02 Thread Dave Page
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 Enterprise PostgreSQL Company --

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

2017-02-28 Thread Dave Page
ut 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) To make changes to your subscri

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

2017-02-27 Thread Dave Page
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 -- Sent v

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 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/content/documentation/ > Secur

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

2017-02-22 Thread Dave Page
>>> /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current >>>> version 1238.0.0) >>>> >>>> Thank you, >>>> Kind Regards >>>> ~Maciek >>>> >>>> On 21 February 2017 at 14:22, Ashesh Vashi < >

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
; /usr/lib/libssl.1.0.0.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.

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

2017-02-21 Thread Dave Page
Kind Regards > ~Maciek > > On 20 February 2017 at 10:48, Dave Page wrote: >> >> Hi >> >> On Mon, Feb 20, 2017 at 7:43 AM, matshyeq wrote: >> > Hi Dave, >> > >> > Not sure what you meant. I've overwritten app from DMG - same result :(

Re: [pgadmin-support] PgAdmin4 Dmode save layouts

2017-02-20 Thread Dave Page
t: 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 list (p

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

2017-02-17 Thread Dave Page
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@postgres

Re: [pgadmin-support] PG Admin 4 domain

2017-02-16 Thread Dave Page
E = true to ensure 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

Re: [pgadmin-support] PG Admin 4 domain

2017-02-16 Thread Dave Page
.x/server_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
feeling that's not quite 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
ing 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.blogspot.com Twitter: @pg

Re: [pgadmin-support] pgAdmin4 and Archlinux

2017-02-14 Thread Dave Page
hs 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 Jinja2 python module. Th

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

2017-02-10 Thread Dave Page
le Apple 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

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

2017-02-09 Thread Dave Page
y 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 +, D

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 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. -- Dave Page Bl

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-02-01 Thread Dave Page
On Wed, Feb 1, 2017 at 10:20 AM, Ashesh Vashi wrote: > On Wed, Feb 1, 2017 at 3:44 PM, Dave Page wrote: > >> On Wed, Feb 1, 2017 at 10:11 AM, Harshal Dhumal >> wrote: >> > Hi, >> > >> > When I setup my machine with below server setup and without &g

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-02-01 Thread Dave Page
an 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 pgadmin-support mailing list (pgadmin

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

2017-02-01 Thread Dave Page
rtunately 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 EnterpriseD

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

2017-02-01 Thread Dave Page
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@postgresql.org) To make

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

2017-01-31 Thread Dave Page
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 (pgadmin-support@postgresql.org)

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

2017-01-31 Thread Dave Page
I run the runtime/pgAdmin4 directly, same error. > > > If there was some way to run: > > /usr/lib/python3.5/site-packages/pgadmin4-web/pgAdmin4.py, and have it > launch the desktop version, that would do it. I assume the runtime is failing and popping up the dialog box asking f

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

2017-01-30 Thread Dave Page
d one). > I tried 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

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-01-30 Thread Dave Page
admin4 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. -

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

2017-01-18 Thread Dave Page
s($1,$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$SE

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

2017-01-12 Thread Dave Page
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 -- Sent via pgadm

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

2017-01-05 Thread Dave Page
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 at https:/

Re: [pgadmin-support] Restoring Db

2016-12-26 Thread Dave Page
l. > The whole idea of web based db manager is a bit incomplete... jQuery can > not be used for serious and long term supported projects. I am a web > developer and this is based on my practice... > No matter what is my opinion I still want to support pgadmin 4. I can > deliver some q

Re: [pgadmin-support] Date format in dashboard

2016-12-21 Thread Dave Page
a 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://redm

Re: [pgadmin-support] Password change

2016-12-16 Thread Dave Page
ates 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.enterprisedb.com The Enterprise PostgreS

Re: [pgadmin-support] Password change

2016-12-16 Thread Dave Page
nge 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
y distro basis is almost certainly 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 Pag

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
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/pgadmi

  1   2   3   4   5   6   7   8   9   10   >