Re: Opening queries in new window, record caching when scrolling

[Harshal Dhumal]

On Thu, Jul 20, 2017 at 10:12 AM, Murtuza Zabuawala <
murtuza.zabuaw...@enterprisedb.com> wrote:

>
>
> On Thu, Jul 20, 2017 at 9:56 AM, Ashesh Vashi <
> ashesh.va...@enterprisedb.com> wrote:
>
>>
>> On Thu, Jul 20, 2017 at 6:36 AM, Russell Mercer 
>> wrote:
>>
>>> Hi,
>>>
>>> One of the items that was noted in the release of 1.6 was the ability to
>>> move queries into a new window, allowing for use on multiple screens.  I
>>> was wondering if anyone has been able to make this work.  I've given it a
>>> shot, but seem to be missing a step in the process.
>>>
>>> The one way I've seen to open a new window is by Right Clicking on the
>>> pgAdmin 4 logo at the top left, and choosing the option to Open in a New
>>> Window.  The result of this is a new window, but in the form of a tab
>>> created in the existing window.  Is there a way to break that out
>>> separately to its own window?
>>>
>> You can drag and drop that tab to make it an independant window.
>> Also - you can reattach that window back to the main window by dragging
>> and dropping that window on the main window top area.
>>
>>> I thought with the beta version that Dave Page released shortly before
>>> 1.6 was released, that I had gotten this to work, but now I'm not sure.
>>>
>>> The other feature I wonder about is whether there is a setting to load
>>> the entire result into the window at once.  Right now, when I run a query,
>>> that returns say 13000 rows, it runs successfully.  When I grab the scroll
>>> bar to scroll to the bottom, it runs down through about 1000 records, then
>>> the scroll bar jumps halfway back up again, as it has obviously loaded
>>> another batch of records into the cache.  Is there any setting to change so
>>> that I can scroll to the bottom of the results without having to
>>> continually load records into the cache?  Any input would be much
>>> appreciated.
>>>
>> To load all rows you need to click on grid/column header to select all;
So all rows will be fetched for selection purpose.


[image: Inline image 1]



> To speed up the result loading process, we're loading the result sets on
>> demand.
>> Because - earlier we were loading the whole result set, it was making
>> difficult to render the result set, and it was taking too much time, and
>> cpu to do so.
>>
>> You can always increase the chunk size by following configuration,
>
> 1) Create config_local.py if that is not already present in pgadmin4/web
> folder
>
> 2) Add below in config_local.py and change the value to your one, But
> keep in mind that higher the value, slower the rendering process :)
> *(Default is 1000)*
> ON_DEMAND_RECORD_COUNT = 2000
>
> 3) Restart pgAdmin4 application.
>
>> --
>>
>> Thanks & Regards,
>>
>> Ashesh Vashi
>> EnterpriseDB INDIA: Enterprise PostgreSQL Company
>> 
>>
>>
>> *http://www.linkedin.com/in/asheshvashi*
>> 
>>
>>> For tech details, I'm running this on a Windows 7, Intel i7, 16GB RAM.
>>>
>>> On a personal note, I want to say that the 1.6 release of pgAdmin4 is a
>>> huge step for the software.  It is far more stable, loads faster, and seems
>>> to be approaching parity with what pgAdmin3 offered.  As someone who was
>>> pretty critical of the initial release of the software, I want to
>>> acknowledge that it is clear the developers have been working hard to
>>> address the concerns that were expressed.  It is very much appreciated.
>>>
>> Thanks,
>>>
>>> Russell
>>>
>>
>>
>

Re: Opening queries in new window, record caching when scrolling

[Murtuza Zabuawala]

On Thu, Jul 20, 2017 at 9:56 AM, Ashesh Vashi  wrote:

>
> On Thu, Jul 20, 2017 at 6:36 AM, Russell Mercer 
> wrote:
>
>> Hi,
>>
>> One of the items that was noted in the release of 1.6 was the ability to
>> move queries into a new window, allowing for use on multiple screens.  I
>> was wondering if anyone has been able to make this work.  I've given it a
>> shot, but seem to be missing a step in the process.
>>
>> The one way I've seen to open a new window is by Right Clicking on the
>> pgAdmin 4 logo at the top left, and choosing the option to Open in a New
>> Window.  The result of this is a new window, but in the form of a tab
>> created in the existing window.  Is there a way to break that out
>> separately to its own window?
>>
> You can drag and drop that tab to make it an independant window.
> Also - you can reattach that window back to the main window by dragging
> and dropping that window on the main window top area.
>
>> I thought with the beta version that Dave Page released shortly before
>> 1.6 was released, that I had gotten this to work, but now I'm not sure.
>>
>> The other feature I wonder about is whether there is a setting to load
>> the entire result into the window at once.  Right now, when I run a query,
>> that returns say 13000 rows, it runs successfully.  When I grab the scroll
>> bar to scroll to the bottom, it runs down through about 1000 records, then
>> the scroll bar jumps halfway back up again, as it has obviously loaded
>> another batch of records into the cache.  Is there any setting to change so
>> that I can scroll to the bottom of the results without having to
>> continually load records into the cache?  Any input would be much
>> appreciated.
>>
> To speed up the result loading process, we're loading the result sets on
> demand.
> Because - earlier we were loading the whole result set, it was making
> difficult to render the result set, and it was taking too much time, and
> cpu to do so.
>
> You can always increase the chunk size by following configuration,

1) Create config_local.py if that is not already present in pgadmin4/web
folder

2) Add below in config_local.py and change the value to your one, But keep
in mind that higher the value, slower the rendering process :)
*(Default is 1000)*
ON_DEMAND_RECORD_COUNT = 2000

3) Restart pgAdmin4 application.

> --
>
> Thanks & Regards,
>
> Ashesh Vashi
> EnterpriseDB INDIA: Enterprise PostgreSQL Company
> 
>
>
> *http://www.linkedin.com/in/asheshvashi*
> 
>
>> For tech details, I'm running this on a Windows 7, Intel i7, 16GB RAM.
>>
>> On a personal note, I want to say that the 1.6 release of pgAdmin4 is a
>> huge step for the software.  It is far more stable, loads faster, and seems
>> to be approaching parity with what pgAdmin3 offered.  As someone who was
>> pretty critical of the initial release of the software, I want to
>> acknowledge that it is clear the developers have been working hard to
>> address the concerns that were expressed.  It is very much appreciated.
>>
> Thanks,
>>
>> Russell
>>
>
>

Re: Opening queries in new window, record caching when scrolling

[Ashesh Vashi]

On Thu, Jul 20, 2017 at 6:36 AM, Russell Mercer 
wrote:

> Hi,
>
> One of the items that was noted in the release of 1.6 was the ability to
> move queries into a new window, allowing for use on multiple screens.  I
> was wondering if anyone has been able to make this work.  I've given it a
> shot, but seem to be missing a step in the process.
>
> The one way I've seen to open a new window is by Right Clicking on the
> pgAdmin 4 logo at the top left, and choosing the option to Open in a New
> Window.  The result of this is a new window, but in the form of a tab
> created in the existing window.  Is there a way to break that out
> separately to its own window?
>
You can drag and drop that tab to make it an independant window.
Also - you can reattach that window back to the main window by dragging and
dropping that window on the main window top area.

> I thought with the beta version that Dave Page released shortly before 1.6
> was released, that I had gotten this to work, but now I'm not sure.
>
> The other feature I wonder about is whether there is a setting to load the
> entire result into the window at once.  Right now, when I run a query, that
> returns say 13000 rows, it runs successfully.  When I grab the scroll bar
> to scroll to the bottom, it runs down through about 1000 records, then the
> scroll bar jumps halfway back up again, as it has obviously loaded another
> batch of records into the cache.  Is there any setting to change so that I
> can scroll to the bottom of the results without having to continually load
> records into the cache?  Any input would be much appreciated.
>
To speed up the result loading process, we're loading the result sets on
demand.
Because - earlier we were loading the whole result set, it was making
difficult to render the result set, and it was taking too much time, and
cpu to do so.

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company



*http://www.linkedin.com/in/asheshvashi*


> For tech details, I'm running this on a Windows 7, Intel i7, 16GB RAM.
>
> On a personal note, I want to say that the 1.6 release of pgAdmin4 is a
> huge step for the software.  It is far more stable, loads faster, and seems
> to be approaching parity with what pgAdmin3 offered.  As someone who was
> pretty critical of the initial release of the software, I want to
> acknowledge that it is clear the developers have been working hard to
> address the concerns that were expressed.  It is very much appreciated.
>
Thanks,
>
> Russell
>

Re: Opening queries in new window, record caching when scrolling

[Murtuza Zabuawala]

There is a setting you need to change to open query tool in new window.

Goto:
'File' -> 'Preferences' -> 'SQL Editor' -> 'Open in new browser tab'
(Set this option to True)

[image: Inline image 1]

Regarding loading the result at once, loading the result  in chunks helps
us improve the performance in server-client architecture.

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Thu, Jul 20, 2017 at 6:36 AM, Russell Mercer 
wrote:

> Hi,
>
> One of the items that was noted in the release of 1.6 was the ability to
> move queries into a new window, allowing for use on multiple screens.  I
> was wondering if anyone has been able to make this work.  I've given it a
> shot, but seem to be missing a step in the process.
>
> The one way I've seen to open a new window is by Right Clicking on the
> pgAdmin 4 logo at the top left, and choosing the option to Open in a New
> Window.  The result of this is a new window, but in the form of a tab
> created in the existing window.  Is there a way to break that out
> separately to its own window?  I thought with the beta version that Dave
> Page released shortly before 1.6 was released, that I had gotten this to
> work, but now I'm not sure.
>
> The other feature I wonder about is whether there is a setting to load the
> entire result into the window at once.  Right now, when I run a query, that
> returns say 13000 rows, it runs successfully.  When I grab the scroll bar
> to scroll to the bottom, it runs down through about 1000 records, then the
> scroll bar jumps halfway back up again, as it has obviously loaded another
> batch of records into the cache.  Is there any setting to change so that I
> can scroll to the bottom of the results without having to continually load
> records into the cache?  Any input would be much appreciated.
>
> For tech details, I'm running this on a Windows 7, Intel i7, 16GB RAM.
>
> On a personal note, I want to say that the 1.6 release of pgAdmin4 is a
> huge step for the software.  It is far more stable, loads faster, and seems
> to be approaching parity with what pgAdmin3 offered.  As someone who was
> pretty critical of the initial release of the software, I want to
> acknowledge that it is clear the developers have been working hard to
> address the concerns that were expressed.  It is very much appreciated.
>
> Thanks,
>
> Russell
>

Opening queries in new window, record caching when scrolling

[Russell Mercer]

Hi, 

One of the items that was noted in the release of 1.6 was the ability to
move queries into a new window, allowing for use on multiple screens.  I
was wondering if anyone has been able to make this work.  I've given it
a shot, but seem to be missing a step in the process. 

The one way I've seen to open a new window is by Right Clicking on the
pgAdmin 4 logo at the top left, and choosing the option to Open in a New
Window.  The result of this is a new window, but in the form of a tab
created in the existing window.  Is there a way to break that out
separately to its own window?  I thought with the beta version that Dave
Page released shortly before 1.6 was released, that I had gotten this to
work, but now I'm not sure. 

The other feature I wonder about is whether there is a setting to load
the entire result into the window at once.  Right now, when I run a
query, that returns say 13000 rows, it runs successfully.  When I grab
the scroll bar to scroll to the bottom, it runs down through about 1000
records, then the scroll bar jumps halfway back up again, as it has
obviously loaded another batch of records into the cache.  Is there any
setting to change so that I can scroll to the bottom of the results
without having to continually load records into the cache?  Any input
would be much appreciated. 

For tech details, I'm running this on a Windows 7, Intel i7, 16GB RAM. 

On a personal note, I want to say that the 1.6 release of pgAdmin4 is a
huge step for the software.  It is far more stable, loads faster, and
seems to be approaching parity with what pgAdmin3 offered.  As someone
who was pretty critical of the initial release of the software, I want
to acknowledge that it is clear the developers have been working hard to
address the concerns that were expressed.  It is very much appreciated. 

Thanks, 

Russell

Re: Scrolling vs. pagination

[J Payne]

Oh that’s great news, thanks so much!  

 

John

 

 

From: Dave Page 
Date: Tuesday, July 18, 2017 at 11:44 PM
To: John Payne 
Cc: pgAdmin Support 
Subject: Re: Scrolling vs. pagination

 

The screenshots need updating. Iirc, we got rid of pagination before we 
released v1.0. The query tool is fully scrolled and much faster than pgAdmin 3 
for large result sets now.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK:http://www.enterprisedb.com
The Enterprise PostgreSQL Company


On 18 Jul 2017, at 22:56, J Payne  wrote:

I haven’t used pgAdmin 4 in quite some time, but I checked out the web page 
today and I see from the screenshots that the output is still paginated for 
simple queries (like “SELECT * FROM mytable”).  For me, that is a deal breaker. 
 Although pgAdmin3 certainly has issues, being able to effortlessly scroll 
through a long list is still far, far better than any sort of pagination could 
ever be.  

 

Although scrolling can be avoided by writing detailed queries, scrolling is 
extremely useful for flicking through a table to get a feeling for what’s in 
it, how many missing values there are, and to catch bad entries (especially if 
you have no idea what the bad variants might be).  It’s even useful with giant 
tables of hundreds of thousands or millions of rows: although no-one would want 
to scroll through every row, it still gives you a nearly-instant snapshot.  

 

I assume that there are others, perhaps many, who feel as I do, and I beg the 
pgAdmin4 team to consider making query output a single-page scrolling list.  
More august personalities than I am have commented on why scrolling should be 
preferred to pagination.  Here is Mike Bostock of D3 fame, for example: 
https://bost.ocks.org/mike/scroll/.

 

Thanks,

 

John

 

Re: Consider default SERVER_MODE =True for pgadmin4-v1-web

[Dave Page]

On Wed, Jul 19, 2017 at 5:07 PM, Mike Surcouf  wrote:

> Hi Dave thanks for reply
>
>
>
> In what scenario are the web components used in desktop mode.
>

The core of the application (like, 97% of it) is the web code. The desktop
runtime is just a python interpreter with a web browser attached, that runs
the python web code, and then renders it.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

RE: Consider default SERVER_MODE =True for pgadmin4-v1-web

[Mike Surcouf]

Here is my setup script for pgadmin in server mode on Centos 7 using the docs 
as a base.

It may or may not be useful

--
#Install pgadmin
yum -y install pgadmin4-v1-web
yum -y install python-passlib

#Create user for pgadmin
useradd --create-home --home-dir /var/pgadmin --system --shell /sbin/nologin 
pgadmin
#Allow apache access to the pgadmin home directory
semanage fcontext -a -t httpd_sys_rw_content_t "/var/pgadmin(/.*)?"
restorecon -R /var/pgadmin

#Allow pgadmin to connect to postgres
setsebool -P httpd_can_network_connect_db 1

#Overide SERVER_MODE (must be done BEFORE setup)
cat >> /usr/lib/python2.7/site-packages/pgadmin4-web/config_local.py << "EOF"
SERVER_MODE = True
EOF

#Add default username and password and setup database
su -s /bin/sh -c 'python 
/usr/lib/python2.7/site-packages/pgadmin4-web/setup.py' pgadmin

#Add apache configuration
cat >> /etc/httpd/conf.d/pgadmin4-v1.conf << "EOF"
CustomLog "logs/pgadmin-access_log" combined
ErrorLog "logs/pgadmin-error_log"
LogLevel error

WSGIDaemonProcess pgadmin processes=1 threads=25 user=pgadmin group=pgadmin
WSGIScriptAlias /pgadmin4 
/usr/lib/python2.7/site-packages/pgadmin4-web/pgAdmin4.wsgi


WSGIProcessGroup pgadmin
WSGIApplicationGroup %{GLOBAL}
Require all granted

EOF

#Open firewall for pgadmin
firewall-cmd --permanent --zone=public --add-port=80/tcp
firewall-cmd --permanent --zone=public --add-port=443/tcp
firewall-cmd --reload

#Start apache
systemctl enable httpd.service
systemctl start httpd.service
--



From: Dave Page [mailto:dp...@pgadmin.org]
Sent: 19 July 2017 17:03
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Consider default SERVER_MODE =True for pgadmin4-v1-web



On Wed, Jul 19, 2017 at 4:54 PM, Mike Surcouf 
mailto:mi...@surcouf.co.uk>> wrote:
It would be nice if the pgadmin40v1-web package set the SERVER_MODE  = True

I can't think why you would install the web package without this but there may 
be a reason?

Yes, it would break the default installation mode (desktop).

The web package is "the web components of pgadmin", not "pgadmin to run in web 
mode".

Also since the setup script does different things depending on this value if 
you don't do it first you have to delete the config and sqllite database and 
start again otherwise it will never work

Currently I have this in my setup script

#Overide SERVER_MODE (must be done BEFORE setup)
cat >> /usr/lib/python2.7/site-packages/pgadmin4-web/config_local.py << "EOF"
SERVER_MODE = True
EOF

I tend to just edit that setting in config_local.py as I need it, but then also 
include:

# Use a different config DB for each server mode.
if SERVER_MODE == False:
SQLITE_PATH = os.path.join(
DATA_DIR,
'pgadmin4-desktop.db'
)
else:
SQLITE_PATH = os.path.join(
DATA_DIR,
'pgadmin4-server.db'
)

Anyway, to the main point - I've been trying to figure out a half-decent way of 
being able to support both server and desktop modes out of the box; and have 
yet to come up with anything that wouldn't be a tangled mess of config files. I 
still have some ideas though, and hope to explore them some more tomorrow.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

RE: Consider default SERVER_MODE =True for pgadmin4-v1-web

[Mike Surcouf]

Hi Dave thanks for reply

In what scenario are the web components used in desktop mode.
Sorry if I I keep banging on about it

From: Dave Page [mailto:dp...@pgadmin.org]
Sent: 19 July 2017 17:03
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Consider default SERVER_MODE =True for pgadmin4-v1-web



On Wed, Jul 19, 2017 at 4:54 PM, Mike Surcouf 
mailto:mi...@surcouf.co.uk>> wrote:
It would be nice if the pgadmin40v1-web package set the SERVER_MODE  = True

I can't think why you would install the web package without this but there may 
be a reason?

Yes, it would break the default installation mode (desktop).

The web package is "the web components of pgadmin", not "pgadmin to run in web 
mode".

Also since the setup script does different things depending on this value if 
you don't do it first you have to delete the config and sqllite database and 
start again otherwise it will never work

Currently I have this in my setup script

#Overide SERVER_MODE (must be done BEFORE setup)
cat >> /usr/lib/python2.7/site-packages/pgadmin4-web/config_local.py << "EOF"
SERVER_MODE = True
EOF

I tend to just edit that setting in config_local.py as I need it, but then also 
include:

# Use a different config DB for each server mode.
if SERVER_MODE == False:
SQLITE_PATH = os.path.join(
DATA_DIR,
'pgadmin4-desktop.db'
)
else:
SQLITE_PATH = os.path.join(
DATA_DIR,
'pgadmin4-server.db'
)

Anyway, to the main point - I've been trying to figure out a half-decent way of 
being able to support both server and desktop modes out of the box; and have 
yet to come up with anything that wouldn't be a tangled mess of config files. I 
still have some ideas though, and hope to explore them some more tomorrow.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: Consider default SERVER_MODE =True for pgadmin4-v1-web

[Dave Page]

On Wed, Jul 19, 2017 at 4:54 PM, Mike Surcouf  wrote:

> It would be nice if the pgadmin40v1-web package set the SERVER_MODE  = True
>
> I can't think why you would install the web package without this but there
> may be a reason?
>

Yes, it would break the default installation mode (desktop).

The web package is "the web components of pgadmin", not "pgadmin to run in
web mode".


> Also since the setup script does different things depending on this value
> if you don't do it first you have to delete the config and sqllite database
> and start again otherwise it will never work
>
> Currently I have this in my setup script
>
> #Overide SERVER_MODE (must be done BEFORE setup)
> cat >> /usr/lib/python2.7/site-packages/pgadmin4-web/config_local.py <<
> "EOF"
> SERVER_MODE = True
> EOF
>

I tend to just edit that setting in config_local.py as I need it, but then
also include:

# Use a different config DB for each server mode.
if SERVER_MODE == False:
SQLITE_PATH = os.path.join(
DATA_DIR,
'pgadmin4-desktop.db'
)
else:
SQLITE_PATH = os.path.join(
DATA_DIR,
'pgadmin4-server.db'
)

Anyway, to the main point - I've been trying to figure out a half-decent
way of being able to support both server and desktop modes out of the box;
and have yet to come up with anything that wouldn't be a tangled mess of
config files. I still have some ideas though, and hope to explore them some
more tomorrow.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Consider default SERVER_MODE =True for pgadmin4-v1-web

[Mike Surcouf]

It would be nice if the pgadmin40v1-web package set the SERVER_MODE  = True

I can't think why you would install the web package without this but there may 
be a reason?
Also since the setup script does different things depending on this value if 
you don't do it first you have to delete the config and sqllite database and 
start again otherwise it will never work

Currently I have this in my setup script

#Overide SERVER_MODE (must be done BEFORE setup)
cat >> /usr/lib/python2.7/site-packages/pgadmin4-web/config_local.py << "EOF"
SERVER_MODE = True
EOF

Thanks

Mike

RE: Cant browse servers after update to pgadmin 1.6 (server version)

[Mike Surcouf]

Hi Devrim

Testing as it will be used i.e. remotely via the path 
http://someserver/pgadmin4 would have shown up this.
I hope testing methodology can be changed so that the server mode is tested too.
Even having a previous setup version and running yum update would help to catch 
this type of stuff and wouldn’t require much effort.

Thanks

Mike

-Original Message-
From: Devrim Gündüz [mailto:dev...@gunduz.org] 
Sent: 19 July 2017 15:59
To: Mike Surcouf; 'Murtuza Zabuawala'
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)


Hi,

On Wed, 2017-07-19 at 13:03 +, Mike Surcouf wrote:
> Is dev...@gunduz.org testing these repos by 
> installing in the app path eg (pgadmin4) as per the docs?

At some point, yes, but not fully. I do more tests on my Fedora box.

Regards,
--
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red 
Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: Cant browse servers after update to pgadmin 1.6 (server version)

[Devrim Gündüz]

Hi,

On Wed, 2017-07-19 at 13:03 +, Mike Surcouf wrote:
> Is dev...@gunduz.org testing these repos by
> installing in the app path eg (pgadmin4) as per the docs?

At some point, yes, but not fully. I do more tests on my Fedora box.

Regards,
-- 
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part

RE: New font for testing in Query Editor tool

[Mike Surcouf]

> Menlo only applies for Macs, Consolas is the new proposed font for Windows.

How are you going to tell what OS.
Bear in mind the server version (which I find runs much better than desktop) 
only has the concept of a browser agent.
I think the concept of specific font on a cross platform tool is not good IMHO.

As long as you fall back to

font-family: “monospace”;


From: Shirley Wang [mailto:sw...@pivotal.io]
Sent: 19 July 2017 15:10
To: matshyeq; Dave Page
Cc: Mike Surcouf; Anthony DeBarros; pgAdmin Support
Subject: Re: New font for testing in Query Editor tool

Thanks for the feedback everyone
On Wed, Jul 19, 2017 at 8:18 AM matshyeq 
mailto:matsh...@gmail.com>> wrote:
Just a thought, if v4 is web based - why don't you use webfonts, like whatever 
is available on https://fonts.google.com/?category=Monospace
with the option to fall back to the old ones?
Also, could this be easily configurable?

I had only ever used the hosted versions of Google fonts so I wrote off this 
option for cases where there is no internet connection. However it does seem 
like you can download them - we can potentially package the application with a 
Google font rather than rely on native fonts that come with the OS.



Monospace, which we currently use, and Menlo, the proposed new default.

Menlo only applies for Macs, Consolas is the new proposed font for Windows.



On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros 
mailto:adebar...@gmail.com>> wrote:
I like it! I agree with the earlier poster that the line height could be 
decreased -- but not by much. Perhaps a pixel or two.

Yeah, something was bugging me about it too - I think it was the line height.


Yeah, line height is a little wonky now because we're working with two fonts 
with different x-heights. I'm looking into Google fonts now, it would be so 
great if both applications could rely on the same font.

RE: uninstalling pgadmin4 version 1.0

[Gillian Walker]

Brilliant – many thanks.

 

From: Dave Page [mailto:dp...@pgadmin.org] 
Sent: 19 July 2017 14:32
To: Gillian Walker
Cc: pgadmin-support@lists.postgresql.org
Subject: Re: uninstalling pgadmin4 version 1.0

 

Hi

 

On Wed, Jul 19, 2017 at 1:37 PM, Gillian Walker  wrote:

Hi

I have pgAdmin4 version 1.0 running on a windows 7 machine – I would like to 
uninstall it and put on the latest version.  It is installed in C:\Program 
Files\PostgreSQL\9.6\pgAdmin4 – I can find no uninstall exe within the pgAdmin4 
folder and the program is not listed in the ‘Uninstall or change program’ 
option from the control panel.  Can anyone tell me how to completely uninstall 
it?  Many thanks.

Gillian

 

That is installed as a component of PostgreSQL, so you cannot remove it without 
removing PostgreSQL. You can either: install the new version from the 
standalone installer, which will happily co-exist with the one from the 
PostgreSQL package, or upgrade PostgreSQL to the latest release which will also 
upgrade pgAdmin. I believe at the moment it would get you v1.5, but an update 
to the PostgreSQL installer with pgAdmin 1.6. should be available in the next 
few days.



 

-- 

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: New font for testing in Query Editor tool

[Shirley Wang]

Thanks for the feedback everyone

On Wed, Jul 19, 2017 at 8:18 AM matshyeq  wrote:

> Just a thought, if v4 is web based - why don't you use webfonts, like
> whatever is available on https://fonts.google.com/?category=Monospace
> with the option to fall back to the old ones?
> Also, could this be easily configurable?
>

I had only ever used the hosted versions of Google fonts so I wrote off
this option for cases where there is no internet connection. However it
does seem like you can download them - we can potentially package the
application with a Google font rather than rely on native fonts that come
with the OS.



>>>
>>> Monospace, which we currently use, and Menlo, the proposed new default.
>>>
>>
Menlo only applies for Macs, Consolas is the new proposed font for Windows.


>
>>>
>>>
>>> On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros 
>>> wrote:
>>>
>>> I like it! I agree with the earlier poster that the line height could be
>>> decreased -- but not by much. Perhaps a pixel or two.
>>>
>>>
>>>
>>> Yeah, something was bugging me about it too - I think it was the line
>>> height.
>>>
>>>
>>>
>>>
Yeah, line height is a little wonky now because we're working with two
fonts with different x-heights. I'm looking into Google fonts now, it would
be so great if both applications could rely on the same font.

Cant browse servers after update to pgadmin 1.6 (server version)

[Lazaro Garcia]

A have the same issue after update to 1.6, pgadmin is under apache web server. 
The console developer browser throws 404 on these resources because may site is 
under pgadmin directory not on the server root:

 

http://dev.pgpadmin/preferences/get_all

 

http://dev.pgpadmin/browser/nodes/

 

http://dev.pgpadmin/settings/store

 

http://dev.pgpadmin/misc/bgprocess/

 

http://dev.pgpadmin/settings/store

 

Al those folders are under ../pgadmin/web/pgadmin/(preferences, browser, 
settings, misc)

 

Is there any way to solve that?

Where is the line in the code to change that?

 

Regards.

 

De: Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com] 
Enviado el: miércoles, 19 de julio de 2017 08:55 a. m.
Para: Khushboo Vashi
CC: Mike Surcouf; pgadmin-supp...@postgresql.org
Asunto: Re: Cant browse servers after update to pgadmin 1.6 (server version)

 

 

 

On Wed, Jul 19, 2017 at 6:16 PM, Khushboo Vashi 
mailto:khushboo.va...@enterprisedb.com> > 
wrote:

On Wed, Jul 19, 2017 at 6:10 PM, Murtuza Zabuawala 
mailto:murtuza.zabuaw...@enterprisedb.com> 
> wrote:

Okay, I think this is a bug with 1.6.

 

Found similar issue: https://redmine.postgresql.org/issues/2563

 

So, as per this RM information, you can change the WSGIScriptAlias from 
/pgadmin4 to / to fix this issue.




Yes, This is a work around.

But we also have to fix this issue at code level to honour the virtual 
DirectoryRoot path :)

--

Regards,

Murtuza Zabuawala
EnterpriseDB:   http://www.enterprisedb.com
The Enterprise PostgreSQL Company

 

On Wed, Jul 19, 2017 at 6:03 PM, Mike Surcouf mailto:mi...@surcouf.co.uk> > wrote:

Still the same 

  

Tested in IE 11 and CHrome 

  

Am I picking up a early webpack preview from the repo? 

  

All I did was a yum update 

  

It seems there paths for require are not correct (missing a level pgadm4) 

  

  

  

From: Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com 
 ] 
Sent: 19 July 2017 13:27
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org  
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version) 

  

Can you clear the browser cache with hard reset and try again? 

  



  

-- 

Regards, 

Murtuza Zabuawala
EnterpriseDB:   http://www.enterprisedb.com
The Enterprise PostgreSQL Company 

  

On Wed, Jul 19, 2017 at 5:48 PM, Mike Surcouf mailto:mi...@surcouf.co.uk> > wrote: 

wcDocker.min.js:42 exported wcDocker 

jquery-1.11.2.min.js:4 GET http://aesdata01/preferences/get_all 404 (Not Found) 

send @ jquery-1.11.2.min.js:4 

ajax @ jquery-1.11.2.min.js:4 

cache_preferences @ browser.js:953 

init @ browser.js:357 

(anonymous) @ (index):280 

execCb @ require.min.js:29 

check @ require.min.js:18 

(anonymous) @ require.min.js:23 

(anonymous) @ require.min.js:8 

(anonymous) @ require.min.js:23 

v @ require.min.js:7 

emit @ require.min.js:23 

check @ require.min.js:19 

(anonymous) @ require.min.js:23 

(anonymous) @ require.min.js:8 

(anonymous) @ require.min.js:23 

v @ require.min.js:7 

emit @ require.min.js:23 

check @ require.min.js:19 

(anonymous) @ require.min.js:23 

(anonymous) @ require.min.js:8 

(anonymous) @ require.min.js:23 

v @ require.min.js:7 

emit @ require.min.js:23 

check @ require.min.js:19 

(anonymous) @ require.min.js:23 

(anonymous) @ require.min.js:8 

(anonymous) @ require.min.js:23 

v @ require.min.js:7 

emit @ require.min.js:23 

check @ require.min.js:19 

enable @ require.min.js:23 

init @ require.min.js:17 

E @ require.min.js:14 

completeLoad @ require.min.js:28 

onScriptLoad @ require.min.js:29 

jquery-1.11.2.min.js:4 GET http://aesdata01/browser/nodes/ 404 (Not Found) 

send @ jquery-1.11.2.min.js:4 

ajax @ jquery-1.11.2.min.js:4 

(anonymous) @ jquery.aciTree.min.js:17 

k @ jquery.aciTree.min.js:17 

(anonymous) @ jquery.aciTree.min.js:17 

jquery-1.11.2.min.js:4 POST http://aesdata01/settings/store 404 (Not Found) 

send @ jquery-1.11.2.min.js:4 

ajax @ jquery-1.11.2.min.js:4 

save_current_layout @ browser.js:342 

(anonymous) @ browser.js:403 

__trigger @ wcDocker.min.js:34 

__moveEnd @ wcDocker.min.js:34 

jquery-1.11.2.min.js:4 POST http://aesdata01/settings/store 404 (Not Found) 

send @ jquery-1.11.2.min.js:4 

ajax @ jquery-1.11.2.min.js:4 

save_current_layout @ browser.js:342 

(anonymous) @ browser.js:403 

__trigger @ wcDocker.min.js:34 

__moveEnd @ wcDocker.min.js:34 

  

From: Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com 
 ] 
Sent: 19 July 2017 13:14
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org  
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version) 

  

Can you please open browser developer tool 
  and check the Console tab if there is 
any error on console whe

Re: uninstalling pgadmin4 version 1.0

[Dave Page]

Hi

On Wed, Jul 19, 2017 at 1:37 PM, Gillian Walker  wrote:

> Hi
>
> I have pgAdmin4 version 1.0 running on a windows 7 machine – I would like
> to uninstall it and put on the latest version.  It is installed in
> C:\Program Files\PostgreSQL\9.6\pgAdmin4 – I can find no uninstall exe
> within the pgAdmin4 folder and the program is not listed in the ‘Uninstall
> or change program’ option from the control panel.  Can anyone tell me how
> to completely uninstall it?  Many thanks.
>
> Gillian
>

That is installed as a component of PostgreSQL, so you cannot remove it
without removing PostgreSQL. You can either: install the new version from
the standalone installer, which will happily co-exist with the one from the
PostgreSQL package, or upgrade PostgreSQL to the latest release which will
also upgrade pgAdmin. I believe at the moment it would get you v1.5, but an
update to the PostgreSQL installer with pgAdmin 1.6. should be available in
the next few days.


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

uninstalling pgadmin4 version 1.0

[Gillian Walker]

Hi

I have pgAdmin4 version 1.0 running on a windows 7 machine - I would like to
uninstall it and put on the latest version.  It is installed in C:\Program
Files\PostgreSQL\9.6\pgAdmin4 - I can find no uninstall exe within the
pgAdmin4 folder and the program is not listed in the 'Uninstall or change
program' option from the control panel.  Can anyone tell me how to
completely uninstall it?  Many thanks.

Gillian

RE: Cant browse servers after update to pgadmin 1.6 (server version)

[Mike Surcouf]

It’s all to do with paths far as I can see.
Its likely DESKTOP works because the default path is the root of the webserver.
And as that bug report states if I run the app in the root of my site I guess 
it will work.

It seems 1.6 is broken out the box which recommends pgadmin4 as the app path.
Presumably the code does not account for the app path in a few places.
Not sure how this wasn’t picked up though.

Is dev...@gunduz.org testing these repos by 
installing in the app path eg (pgadmin4) as per the docs?

From: Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
Sent: 19 July 2017 13:41
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)

Okay, I think this is a bug with 1.6.

Found similar issue: https://redmine.postgresql.org/issues/2563


--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Jul 19, 2017 at 6:03 PM, Mike Surcouf 
mailto:mi...@surcouf.co.uk>> wrote:
Still the same

Tested in IE 11 and CHrome

Am I picking up a early webpack preview from the repo?

All I did was a yum update

It seems there paths for require are not correct (missing a level pgadm4)



From: Murtuza Zabuawala 
[mailto:murtuza.zabuaw...@enterprisedb.com]
Sent: 19 July 2017 13:27
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)

Can you clear the browser cache with hard reset and try again?

[Inline image 1]

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Jul 19, 2017 at 5:48 PM, Mike Surcouf 
mailto:mi...@surcouf.co.uk>> wrote:
wcDocker.min.js:42 exported wcDocker
jquery-1.11.2.min.js:4 GET http://aesdata01/preferences/get_all 404 (Not Found)
send @ jquery-1.11.2.min.js:4
ajax @ jquery-1.11.2.min.js:4
cache_preferences @ browser.js:953
init @ browser.js:357
(anonymous) @ (index):280
execCb @ require.min.js:29
check @ require.min.js:18
(anonymous) @ require.min.js:23
(anonymous) @ require.min.js:8
(anonymous) @ require.min.js:23
v @ require.min.js:7
emit @ require.min.js:23
check @ require.min.js:19
(anonymous) @ require.min.js:23
(anonymous) @ require.min.js:8
(anonymous) @ require.min.js:23
v @ require.min.js:7
emit @ require.min.js:23
check @ require.min.js:19
(anonymous) @ require.min.js:23
(anonymous) @ require.min.js:8
(anonymous) @ require.min.js:23
v @ require.min.js:7
emit @ require.min.js:23
check @ require.min.js:19
(anonymous) @ require.min.js:23
(anonymous) @ require.min.js:8
(anonymous) @ require.min.js:23
v @ require.min.js:7
emit @ require.min.js:23
check @ require.min.js:19
enable @ require.min.js:23
init @ require.min.js:17
E @ require.min.js:14
completeLoad @ require.min.js:28
onScriptLoad @ require.min.js:29
jquery-1.11.2.min.js:4 GET http://aesdata01/browser/nodes/ 404 (Not Found)
send @ jquery-1.11.2.min.js:4
ajax @ jquery-1.11.2.min.js:4
(anonymous) @ jquery.aciTree.min.js:17
k @ jquery.aciTree.min.js:17
(anonymous) @ jquery.aciTree.min.js:17
jquery-1.11.2.min.js:4 POST http://aesdata01/settings/store 404 (Not Found)
send @ jquery-1.11.2.min.js:4
ajax @ jquery-1.11.2.min.js:4
save_current_layout @ browser.js:342
(anonymous) @ browser.js:403
__trigger @ wcDocker.min.js:34
__moveEnd @ wcDocker.min.js:34
jquery-1.11.2.min.js:4 POST http://aesdata01/settings/store 404 (Not Found)
send @ jquery-1.11.2.min.js:4
ajax @ jquery-1.11.2.min.js:4
save_current_layout @ browser.js:342
(anonymous) @ browser.js:403
__trigger @ wcDocker.min.js:34
__moveEnd @ wcDocker.min.js:34

From: Murtuza Zabuawala 
[mailto:murtuza.zabuaw...@enterprisedb.com]
Sent: 19 July 2017 13:14
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)

Can you please open browser developer 
tool and check the Console tab if there 
is any error on console when you load the page?



--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Jul 19, 2017 at 5:40 PM, Mike Surcouf 
mailto:mi...@surcouf.co.uk>> wrote:
BTW I disabled upgrade check

UPGRADE_CHECK_ENABLED = False

in config.py

The

URLError: 
error is now gone but I still have no nodes in my browser pane and the add a 
server link doesn’t work

Thanks

Mike


From: Murtuza Zabuawala 
[mailto:murtuza.zabuaw...@enterprisedb.com]
Sent: 19 July 2017 13:03
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server

Re: Cant browse servers after update to pgadmin 1.6 (server version)

[Murtuza Zabuawala]

On Wed, Jul 19, 2017 at 6:16 PM, Khushboo Vashi <
khushboo.va...@enterprisedb.com> wrote:

> On Wed, Jul 19, 2017 at 6:10 PM, Murtuza Zabuawala  enterprisedb.com> wrote:
>
>> Okay, I think this is a bug with 1.6.
>>
>> Found similar issue: https://redmine.postgresql.org/issues/2563
>>
>>
> So, as per this RM information, you can change the WSGIScriptAlias from
> */pgadmin4* to */* to fix this issue.
>
>>
>> Yes, This is a work around.
But we also have to fix this issue at code level to honour the virtual
DirectoryRoot path :)

> --
>> Regards,
>> Murtuza Zabuawala
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>> On Wed, Jul 19, 2017 at 6:03 PM, Mike Surcouf 
>> wrote:
>>
>>> Still the same
>>>
>>>
>>>
>>> Tested in IE 11 and CHrome
>>>
>>>
>>>
>>> Am I picking up a early webpack preview from the repo?
>>>
>>>
>>>
>>> All I did was a yum update
>>>
>>>
>>>
>>> It seems there paths for require are not correct (missing a level
>>> pgadm4)
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> *From:* Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
>>> *Sent:* 19 July 2017 13:27
>>> *To:* Mike Surcouf
>>> *Cc:* pgadmin-supp...@postgresql.org
>>> *Subject:* Re: Cant browse servers after update to pgadmin 1.6 (server
>>> version)
>>>
>>>
>>>
>>> Can you clear the browser cache with hard reset and try again?
>>>
>>>
>>>
>>> [image: Inline image 1]
>>>
>>>
>>>
>>> --
>>>
>>> Regards,
>>>
>>> Murtuza Zabuawala
>>> EnterpriseDB: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>>
>>>
>>> On Wed, Jul 19, 2017 at 5:48 PM, Mike Surcouf 
>>> wrote:
>>>
>>> wcDocker.min.js:42 exported wcDocker
>>>
>>> jquery-1.11.2.min.js:4 GET http://aesdata01/preferences/get_all 404
>>> (Not Found)
>>>
>>> send @ jquery-1.11.2.min.js:4
>>>
>>> ajax @ jquery-1.11.2.min.js:4
>>>
>>> cache_preferences @ browser.js:953
>>>
>>> init @ browser.js:357
>>>
>>> (anonymous) @ (index):280
>>>
>>> execCb @ require.min.js:29
>>>
>>> check @ require.min.js:18
>>>
>>> (anonymous) @ require.min.js:23
>>>
>>> (anonymous) @ require.min.js:8
>>>
>>> (anonymous) @ require.min.js:23
>>>
>>> v @ require.min.js:7
>>>
>>> emit @ require.min.js:23
>>>
>>> check @ require.min.js:19
>>>
>>> (anonymous) @ require.min.js:23
>>>
>>> (anonymous) @ require.min.js:8
>>>
>>> (anonymous) @ require.min.js:23
>>>
>>> v @ require.min.js:7
>>>
>>> emit @ require.min.js:23
>>>
>>> check @ require.min.js:19
>>>
>>> (anonymous) @ require.min.js:23
>>>
>>> (anonymous) @ require.min.js:8
>>>
>>> (anonymous) @ require.min.js:23
>>>
>>> v @ require.min.js:7
>>>
>>> emit @ require.min.js:23
>>>
>>> check @ require.min.js:19
>>>
>>> (anonymous) @ require.min.js:23
>>>
>>> (anonymous) @ require.min.js:8
>>>
>>> (anonymous) @ require.min.js:23
>>>
>>> v @ require.min.js:7
>>>
>>> emit @ require.min.js:23
>>>
>>> check @ require.min.js:19
>>>
>>> enable @ require.min.js:23
>>>
>>> init @ require.min.js:17
>>>
>>> E @ require.min.js:14
>>>
>>> completeLoad @ require.min.js:28
>>>
>>> onScriptLoad @ require.min.js:29
>>>
>>> jquery-1.11.2.min.js:4 GET http://aesdata01/browser/nodes/ 404 (Not
>>> Found)
>>>
>>> send @ jquery-1.11.2.min.js:4
>>>
>>> ajax @ jquery-1.11.2.min.js:4
>>>
>>> (anonymous) @ jquery.aciTree.min.js:17
>>>
>>> k @ jquery.aciTree.min.js:17
>>>
>>> (anonymous) @ jquery.aciTree.min.js:17
>>>
>>> jquery-1.11.2.min.js:4 POST http://aesdata01/settings/store 404 (Not
>>> Found)
>>>
>>> send @ jquery-1.11.2.min.js:4
>>>
>>> ajax @ jquery-1.11.2.min.js:4
>>>
>>> save_current_layout @ browser.js:342
>>>
>>> (anonymous) @ browser.js:403
>>>
>>> __trigger @ wcDocker.min.js:34
>>>
>>> __moveEnd @ wcDocker.min.js:34
>>>
>>> jquery-1.11.2.min.js:4 POST http://aesdata01/settings/store 404 (Not
>>> Found)
>>>
>>> send @ jquery-1.11.2.min.js:4
>>>
>>> ajax @ jquery-1.11.2.min.js:4
>>>
>>> save_current_layout @ browser.js:342
>>>
>>> (anonymous) @ browser.js:403
>>>
>>> __trigger @ wcDocker.min.js:34
>>>
>>> __moveEnd @ wcDocker.min.js:34
>>>
>>>
>>>
>>> *From:* Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
>>> *Sent:* 19 July 2017 13:14
>>> *To:* Mike Surcouf
>>> *Cc:* pgadmin-supp...@postgresql.org
>>> *Subject:* Re: Cant browse servers after update to pgadmin 1.6 (server
>>> version)
>>>
>>>
>>>
>>> Can you please open browser developer tool
>>>  and check the Console tab if
>>> there is any error on console when you load the page?
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>>
>>> Regards,
>>>
>>> Murtuza Zabuawala
>>> EnterpriseDB: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>>
>>>
>>> On Wed, Jul 19, 2017 at 5:40 PM, Mike Surcouf 
>>> wrote:
>>>
>>> BTW I disabled upgrade check
>>>
>>>
>>>
>>> UPGRADE_CHECK_ENABLED = False
>>>
>>>
>>>
>>> in config.py
>>>
>>>
>>>
>>> The
>>>
>>>
>>>
>>> URLError: 
>>>
>>> error is now gone but I still have no nodes in my browser pane and the
>>> add a server link doesn’t work
>>>
>>>
>>>
>>> Thanks
>>>
>>>
>>>
>>> Mike
>>>

Re: Cant browse servers after update to pgadmin 1.6 (server version)

[Khushboo Vashi]

On Wed, Jul 19, 2017 at 6:10 PM, Murtuza Zabuawala <
murtuza.zabuaw...@enterprisedb.com> wrote:

> Okay, I think this is a bug with 1.6.
>
> Found similar issue: https://redmine.postgresql.org/issues/2563
>
>
So, as per this RM information, you can change the WSGIScriptAlias from
*/pgadmin4* to */* to fix this issue.

>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
> On Wed, Jul 19, 2017 at 6:03 PM, Mike Surcouf  wrote:
>
>> Still the same
>>
>>
>>
>> Tested in IE 11 and CHrome
>>
>>
>>
>> Am I picking up a early webpack preview from the repo?
>>
>>
>>
>> All I did was a yum update
>>
>>
>>
>> It seems there paths for require are not correct (missing a level pgadm4)
>>
>>
>>
>>
>>
>>
>>
>> *From:* Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
>> *Sent:* 19 July 2017 13:27
>> *To:* Mike Surcouf
>> *Cc:* pgadmin-supp...@postgresql.org
>> *Subject:* Re: Cant browse servers after update to pgadmin 1.6 (server
>> version)
>>
>>
>>
>> Can you clear the browser cache with hard reset and try again?
>>
>>
>>
>> [image: Inline image 1]
>>
>>
>>
>> --
>>
>> Regards,
>>
>> Murtuza Zabuawala
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>>
>>
>> On Wed, Jul 19, 2017 at 5:48 PM, Mike Surcouf 
>> wrote:
>>
>> wcDocker.min.js:42 exported wcDocker
>>
>> jquery-1.11.2.min.js:4 GET http://aesdata01/preferences/get_all 404 (Not
>> Found)
>>
>> send @ jquery-1.11.2.min.js:4
>>
>> ajax @ jquery-1.11.2.min.js:4
>>
>> cache_preferences @ browser.js:953
>>
>> init @ browser.js:357
>>
>> (anonymous) @ (index):280
>>
>> execCb @ require.min.js:29
>>
>> check @ require.min.js:18
>>
>> (anonymous) @ require.min.js:23
>>
>> (anonymous) @ require.min.js:8
>>
>> (anonymous) @ require.min.js:23
>>
>> v @ require.min.js:7
>>
>> emit @ require.min.js:23
>>
>> check @ require.min.js:19
>>
>> (anonymous) @ require.min.js:23
>>
>> (anonymous) @ require.min.js:8
>>
>> (anonymous) @ require.min.js:23
>>
>> v @ require.min.js:7
>>
>> emit @ require.min.js:23
>>
>> check @ require.min.js:19
>>
>> (anonymous) @ require.min.js:23
>>
>> (anonymous) @ require.min.js:8
>>
>> (anonymous) @ require.min.js:23
>>
>> v @ require.min.js:7
>>
>> emit @ require.min.js:23
>>
>> check @ require.min.js:19
>>
>> (anonymous) @ require.min.js:23
>>
>> (anonymous) @ require.min.js:8
>>
>> (anonymous) @ require.min.js:23
>>
>> v @ require.min.js:7
>>
>> emit @ require.min.js:23
>>
>> check @ require.min.js:19
>>
>> enable @ require.min.js:23
>>
>> init @ require.min.js:17
>>
>> E @ require.min.js:14
>>
>> completeLoad @ require.min.js:28
>>
>> onScriptLoad @ require.min.js:29
>>
>> jquery-1.11.2.min.js:4 GET http://aesdata01/browser/nodes/ 404 (Not
>> Found)
>>
>> send @ jquery-1.11.2.min.js:4
>>
>> ajax @ jquery-1.11.2.min.js:4
>>
>> (anonymous) @ jquery.aciTree.min.js:17
>>
>> k @ jquery.aciTree.min.js:17
>>
>> (anonymous) @ jquery.aciTree.min.js:17
>>
>> jquery-1.11.2.min.js:4 POST http://aesdata01/settings/store 404 (Not
>> Found)
>>
>> send @ jquery-1.11.2.min.js:4
>>
>> ajax @ jquery-1.11.2.min.js:4
>>
>> save_current_layout @ browser.js:342
>>
>> (anonymous) @ browser.js:403
>>
>> __trigger @ wcDocker.min.js:34
>>
>> __moveEnd @ wcDocker.min.js:34
>>
>> jquery-1.11.2.min.js:4 POST http://aesdata01/settings/store 404 (Not
>> Found)
>>
>> send @ jquery-1.11.2.min.js:4
>>
>> ajax @ jquery-1.11.2.min.js:4
>>
>> save_current_layout @ browser.js:342
>>
>> (anonymous) @ browser.js:403
>>
>> __trigger @ wcDocker.min.js:34
>>
>> __moveEnd @ wcDocker.min.js:34
>>
>>
>>
>> *From:* Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
>> *Sent:* 19 July 2017 13:14
>> *To:* Mike Surcouf
>> *Cc:* pgadmin-supp...@postgresql.org
>> *Subject:* Re: Cant browse servers after update to pgadmin 1.6 (server
>> version)
>>
>>
>>
>> Can you please open browser developer tool
>>  and check the Console tab if
>> there is any error on console when you load the page?
>>
>>
>>
>>
>>
>>
>>
>> --
>>
>> Regards,
>>
>> Murtuza Zabuawala
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>>
>>
>> On Wed, Jul 19, 2017 at 5:40 PM, Mike Surcouf 
>> wrote:
>>
>> BTW I disabled upgrade check
>>
>>
>>
>> UPGRADE_CHECK_ENABLED = False
>>
>>
>>
>> in config.py
>>
>>
>>
>> The
>>
>>
>>
>> URLError: 
>>
>> error is now gone but I still have no nodes in my browser pane and the
>> add a server link doesn’t work
>>
>>
>>
>> Thanks
>>
>>
>>
>> Mike
>>
>>
>>
>>
>>
>> *From:* Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
>> *Sent:* 19 July 2017 13:03
>> *To:* Mike Surcouf
>> *Cc:* pgadmin-supp...@postgresql.org
>> *Subject:* Re: Cant browse servers after update to pgadmin 1.6 (server
>> version)
>>
>>
>>
>> Are you running pgAdmin4 on Apache or  any other server?
>>
>> (If so then can you try restarting your apache or respective web server
>> service as well)
>>
>>
>>
>>
>>
>> On Wed, Jul 1

Re: Cant browse servers after update to pgadmin 1.6 (server version)

[Murtuza Zabuawala]

Okay, I think this is a bug with 1.6.

Found similar issue: https://redmine.postgresql.org/issues/2563


--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Jul 19, 2017 at 6:03 PM, Mike Surcouf  wrote:

> Still the same
>
>
>
> Tested in IE 11 and CHrome
>
>
>
> Am I picking up a early webpack preview from the repo?
>
>
>
> All I did was a yum update
>
>
>
> It seems there paths for require are not correct (missing a level pgadm4)
>
>
>
>
>
>
>
> *From:* Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
> *Sent:* 19 July 2017 13:27
> *To:* Mike Surcouf
> *Cc:* pgadmin-supp...@postgresql.org
> *Subject:* Re: Cant browse servers after update to pgadmin 1.6 (server
> version)
>
>
>
> Can you clear the browser cache with hard reset and try again?
>
>
>
> [image: Inline image 1]
>
>
>
> --
>
> Regards,
>
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
>
> On Wed, Jul 19, 2017 at 5:48 PM, Mike Surcouf 
> wrote:
>
> wcDocker.min.js:42 exported wcDocker
>
> jquery-1.11.2.min.js:4 GET http://aesdata01/preferences/get_all 404 (Not
> Found)
>
> send @ jquery-1.11.2.min.js:4
>
> ajax @ jquery-1.11.2.min.js:4
>
> cache_preferences @ browser.js:953
>
> init @ browser.js:357
>
> (anonymous) @ (index):280
>
> execCb @ require.min.js:29
>
> check @ require.min.js:18
>
> (anonymous) @ require.min.js:23
>
> (anonymous) @ require.min.js:8
>
> (anonymous) @ require.min.js:23
>
> v @ require.min.js:7
>
> emit @ require.min.js:23
>
> check @ require.min.js:19
>
> (anonymous) @ require.min.js:23
>
> (anonymous) @ require.min.js:8
>
> (anonymous) @ require.min.js:23
>
> v @ require.min.js:7
>
> emit @ require.min.js:23
>
> check @ require.min.js:19
>
> (anonymous) @ require.min.js:23
>
> (anonymous) @ require.min.js:8
>
> (anonymous) @ require.min.js:23
>
> v @ require.min.js:7
>
> emit @ require.min.js:23
>
> check @ require.min.js:19
>
> (anonymous) @ require.min.js:23
>
> (anonymous) @ require.min.js:8
>
> (anonymous) @ require.min.js:23
>
> v @ require.min.js:7
>
> emit @ require.min.js:23
>
> check @ require.min.js:19
>
> enable @ require.min.js:23
>
> init @ require.min.js:17
>
> E @ require.min.js:14
>
> completeLoad @ require.min.js:28
>
> onScriptLoad @ require.min.js:29
>
> jquery-1.11.2.min.js:4 GET http://aesdata01/browser/nodes/ 404 (Not
> Found)
>
> send @ jquery-1.11.2.min.js:4
>
> ajax @ jquery-1.11.2.min.js:4
>
> (anonymous) @ jquery.aciTree.min.js:17
>
> k @ jquery.aciTree.min.js:17
>
> (anonymous) @ jquery.aciTree.min.js:17
>
> jquery-1.11.2.min.js:4 POST http://aesdata01/settings/store 404 (Not
> Found)
>
> send @ jquery-1.11.2.min.js:4
>
> ajax @ jquery-1.11.2.min.js:4
>
> save_current_layout @ browser.js:342
>
> (anonymous) @ browser.js:403
>
> __trigger @ wcDocker.min.js:34
>
> __moveEnd @ wcDocker.min.js:34
>
> jquery-1.11.2.min.js:4 POST http://aesdata01/settings/store 404 (Not
> Found)
>
> send @ jquery-1.11.2.min.js:4
>
> ajax @ jquery-1.11.2.min.js:4
>
> save_current_layout @ browser.js:342
>
> (anonymous) @ browser.js:403
>
> __trigger @ wcDocker.min.js:34
>
> __moveEnd @ wcDocker.min.js:34
>
>
>
> *From:* Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
> *Sent:* 19 July 2017 13:14
> *To:* Mike Surcouf
> *Cc:* pgadmin-supp...@postgresql.org
> *Subject:* Re: Cant browse servers after update to pgadmin 1.6 (server
> version)
>
>
>
> Can you please open browser developer tool
>  and check the Console tab if
> there is any error on console when you load the page?
>
>
>
>
>
>
>
> --
>
> Regards,
>
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
>
> On Wed, Jul 19, 2017 at 5:40 PM, Mike Surcouf 
> wrote:
>
> BTW I disabled upgrade check
>
>
>
> UPGRADE_CHECK_ENABLED = False
>
>
>
> in config.py
>
>
>
> The
>
>
>
> URLError: 
>
> error is now gone but I still have no nodes in my browser pane and the add
> a server link doesn’t work
>
>
>
> Thanks
>
>
>
> Mike
>
>
>
>
>
> *From:* Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
> *Sent:* 19 July 2017 13:03
> *To:* Mike Surcouf
> *Cc:* pgadmin-supp...@postgresql.org
> *Subject:* Re: Cant browse servers after update to pgadmin 1.6 (server
> version)
>
>
>
> Are you running pgAdmin4 on Apache or  any other server?
>
> (If so then can you try restarting your apache or respective web server
> service as well)
>
>
>
>
>
> On Wed, Jul 19, 2017 at 5:25 PM, Mike Surcouf 
> wrote:
>
> Same thing.
>
>
>
> In the end I deleted everything in
>
>
>
> /var/pgadmin/.pgadmin
>
>
>
> then ran
>
>
>
> su -s /bin/sh -c 'python /usr/lib/python2.7/site-
> packages/pgadmin4-web/setup.py' pgadmin
>
>
>
> Still no nodes in the browser pane
>
>
>
> *From:* Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
> *Sent:* 19 July 2017 12:45
> *To:* Mike Surcouf
> *Cc:* pgadmin-supp...@postgresql.org
> *Subject:* Re: Cant browse ser

RE: Cant browse servers after update to pgadmin 1.6 (server version)

[Mike Surcouf]

Still the same

Tested in IE 11 and CHrome

Am I picking up a early webpack preview from the repo?

All I did was a yum update

It seems there paths for require are not correct (missing a level pgadm4)



From: Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
Sent: 19 July 2017 13:27
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)

Can you clear the browser cache with hard reset and try again?

[Inline image 1]

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Jul 19, 2017 at 5:48 PM, Mike Surcouf 
mailto:mi...@surcouf.co.uk>> wrote:
wcDocker.min.js:42 exported wcDocker
jquery-1.11.2.min.js:4 GET http://aesdata01/preferences/get_all 404 (Not Found)
send @ jquery-1.11.2.min.js:4
ajax @ jquery-1.11.2.min.js:4
cache_preferences @ browser.js:953
init @ browser.js:357
(anonymous) @ (index):280
execCb @ require.min.js:29
check @ require.min.js:18
(anonymous) @ require.min.js:23
(anonymous) @ require.min.js:8
(anonymous) @ require.min.js:23
v @ require.min.js:7
emit @ require.min.js:23
check @ require.min.js:19
(anonymous) @ require.min.js:23
(anonymous) @ require.min.js:8
(anonymous) @ require.min.js:23
v @ require.min.js:7
emit @ require.min.js:23
check @ require.min.js:19
(anonymous) @ require.min.js:23
(anonymous) @ require.min.js:8
(anonymous) @ require.min.js:23
v @ require.min.js:7
emit @ require.min.js:23
check @ require.min.js:19
(anonymous) @ require.min.js:23
(anonymous) @ require.min.js:8
(anonymous) @ require.min.js:23
v @ require.min.js:7
emit @ require.min.js:23
check @ require.min.js:19
enable @ require.min.js:23
init @ require.min.js:17
E @ require.min.js:14
completeLoad @ require.min.js:28
onScriptLoad @ require.min.js:29
jquery-1.11.2.min.js:4 GET http://aesdata01/browser/nodes/ 404 (Not Found)
send @ jquery-1.11.2.min.js:4
ajax @ jquery-1.11.2.min.js:4
(anonymous) @ jquery.aciTree.min.js:17
k @ jquery.aciTree.min.js:17
(anonymous) @ jquery.aciTree.min.js:17
jquery-1.11.2.min.js:4 POST http://aesdata01/settings/store 404 (Not Found)
send @ jquery-1.11.2.min.js:4
ajax @ jquery-1.11.2.min.js:4
save_current_layout @ browser.js:342
(anonymous) @ browser.js:403
__trigger @ wcDocker.min.js:34
__moveEnd @ wcDocker.min.js:34
jquery-1.11.2.min.js:4 POST http://aesdata01/settings/store 404 (Not Found)
send @ jquery-1.11.2.min.js:4
ajax @ jquery-1.11.2.min.js:4
save_current_layout @ browser.js:342
(anonymous) @ browser.js:403
__trigger @ wcDocker.min.js:34
__moveEnd @ wcDocker.min.js:34

From: Murtuza Zabuawala 
[mailto:murtuza.zabuaw...@enterprisedb.com]
Sent: 19 July 2017 13:14
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)

Can you please open browser developer 
tool and check the Console tab if there 
is any error on console when you load the page?



--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Jul 19, 2017 at 5:40 PM, Mike Surcouf 
mailto:mi...@surcouf.co.uk>> wrote:
BTW I disabled upgrade check

UPGRADE_CHECK_ENABLED = False

in config.py

The

URLError: 
error is now gone but I still have no nodes in my browser pane and the add a 
server link doesn’t work

Thanks

Mike


From: Murtuza Zabuawala 
[mailto:murtuza.zabuaw...@enterprisedb.com]
Sent: 19 July 2017 13:03
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)

Are you running pgAdmin4 on Apache or  any other server?
(If so then can you try restarting your apache or respective web server service 
as well)


On Wed, Jul 19, 2017 at 5:25 PM, Mike Surcouf 
mailto:mi...@surcouf.co.uk>> wrote:
Same thing.

In the end I deleted everything in

/var/pgadmin/.pgadmin

then ran

su -s /bin/sh -c 'python 
/usr/lib/python2.7/site-packages/pgadmin4-web/setup.py' pgadmin

Still no nodes in the browser pane

From: Murtuza Zabuawala 
[mailto:murtuza.zabuaw...@enterprisedb.com]
Sent: 19 July 2017 12:45
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)

Hi,

It looks like you pgAdmin4 configuration file got corrupted.
Can you rename your pgAdmin4 configuration file and try to start pgAdmin4 again?

mv ~/.pgadmin/pgadmin4.db ~/.pgadmin/pgadmin4.db_old


--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Jul 19, 2017 at 5:08 PM, Mike Surcouf 
mailto:mi...@surcouf.co.uk>

Re: Cant browse servers after update to pgadmin 1.6 (server version)

[Murtuza Zabuawala]

Can you clear the browser cache with hard reset and try again?

[image: Inline image 1]

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Jul 19, 2017 at 5:48 PM, Mike Surcouf  wrote:

> wcDocker.min.js:42 exported wcDocker
>
> jquery-1.11.2.min.js:4 GET http://aesdata01/preferences/get_all 404 (Not
> Found)
>
> send @ jquery-1.11.2.min.js:4
>
> ajax @ jquery-1.11.2.min.js:4
>
> cache_preferences @ browser.js:953
>
> init @ browser.js:357
>
> (anonymous) @ (index):280
>
> execCb @ require.min.js:29
>
> check @ require.min.js:18
>
> (anonymous) @ require.min.js:23
>
> (anonymous) @ require.min.js:8
>
> (anonymous) @ require.min.js:23
>
> v @ require.min.js:7
>
> emit @ require.min.js:23
>
> check @ require.min.js:19
>
> (anonymous) @ require.min.js:23
>
> (anonymous) @ require.min.js:8
>
> (anonymous) @ require.min.js:23
>
> v @ require.min.js:7
>
> emit @ require.min.js:23
>
> check @ require.min.js:19
>
> (anonymous) @ require.min.js:23
>
> (anonymous) @ require.min.js:8
>
> (anonymous) @ require.min.js:23
>
> v @ require.min.js:7
>
> emit @ require.min.js:23
>
> check @ require.min.js:19
>
> (anonymous) @ require.min.js:23
>
> (anonymous) @ require.min.js:8
>
> (anonymous) @ require.min.js:23
>
> v @ require.min.js:7
>
> emit @ require.min.js:23
>
> check @ require.min.js:19
>
> enable @ require.min.js:23
>
> init @ require.min.js:17
>
> E @ require.min.js:14
>
> completeLoad @ require.min.js:28
>
> onScriptLoad @ require.min.js:29
>
> jquery-1.11.2.min.js:4 GET http://aesdata01/browser/nodes/ 404 (Not
> Found)
>
> send @ jquery-1.11.2.min.js:4
>
> ajax @ jquery-1.11.2.min.js:4
>
> (anonymous) @ jquery.aciTree.min.js:17
>
> k @ jquery.aciTree.min.js:17
>
> (anonymous) @ jquery.aciTree.min.js:17
>
> jquery-1.11.2.min.js:4 POST http://aesdata01/settings/store 404 (Not
> Found)
>
> send @ jquery-1.11.2.min.js:4
>
> ajax @ jquery-1.11.2.min.js:4
>
> save_current_layout @ browser.js:342
>
> (anonymous) @ browser.js:403
>
> __trigger @ wcDocker.min.js:34
>
> __moveEnd @ wcDocker.min.js:34
>
> jquery-1.11.2.min.js:4 POST http://aesdata01/settings/store 404 (Not
> Found)
>
> send @ jquery-1.11.2.min.js:4
>
> ajax @ jquery-1.11.2.min.js:4
>
> save_current_layout @ browser.js:342
>
> (anonymous) @ browser.js:403
>
> __trigger @ wcDocker.min.js:34
>
> __moveEnd @ wcDocker.min.js:34
>
>
>
> *From:* Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
> *Sent:* 19 July 2017 13:14
> *To:* Mike Surcouf
> *Cc:* pgadmin-supp...@postgresql.org
> *Subject:* Re: Cant browse servers after update to pgadmin 1.6 (server
> version)
>
>
>
> Can you please open browser developer tool
>  and check the Console tab if
> there is any error on console when you load the page?
>
>
>
>
>
>
>
> --
>
> Regards,
>
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
>
> On Wed, Jul 19, 2017 at 5:40 PM, Mike Surcouf 
> wrote:
>
> BTW I disabled upgrade check
>
>
>
> UPGRADE_CHECK_ENABLED = False
>
>
>
> in config.py
>
>
>
> The
>
>
>
> URLError: 
>
> error is now gone but I still have no nodes in my browser pane and the add
> a server link doesn’t work
>
>
>
> Thanks
>
>
>
> Mike
>
>
>
>
>
> *From:* Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
> *Sent:* 19 July 2017 13:03
> *To:* Mike Surcouf
> *Cc:* pgadmin-supp...@postgresql.org
> *Subject:* Re: Cant browse servers after update to pgadmin 1.6 (server
> version)
>
>
>
> Are you running pgAdmin4 on Apache or  any other server?
>
> (If so then can you try restarting your apache or respective web server
> service as well)
>
>
>
>
>
> On Wed, Jul 19, 2017 at 5:25 PM, Mike Surcouf 
> wrote:
>
> Same thing.
>
>
>
> In the end I deleted everything in
>
>
>
> /var/pgadmin/.pgadmin
>
>
>
> then ran
>
>
>
> su -s /bin/sh -c 'python /usr/lib/python2.7/site-
> packages/pgadmin4-web/setup.py' pgadmin
>
>
>
> Still no nodes in the browser pane
>
>
>
> *From:* Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
> *Sent:* 19 July 2017 12:45
> *To:* Mike Surcouf
> *Cc:* pgadmin-supp...@postgresql.org
> *Subject:* Re: Cant browse servers after update to pgadmin 1.6 (server
> version)
>
>
>
> Hi,
>
>
>
> It looks like you pgAdmin4 configuration file got corrupted.
>
> Can you rename your pgAdmin4 configuration file and try to start pgAdmin4
> again?
>
>
>
> mv ~/.pgadmin/pgadmin4.db ~/.pgadmin/pgadmin4.db_old
>
>
>
>
>
> --
>
> Regards,
>
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
>
> On Wed, Jul 19, 2017 at 5:08 PM, Mike Surcouf 
> wrote:
>
> package pgadmin4-v1-web.noarch  1.6-2.rhel7
> After update of the above package from 1.5  I now see no nodes in the
> browser column soI cant do anything.
>
> sample of my error log
>
> [Wed Jul 19 12:31:13.159426 2017] [:error] [pid 1428] URLError:  error [Errno 101] Network is unreachable>
> [Wed Jul 19 

RE: Cant browse servers after update to pgadmin 1.6 (server version)

[Mike Surcouf]

In addition by pgadmin site is at

http://aesdata01/pgadmin4/

So an HTTP GET to

http://aesdata01/preferences/get_all

will obviously fail



From: Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
Sent: 19 July 2017 13:14
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)

Can you please open browser developer 
tool and check the Console tab if there 
is any error on console when you load the page?



--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Jul 19, 2017 at 5:40 PM, Mike Surcouf 
mailto:mi...@surcouf.co.uk>> wrote:
BTW I disabled upgrade check

UPGRADE_CHECK_ENABLED = False

in config.py

The

URLError: 
error is now gone but I still have no nodes in my browser pane and the add a 
server link doesn’t work

Thanks

Mike


From: Murtuza Zabuawala 
[mailto:murtuza.zabuaw...@enterprisedb.com]
Sent: 19 July 2017 13:03
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)

Are you running pgAdmin4 on Apache or  any other server?
(If so then can you try restarting your apache or respective web server service 
as well)


On Wed, Jul 19, 2017 at 5:25 PM, Mike Surcouf 
mailto:mi...@surcouf.co.uk>> wrote:
Same thing.

In the end I deleted everything in

/var/pgadmin/.pgadmin

then ran

su -s /bin/sh -c 'python 
/usr/lib/python2.7/site-packages/pgadmin4-web/setup.py' pgadmin

Still no nodes in the browser pane

From: Murtuza Zabuawala 
[mailto:murtuza.zabuaw...@enterprisedb.com]
Sent: 19 July 2017 12:45
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)

Hi,

It looks like you pgAdmin4 configuration file got corrupted.
Can you rename your pgAdmin4 configuration file and try to start pgAdmin4 again?

mv ~/.pgadmin/pgadmin4.db ~/.pgadmin/pgadmin4.db_old


--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Jul 19, 2017 at 5:08 PM, Mike Surcouf 
mailto:mi...@surcouf.co.uk>> wrote:
package pgadmin4-v1-web.noarch  1.6-2.rhel7
After update of the above package from 1.5  I now see no nodes in the browser 
column soI cant do anything.

sample of my error log

[Wed Jul 19 12:31:13.159426 2017] [:error] [pid 1428] URLError: 
[Wed Jul 19 12:31:15.904561 2017] [:error] [pid 1428] 2017-07-19 12:31:15,904: 
ERROR\tpgadmin:\tException when checking for update
[Wed Jul 19 12:31:15.904576 2017] [:error] [pid 1428] Traceback (most recent 
call last):
[Wed Jul 19 12:31:15.904579 2017] [:error] [pid 1428]   File 
"/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/browser/__init__.py", 
line 482, in index
[Wed Jul 19 12:31:15.904582 2017] [:error] [pid 1428] response = 
urlreq.urlopen(url, data, 5)
[Wed Jul 19 12:31:15.904584 2017] [:error] [pid 1428]   File 
"/usr/lib64/python2.7/urllib2.py", line 154, in urlopen
[Wed Jul 19 12:31:15.904587 2017] [:error] [pid 1428] return 
opener.open(url, data, timeout)
[Wed Jul 19 12:31:15.904589 2017] [:error] [pid 1428]   File 
"/usr/lib64/python2.7/urllib2.py", line 431, in open
[Wed Jul 19 12:31:15.904591 2017] [:error] [pid 1428] response = 
self._open(req, data)
[Wed Jul 19 12:31:15.904594 2017] [:error] [pid 1428]   File 
"/usr/lib64/python2.7/urllib2.py", line 449, in _open
[Wed Jul 19 12:31:15.904596 2017] [:error] [pid 1428] '_open', req)
[Wed Jul 19 12:31:15.904599 2017] [:error] [pid 1428]   File 
"/usr/lib64/python2.7/urllib2.py", line 409, in _call_chain
[Wed Jul 19 12:31:15.904617 2017] [:error] [pid 1428] result = func(*args)
[Wed Jul 19 12:31:15.904620 2017] [:error] [pid 1428]   File 
"/usr/lib64/python2.7/urllib2.py", line 1258, in https_open
[Wed Jul 19 12:31:15.904622 2017] [:error] [pid 1428] 
context=self._context, check_hostname=self._check_hostname)
[Wed Jul 19 12:31:15.904625 2017] [:error] [pid 1428]   File 
"/usr/lib64/python2.7/urllib2.py", line 1214, in do_open
[Wed Jul 19 12:31:15.904627 2017] [:error] [pid 1428] raise URLError(err)
[Wed Jul 19 12:31:15.904629 2017] [:error] [pid 1428] URLError: 

pgadmin4 1.6 (python wheel) doesn't work under Ubuntu Server 16.04 LTS

[deluk]

Hi everybody,

pgadmin4 1.6 (python wheel) doesn't work under Ubuntu Server 16.04 LTS.
We have installed pgadmin as usual (pgadmin4 1.5 works) but the new version
1.6 produces following web-error.

/Internal Server Error
The server encountered an internal error or misconfiguration and was unable
to complete your request.
Please contact the server administrator at [no address given] to inform them
of the time this error occurred, and the actions you performed just before
this error.
More information about this error may be available in the server error log.
Apache/2.4.18 (Ubuntu) Server at xx.de Port 443/

The apache2 err-log gives the following messages:

[Wed Jul 19 10:44:25.920310 2017] [wsgi:warn] [pid 1331:tid 140523746342784]
mod_wsgi: Compiled for Python/2.7.11.
[Wed Jul 19 10:44:25.920372 2017] [wsgi:warn] [pid 1331:tid 140523746342784]
mod_wsgi: Runtime using Python/2.7.12.
[Wed Jul 19 10:44:25.921482 2017] [mpm_event:notice] [pid 1331:tid
140523746342784] AH00489: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g
mod_wsgi/4.3.0 Python/2.7.12 configured -- resuming normal operations
[Wed Jul 19 10:44:25.921507 2017] [core:notice] [pid 1331:tid
140523746342784] AH00094: Command line: '/usr/sbin/apache2'
[Wed Jul 19 10:44:33.929353 2017] [wsgi:error] [pid 1334:tid
140523617588992] [remote x:57147] mod_wsgi (pid=1334): Target WSGI
script '/opt/pgadmin4/lib/python2.7/site-packages/pgadmin4/pgAdmin4.wsgi'
cannot be loaded as Python module. 
[Wed Jul 19 10:44:33.929392 2017] [wsgi:error] [pid 1334:tid
140523617588992] [remote x:57147] mod_wsgi (pid=1334): Exception
occurred processing WSGI script
'/opt/pgadmin4/lib/python2.7/site-packages/pgadmin4/pgAdmin4.wsgi'.
[Wed Jul 19 10:44:33.929422 2017] [wsgi:error] [pid 1334:tid
140523617588992] [remote x:57147] Traceback (most recent call last):
[Wed Jul 19 10:44:33.929454 2017] [wsgi:error] [pid 1334:tid
140523617588992] [remote x:57147]   File
"/opt/pgadmin4/lib/python2.7/site-packages/pgadmin4/pgAdmin4.wsgi", line 17,
in 
[Wed Jul 19 10:44:33.929541 2017] [wsgi:error] [pid 1334:tid
140523617588992] [remote x:57147] import config
[Wed Jul 19 10:44:33.929562 2017] [wsgi:error] [pid 1334:tid
140523617588992] [remote x:57147]   File
"/opt/pgadmin4/lib/python2.7/site-packages/pgadmin4/config.py", line 24, in

[Wed Jul 19 10:44:33.929736 2017] [wsgi:error] [pid 1334:tid
140523617588992] [remote x:57147] from pgadmin.utils import env,
IS_PY2, IS_WIN, fs_short_path
[Wed Jul 19 10:44:33.929759 2017] [wsgi:error] [pid 1334:tid
140523617588992] [remote x:57147]   File
"/opt/pgadmin4/lib/python2.7/site-packages/pgadmin4/pgadmin/__init__.py",
line 17, in 
[Wed Jul 19 10:44:33.929995 2017] [wsgi:error] [pid 1334:tid
140523617588992] [remote x:57147] from flask import Flask, abort,
request, current_app, session
[Wed Jul 19 10:44:33.930035 2017] [wsgi:error] [pid 1334:tid
140523617588992] [remote x:57147] ImportError: No module named flask
[Wed Jul 19 10:44:37.688464 2017] [wsgi:error] [pid 1334:tid
140523416139520] [remote x:52519] mod_wsgi (pid=1334): Target WSGI
script '/opt/pgadmin4/lib/python2.7/site-packages/pgadmin4/pgAdmin4.wsgi'
cannot be loaded as Python module.
[Wed Jul 19 10:44:37.688497 2017] [wsgi:error] [pid 1334:tid
140523416139520] [remote x:52519] mod_wsgi (pid=1334): Exception
occurred processing WSGI script
'/opt/pgadmin4/lib/python2.7/site-packages/pgadmin4/pgAdmin4.wsgi'.
[Wed Jul 19 10:44:37.688530 2017] [wsgi:error] [pid 1334:tid
140523416139520] [remote x:52519] Traceback (most recent call last):
[Wed Jul 19 10:44:37.688567 2017] [wsgi:error] [pid 1334:tid
140523416139520] [remote x:52519]   File
"/opt/pgadmin4/lib/python2.7/site-packages/pgadmin4/pgAdmin4.wsgi", line 17,
in 
[Wed Jul 19 10:44:37.688610 2017] [wsgi:error] [pid 1334:tid
140523416139520] [remote x:52519] import config
[Wed Jul 19 10:44:37.688627 2017] [wsgi:error] [pid 1334:tid
140523416139520] [remote x:52519]   File
"/opt/pgadmin4/lib/python2.7/site-packages/pgadmin4/config.py", line 24, in

[Wed Jul 19 10:44:37.688652 2017] [wsgi:error] [pid 1334:tid
140523416139520] [remote x:52519] from pgadmin.utils import env,
IS_PY2, IS_WIN, fs_short_path
[Wed Jul 19 10:44:37.688668 2017] [wsgi:error] [pid 1334:tid
140523416139520] [remote x:52519]   File
"/opt/pgadmin4/lib/python2.7/site-packages/pgadmin4/pgadmin/__init__.py",
line 17, in 
[Wed Jul 19 10:44:37.688692 2017] [wsgi:error] [pid 1334:tid
140523416139520] [remote x:52519] from flask import Flask, abort,
request, current_app, session
[Wed Jul 19 10:44:37.688733 2017] [wsgi:error] [pid 1334:tid
140523416139520] [remote x:52519] ImportError: No module named flask

info:
the module flask ist already installed, activated and runs with version 1.5

I have searched for few days without any results, can you please help me?

Best Reguards




--
View this message in context: 
http://www.postgresql-archive.org/pgadmin4-1-6-python-wheel-doesn-t-w

RE: Cant browse servers after update to pgadmin 1.6 (server version)

[Mike Surcouf]

wcDocker.min.js:42 exported wcDocker
jquery-1.11.2.min.js:4 GET http://aesdata01/preferences/get_all 404 (Not Found)
send @ jquery-1.11.2.min.js:4
ajax @ jquery-1.11.2.min.js:4
cache_preferences @ browser.js:953
init @ browser.js:357
(anonymous) @ (index):280
execCb @ require.min.js:29
check @ require.min.js:18
(anonymous) @ require.min.js:23
(anonymous) @ require.min.js:8
(anonymous) @ require.min.js:23
v @ require.min.js:7
emit @ require.min.js:23
check @ require.min.js:19
(anonymous) @ require.min.js:23
(anonymous) @ require.min.js:8
(anonymous) @ require.min.js:23
v @ require.min.js:7
emit @ require.min.js:23
check @ require.min.js:19
(anonymous) @ require.min.js:23
(anonymous) @ require.min.js:8
(anonymous) @ require.min.js:23
v @ require.min.js:7
emit @ require.min.js:23
check @ require.min.js:19
(anonymous) @ require.min.js:23
(anonymous) @ require.min.js:8
(anonymous) @ require.min.js:23
v @ require.min.js:7
emit @ require.min.js:23
check @ require.min.js:19
enable @ require.min.js:23
init @ require.min.js:17
E @ require.min.js:14
completeLoad @ require.min.js:28
onScriptLoad @ require.min.js:29
jquery-1.11.2.min.js:4 GET http://aesdata01/browser/nodes/ 404 (Not Found)
send @ jquery-1.11.2.min.js:4
ajax @ jquery-1.11.2.min.js:4
(anonymous) @ jquery.aciTree.min.js:17
k @ jquery.aciTree.min.js:17
(anonymous) @ jquery.aciTree.min.js:17
jquery-1.11.2.min.js:4 POST http://aesdata01/settings/store 404 (Not Found)
send @ jquery-1.11.2.min.js:4
ajax @ jquery-1.11.2.min.js:4
save_current_layout @ browser.js:342
(anonymous) @ browser.js:403
__trigger @ wcDocker.min.js:34
__moveEnd @ wcDocker.min.js:34
jquery-1.11.2.min.js:4 POST http://aesdata01/settings/store 404 (Not Found)
send @ jquery-1.11.2.min.js:4
ajax @ jquery-1.11.2.min.js:4
save_current_layout @ browser.js:342
(anonymous) @ browser.js:403
__trigger @ wcDocker.min.js:34
__moveEnd @ wcDocker.min.js:34

From: Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
Sent: 19 July 2017 13:14
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)

Can you please open browser developer 
tool and check the Console tab if there 
is any error on console when you load the page?



--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Jul 19, 2017 at 5:40 PM, Mike Surcouf 
mailto:mi...@surcouf.co.uk>> wrote:
BTW I disabled upgrade check

UPGRADE_CHECK_ENABLED = False

in config.py

The

URLError: 
error is now gone but I still have no nodes in my browser pane and the add a 
server link doesn’t work

Thanks

Mike


From: Murtuza Zabuawala 
[mailto:murtuza.zabuaw...@enterprisedb.com]
Sent: 19 July 2017 13:03
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)

Are you running pgAdmin4 on Apache or  any other server?
(If so then can you try restarting your apache or respective web server service 
as well)


On Wed, Jul 19, 2017 at 5:25 PM, Mike Surcouf 
mailto:mi...@surcouf.co.uk>> wrote:
Same thing.

In the end I deleted everything in

/var/pgadmin/.pgadmin

then ran

su -s /bin/sh -c 'python 
/usr/lib/python2.7/site-packages/pgadmin4-web/setup.py' pgadmin

Still no nodes in the browser pane

From: Murtuza Zabuawala 
[mailto:murtuza.zabuaw...@enterprisedb.com]
Sent: 19 July 2017 12:45
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)

Hi,

It looks like you pgAdmin4 configuration file got corrupted.
Can you rename your pgAdmin4 configuration file and try to start pgAdmin4 again?

mv ~/.pgadmin/pgadmin4.db ~/.pgadmin/pgadmin4.db_old


--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Jul 19, 2017 at 5:08 PM, Mike Surcouf 
mailto:mi...@surcouf.co.uk>> wrote:
package pgadmin4-v1-web.noarch  1.6-2.rhel7
After update of the above package from 1.5  I now see no nodes in the browser 
column soI cant do anything.

sample of my error log

[Wed Jul 19 12:31:13.159426 2017] [:error] [pid 1428] URLError: 
[Wed Jul 19 12:31:15.904561 2017] [:error] [pid 1428] 2017-07-19 12:31:15,904: 
ERROR\tpgadmin:\tException when checking for update
[Wed Jul 19 12:31:15.904576 2017] [:error] [pid 1428] Traceback (most recent 
call last):
[Wed Jul 19 12:31:15.904579 2017] [:error] [pid 1428]   File 
"/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/browser/__init__.py", 
line 482, in index
[Wed Jul 19 12:31:15.904582 2017] [:error] [pid 1428] response = 
urlreq.urlopen(url, data, 5)
[Wed Jul 19 12:31:15.904584 2017] [:error] [pid 1428]   File 
"/usr

Re: New font for testing in Query Editor tool

[matshyeq]

Just a thought, if v4 is web based - why don't you use webfonts, like
whatever is available on https://fonts.google.com/?category=Monospace
with the option to fall back to the old ones?
Also, could this be easily configurable?

On 19 July 2017 at 14:14, Dave Page  wrote:

> Possibly not, but then it will fall back to the old one.
>
>
> On Wed, Jul 19, 2017 at 1:13 PM, Mike Surcouf  wrote:
>
>> Is that font available on all browsers iPad etc?
>>
>>
>>
>> *From:* Dave Page [mailto:dp...@pgadmin.org]
>> *Sent:* 19 July 2017 13:11
>> *To:* matshyeq
>> *Cc:* Mike Surcouf; Anthony DeBarros; pgAdmin Support; Shirley Wang
>>
>> *Subject:* Re: New font for testing in Query Editor tool
>>
>>
>>
>> Monospace, which we currently use, and Menlo, the proposed new default.
>>
>>
>>
>> On Wed, Jul 19, 2017 at 12:58 PM, matshyeq  wrote:
>>
>> What are the options?
>>
>>
>>
>> On 19 July 2017 at 10:37, Dave Page  wrote:
>>
>>
>>
>>
>>
>> On Wed, Jul 19, 2017 at 9:34 AM, Mike Surcouf 
>> wrote:
>>
>> Maybe I’m missing something,
>>
>>
>>
>> Shouldn’t all code including SQL use fixed width font?
>>
>>
>>
>> It does. The question is, *which* fixed width font.
>>
>>
>>
>>
>>
>> *From:* Dave Page [mailto:dp...@pgadmin.org]
>> *Sent:* 19 July 2017 09:00
>> *To:* Anthony DeBarros
>> *Cc:* pgAdmin Support; Shirley Wang
>> *Subject:* Re: New font for testing in Query Editor tool
>>
>>
>>
>>
>>
>>
>>
>> On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros 
>> wrote:
>>
>> I like it! I agree with the earlier poster that the line height could be
>> decreased -- but not by much. Perhaps a pixel or two.
>>
>>
>>
>> Yeah, something was bugging me about it too - I think it was the line
>> height.
>>
>>
>>
>>
>>
>> Anthony
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Hello
>>
>>
>>
>> We're testing out a new font for the SQL in the Query Editor tool. Here
>> is a link to test builds for both windows and mac:
>> https://developer.pgadmin.org/~dpage/query_tool_font_test/
>>
>>
>>
>> Let us know what your thoughts are on these font changes along with why
>> you think these changes need to occur.
>>
>>
>>
>> Thanks!
>>
>> Shirley & Pivotal Team
>>
>>
>>
>>
>>
>> --
>>
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>>
>>
>>
>>
>> --
>>
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>>
>>
>>
>>
>>
>>
>> --
>>
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

Re: New font for testing in Query Editor tool

[Dave Page]

Possibly not, but then it will fall back to the old one.

On Wed, Jul 19, 2017 at 1:13 PM, Mike Surcouf  wrote:

> Is that font available on all browsers iPad etc?
>
>
>
> *From:* Dave Page [mailto:dp...@pgadmin.org]
> *Sent:* 19 July 2017 13:11
> *To:* matshyeq
> *Cc:* Mike Surcouf; Anthony DeBarros; pgAdmin Support; Shirley Wang
>
> *Subject:* Re: New font for testing in Query Editor tool
>
>
>
> Monospace, which we currently use, and Menlo, the proposed new default.
>
>
>
> On Wed, Jul 19, 2017 at 12:58 PM, matshyeq  wrote:
>
> What are the options?
>
>
>
> On 19 July 2017 at 10:37, Dave Page  wrote:
>
>
>
>
>
> On Wed, Jul 19, 2017 at 9:34 AM, Mike Surcouf 
> wrote:
>
> Maybe I’m missing something,
>
>
>
> Shouldn’t all code including SQL use fixed width font?
>
>
>
> It does. The question is, *which* fixed width font.
>
>
>
>
>
> *From:* Dave Page [mailto:dp...@pgadmin.org]
> *Sent:* 19 July 2017 09:00
> *To:* Anthony DeBarros
> *Cc:* pgAdmin Support; Shirley Wang
> *Subject:* Re: New font for testing in Query Editor tool
>
>
>
>
>
>
>
> On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros 
> wrote:
>
> I like it! I agree with the earlier poster that the line height could be
> decreased -- but not by much. Perhaps a pixel or two.
>
>
>
> Yeah, something was bugging me about it too - I think it was the line
> height.
>
>
>
>
>
> Anthony
>
>
>
>
>
>
>
>
>
> Hello
>
>
>
> We're testing out a new font for the SQL in the Query Editor tool. Here is
> a link to test builds for both windows and mac: https://developer.
> pgadmin.org/~dpage/query_tool_font_test/
>
>
>
> Let us know what your thoughts are on these font changes along with why
> you think these changes need to occur.
>
>
>
> Thanks!
>
> Shirley & Pivotal Team
>
>
>
>
>
> --
>
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
>
>
>
> --
>
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
>
>
>
>
>
> --
>
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>



-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: Cant browse servers after update to pgadmin 1.6 (server version)

[Murtuza Zabuawala]

Can you please open browser developer tool
 and check the Console tab if there
is any error on console when you load the page?



--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Jul 19, 2017 at 5:40 PM, Mike Surcouf  wrote:

> BTW I disabled upgrade check
>
>
>
> UPGRADE_CHECK_ENABLED = False
>
>
>
> in config.py
>
>
>
> The
>
>
>
> URLError: 
>
> error is now gone but I still have no nodes in my browser pane and the add
> a server link doesn’t work
>
>
>
> Thanks
>
>
>
> Mike
>
>
>
>
>
> *From:* Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
> *Sent:* 19 July 2017 13:03
> *To:* Mike Surcouf
> *Cc:* pgadmin-supp...@postgresql.org
> *Subject:* Re: Cant browse servers after update to pgadmin 1.6 (server
> version)
>
>
>
> Are you running pgAdmin4 on Apache or  any other server?
>
> (If so then can you try restarting your apache or respective web server
> service as well)
>
>
>
>
>
> On Wed, Jul 19, 2017 at 5:25 PM, Mike Surcouf 
> wrote:
>
> Same thing.
>
>
>
> In the end I deleted everything in
>
>
>
> /var/pgadmin/.pgadmin
>
>
>
> then ran
>
>
>
> su -s /bin/sh -c 'python /usr/lib/python2.7/site-
> packages/pgadmin4-web/setup.py' pgadmin
>
>
>
> Still no nodes in the browser pane
>
>
>
> *From:* Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
> *Sent:* 19 July 2017 12:45
> *To:* Mike Surcouf
> *Cc:* pgadmin-supp...@postgresql.org
> *Subject:* Re: Cant browse servers after update to pgadmin 1.6 (server
> version)
>
>
>
> Hi,
>
>
>
> It looks like you pgAdmin4 configuration file got corrupted.
>
> Can you rename your pgAdmin4 configuration file and try to start pgAdmin4
> again?
>
>
>
> mv ~/.pgadmin/pgadmin4.db ~/.pgadmin/pgadmin4.db_old
>
>
>
>
>
> --
>
> Regards,
>
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
>
> On Wed, Jul 19, 2017 at 5:08 PM, Mike Surcouf 
> wrote:
>
> package pgadmin4-v1-web.noarch  1.6-2.rhel7
> After update of the above package from 1.5  I now see no nodes in the
> browser column soI cant do anything.
>
> sample of my error log
>
> [Wed Jul 19 12:31:13.159426 2017] [:error] [pid 1428] URLError:  error [Errno 101] Network is unreachable>
> [Wed Jul 19 12:31:15.904561 2017] [:error] [pid 1428] 2017-07-19
> 12:31:15,904: ERROR\tpgadmin:\tException when checking for update
> [Wed Jul 19 12:31:15.904576 2017] [:error] [pid 1428] Traceback (most
> recent call last):
> [Wed Jul 19 12:31:15.904579 2017] [:error] [pid 1428]   File
> "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/browser/__init__.py",
> line 482, in index
> [Wed Jul 19 12:31:15.904582 2017] [:error] [pid 1428] response =
> urlreq.urlopen(url, data, 5)
> [Wed Jul 19 12:31:15.904584 2017] [:error] [pid 1428]   File
> "/usr/lib64/python2.7/urllib2.py", line 154, in urlopen
> [Wed Jul 19 12:31:15.904587 2017] [:error] [pid 1428] return
> opener.open(url, data, timeout)
> [Wed Jul 19 12:31:15.904589 2017] [:error] [pid 1428]   File
> "/usr/lib64/python2.7/urllib2.py", line 431, in open
> [Wed Jul 19 12:31:15.904591 2017] [:error] [pid 1428] response =
> self._open(req, data)
> [Wed Jul 19 12:31:15.904594 2017] [:error] [pid 1428]   File
> "/usr/lib64/python2.7/urllib2.py", line 449, in _open
> [Wed Jul 19 12:31:15.904596 2017] [:error] [pid 1428] '_open', req)
> [Wed Jul 19 12:31:15.904599 2017] [:error] [pid 1428]   File
> "/usr/lib64/python2.7/urllib2.py", line 409, in _call_chain
> [Wed Jul 19 12:31:15.904617 2017] [:error] [pid 1428] result =
> func(*args)
> [Wed Jul 19 12:31:15.904620 2017] [:error] [pid 1428]   File
> "/usr/lib64/python2.7/urllib2.py", line 1258, in https_open
> [Wed Jul 19 12:31:15.904622 2017] [:error] [pid 1428]
>  context=self._context, check_hostname=self._check_hostname)
> [Wed Jul 19 12:31:15.904625 2017] [:error] [pid 1428]   File
> "/usr/lib64/python2.7/urllib2.py", line 1214, in do_open
> [Wed Jul 19 12:31:15.904627 2017] [:error] [pid 1428] raise
> URLError(err)
> [Wed Jul 19 12:31:15.904629 2017] [:error] [pid 1428] URLError:  error [Errno 101] Network is unreachable>
>
>
>
>
>

RE: New font for testing in Query Editor tool

[Mike Surcouf]

Is that font available on all browsers iPad etc?

From: Dave Page [mailto:dp...@pgadmin.org]
Sent: 19 July 2017 13:11
To: matshyeq
Cc: Mike Surcouf; Anthony DeBarros; pgAdmin Support; Shirley Wang
Subject: Re: New font for testing in Query Editor tool

Monospace, which we currently use, and Menlo, the proposed new default.

On Wed, Jul 19, 2017 at 12:58 PM, matshyeq 
mailto:matsh...@gmail.com>> wrote:
What are the options?

On 19 July 2017 at 10:37, Dave Page 
mailto:dp...@pgadmin.org>> wrote:


On Wed, Jul 19, 2017 at 9:34 AM, Mike Surcouf 
mailto:mi...@surcouf.co.uk>> wrote:
Maybe I’m missing something,

Shouldn’t all code including SQL use fixed width font?

It does. The question is, *which* fixed width font.


From: Dave Page [mailto:dp...@pgadmin.org]
Sent: 19 July 2017 09:00
To: Anthony DeBarros
Cc: pgAdmin Support; Shirley Wang
Subject: Re: New font for testing in Query Editor tool



On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros 
mailto:adebar...@gmail.com>> wrote:
I like it! I agree with the earlier poster that the line height could be 
decreased -- but not by much. Perhaps a pixel or two.

Yeah, something was bugging me about it too - I think it was the line height.


Anthony




Hello

We're testing out a new font for the SQL in the Query Editor tool. Here is a 
link to test builds for both windows and mac: 
https://developer.pgadmin.org/~dpage/query_tool_font_test/

Let us know what your thoughts are on these font changes along with why you 
think these changes need to occur.

Thanks!
Shirley & Pivotal Team


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: New font for testing in Query Editor tool

[Dave Page]

Monospace, which we currently use, and Menlo, the proposed new default.

On Wed, Jul 19, 2017 at 12:58 PM, matshyeq  wrote:

> What are the options?
>
> On 19 July 2017 at 10:37, Dave Page  wrote:
>
>>
>>
>> On Wed, Jul 19, 2017 at 9:34 AM, Mike Surcouf 
>> wrote:
>>
>>> Maybe I’m missing something,
>>>
>>>
>>>
>>> Shouldn’t all code including SQL use fixed width font?
>>>
>>
>> It does. The question is, *which* fixed width font.
>>
>>
>>>
>>>
>>> *From:* Dave Page [mailto:dp...@pgadmin.org]
>>> *Sent:* 19 July 2017 09:00
>>> *To:* Anthony DeBarros
>>> *Cc:* pgAdmin Support; Shirley Wang
>>> *Subject:* Re: New font for testing in Query Editor tool
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros 
>>> wrote:
>>>
>>> I like it! I agree with the earlier poster that the line height could be
>>> decreased -- but not by much. Perhaps a pixel or two.
>>>
>>>
>>>
>>> Yeah, something was bugging me about it too - I think it was the line
>>> height.
>>>
>>>
>>>
>>>
>>>
>>> Anthony
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> Hello
>>>
>>>
>>>
>>> We're testing out a new font for the SQL in the Query Editor tool. Here
>>> is a link to test builds for both windows and mac:
>>> https://developer.pgadmin.org/~dpage/query_tool_font_test/
>>>
>>>
>>>
>>> Let us know what your thoughts are on these font changes along with why
>>> you think these changes need to occur.
>>>
>>>
>>>
>>> Thanks!
>>>
>>> Shirley & Pivotal Team
>>>
>>>
>>>
>>>
>>>
>>> --
>>>
>>> Dave Page
>>> Blog: http://pgsnake.blogspot.com
>>> Twitter: @pgsnake
>>>
>>> EnterpriseDB UK: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>
>>
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

RE: Cant browse servers after update to pgadmin 1.6 (server version)

[Mike Surcouf]

BTW I disabled upgrade check

UPGRADE_CHECK_ENABLED = False

in config.py

The

URLError: 

error is now gone but I still have no nodes in my browser pane and the add a 
server link doesn’t work

Thanks

Mike


From: Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
Sent: 19 July 2017 13:03
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)

Are you running pgAdmin4 on Apache or  any other server?
(If so then can you try restarting your apache or respective web server service 
as well)


On Wed, Jul 19, 2017 at 5:25 PM, Mike Surcouf 
mailto:mi...@surcouf.co.uk>> wrote:
Same thing.

In the end I deleted everything in

/var/pgadmin/.pgadmin

then ran

su -s /bin/sh -c 'python 
/usr/lib/python2.7/site-packages/pgadmin4-web/setup.py' pgadmin

Still no nodes in the browser pane

From: Murtuza Zabuawala 
[mailto:murtuza.zabuaw...@enterprisedb.com]
Sent: 19 July 2017 12:45
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)

Hi,

It looks like you pgAdmin4 configuration file got corrupted.
Can you rename your pgAdmin4 configuration file and try to start pgAdmin4 again?

mv ~/.pgadmin/pgadmin4.db ~/.pgadmin/pgadmin4.db_old


--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Jul 19, 2017 at 5:08 PM, Mike Surcouf 
mailto:mi...@surcouf.co.uk>> wrote:
package pgadmin4-v1-web.noarch  1.6-2.rhel7
After update of the above package from 1.5  I now see no nodes in the browser 
column soI cant do anything.

sample of my error log

[Wed Jul 19 12:31:13.159426 2017] [:error] [pid 1428] URLError: 
[Wed Jul 19 12:31:15.904561 2017] [:error] [pid 1428] 2017-07-19 12:31:15,904: 
ERROR\tpgadmin:\tException when checking for update
[Wed Jul 19 12:31:15.904576 2017] [:error] [pid 1428] Traceback (most recent 
call last):
[Wed Jul 19 12:31:15.904579 2017] [:error] [pid 1428]   File 
"/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/browser/__init__.py", 
line 482, in index
[Wed Jul 19 12:31:15.904582 2017] [:error] [pid 1428] response = 
urlreq.urlopen(url, data, 5)
[Wed Jul 19 12:31:15.904584 2017] [:error] [pid 1428]   File 
"/usr/lib64/python2.7/urllib2.py", line 154, in urlopen
[Wed Jul 19 12:31:15.904587 2017] [:error] [pid 1428] return 
opener.open(url, data, timeout)
[Wed Jul 19 12:31:15.904589 2017] [:error] [pid 1428]   File 
"/usr/lib64/python2.7/urllib2.py", line 431, in open
[Wed Jul 19 12:31:15.904591 2017] [:error] [pid 1428] response = 
self._open(req, data)
[Wed Jul 19 12:31:15.904594 2017] [:error] [pid 1428]   File 
"/usr/lib64/python2.7/urllib2.py", line 449, in _open
[Wed Jul 19 12:31:15.904596 2017] [:error] [pid 1428] '_open', req)
[Wed Jul 19 12:31:15.904599 2017] [:error] [pid 1428]   File 
"/usr/lib64/python2.7/urllib2.py", line 409, in _call_chain
[Wed Jul 19 12:31:15.904617 2017] [:error] [pid 1428] result = func(*args)
[Wed Jul 19 12:31:15.904620 2017] [:error] [pid 1428]   File 
"/usr/lib64/python2.7/urllib2.py", line 1258, in https_open
[Wed Jul 19 12:31:15.904622 2017] [:error] [pid 1428] 
context=self._context, check_hostname=self._check_hostname)
[Wed Jul 19 12:31:15.904625 2017] [:error] [pid 1428]   File 
"/usr/lib64/python2.7/urllib2.py", line 1214, in do_open
[Wed Jul 19 12:31:15.904627 2017] [:error] [pid 1428] raise URLError(err)
[Wed Jul 19 12:31:15.904629 2017] [:error] [pid 1428] URLError: 

Re: Cant browse servers after update to pgadmin 1.6 (server version)

[Murtuza Zabuawala]

Are you running pgAdmin4 on Apache or  any other server?
(If so then can you try restarting your apache or respective web server
service as well)


On Wed, Jul 19, 2017 at 5:25 PM, Mike Surcouf  wrote:

> Same thing.
>
>
>
> In the end I deleted everything in
>
>
>
> /var/pgadmin/.pgadmin
>
>
>
> then ran
>
>
>
> su -s /bin/sh -c 'python /usr/lib/python2.7/site-
> packages/pgadmin4-web/setup.py' pgadmin
>
>
>
> Still no nodes in the browser pane
>
>
>
> *From:* Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
> *Sent:* 19 July 2017 12:45
> *To:* Mike Surcouf
> *Cc:* pgadmin-supp...@postgresql.org
> *Subject:* Re: Cant browse servers after update to pgadmin 1.6 (server
> version)
>
>
>
> Hi,
>
>
>
> It looks like you pgAdmin4 configuration file got corrupted.
>
> Can you rename your pgAdmin4 configuration file and try to start pgAdmin4
> again?
>
>
>
> mv ~/.pgadmin/pgadmin4.db ~/.pgadmin/pgadmin4.db_old
>
>
>
>
>
> --
>
> Regards,
>
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
>
> On Wed, Jul 19, 2017 at 5:08 PM, Mike Surcouf 
> wrote:
>
> package pgadmin4-v1-web.noarch  1.6-2.rhel7
> After update of the above package from 1.5  I now see no nodes in the
> browser column soI cant do anything.
>
> sample of my error log
>
> [Wed Jul 19 12:31:13.159426 2017] [:error] [pid 1428] URLError:  error [Errno 101] Network is unreachable>
> [Wed Jul 19 12:31:15.904561 2017] [:error] [pid 1428] 2017-07-19
> 12:31:15,904: ERROR\tpgadmin:\tException when checking for update
> [Wed Jul 19 12:31:15.904576 2017] [:error] [pid 1428] Traceback (most
> recent call last):
> [Wed Jul 19 12:31:15.904579 2017] [:error] [pid 1428]   File
> "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/browser/__init__.py",
> line 482, in index
> [Wed Jul 19 12:31:15.904582 2017] [:error] [pid 1428] response =
> urlreq.urlopen(url, data, 5)
> [Wed Jul 19 12:31:15.904584 2017] [:error] [pid 1428]   File
> "/usr/lib64/python2.7/urllib2.py", line 154, in urlopen
> [Wed Jul 19 12:31:15.904587 2017] [:error] [pid 1428] return
> opener.open(url, data, timeout)
> [Wed Jul 19 12:31:15.904589 2017] [:error] [pid 1428]   File
> "/usr/lib64/python2.7/urllib2.py", line 431, in open
> [Wed Jul 19 12:31:15.904591 2017] [:error] [pid 1428] response =
> self._open(req, data)
> [Wed Jul 19 12:31:15.904594 2017] [:error] [pid 1428]   File
> "/usr/lib64/python2.7/urllib2.py", line 449, in _open
> [Wed Jul 19 12:31:15.904596 2017] [:error] [pid 1428] '_open', req)
> [Wed Jul 19 12:31:15.904599 2017] [:error] [pid 1428]   File
> "/usr/lib64/python2.7/urllib2.py", line 409, in _call_chain
> [Wed Jul 19 12:31:15.904617 2017] [:error] [pid 1428] result =
> func(*args)
> [Wed Jul 19 12:31:15.904620 2017] [:error] [pid 1428]   File
> "/usr/lib64/python2.7/urllib2.py", line 1258, in https_open
> [Wed Jul 19 12:31:15.904622 2017] [:error] [pid 1428]
>  context=self._context, check_hostname=self._check_hostname)
> [Wed Jul 19 12:31:15.904625 2017] [:error] [pid 1428]   File
> "/usr/lib64/python2.7/urllib2.py", line 1214, in do_open
> [Wed Jul 19 12:31:15.904627 2017] [:error] [pid 1428] raise
> URLError(err)
> [Wed Jul 19 12:31:15.904629 2017] [:error] [pid 1428] URLError:  error [Errno 101] Network is unreachable>
>
>
>

Re: New font for testing in Query Editor tool

[matshyeq]

What are the options?

On 19 July 2017 at 10:37, Dave Page  wrote:

>
>
> On Wed, Jul 19, 2017 at 9:34 AM, Mike Surcouf  wrote:
>
>> Maybe I’m missing something,
>>
>>
>>
>> Shouldn’t all code including SQL use fixed width font?
>>
>
> It does. The question is, *which* fixed width font.
>
>
>>
>>
>> *From:* Dave Page [mailto:dp...@pgadmin.org]
>> *Sent:* 19 July 2017 09:00
>> *To:* Anthony DeBarros
>> *Cc:* pgAdmin Support; Shirley Wang
>> *Subject:* Re: New font for testing in Query Editor tool
>>
>>
>>
>>
>>
>>
>>
>> On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros 
>> wrote:
>>
>> I like it! I agree with the earlier poster that the line height could be
>> decreased -- but not by much. Perhaps a pixel or two.
>>
>>
>>
>> Yeah, something was bugging me about it too - I think it was the line
>> height.
>>
>>
>>
>>
>>
>> Anthony
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Hello
>>
>>
>>
>> We're testing out a new font for the SQL in the Query Editor tool. Here
>> is a link to test builds for both windows and mac:
>> https://developer.pgadmin.org/~dpage/query_tool_font_test/
>>
>>
>>
>> Let us know what your thoughts are on these font changes along with why
>> you think these changes need to occur.
>>
>>
>>
>> Thanks!
>>
>> Shirley & Pivotal Team
>>
>>
>>
>>
>>
>> --
>>
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

RE: Cant browse servers after update to pgadmin 1.6 (server version)

[Mike Surcouf]

Same thing.

In the end I deleted everything in

/var/pgadmin/.pgadmin

then ran

su -s /bin/sh -c 'python 
/usr/lib/python2.7/site-packages/pgadmin4-web/setup.py' pgadmin

Still no nodes in the browser pane

From: Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
Sent: 19 July 2017 12:45
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)

Hi,

It looks like you pgAdmin4 configuration file got corrupted.
Can you rename your pgAdmin4 configuration file and try to start pgAdmin4 again?

mv ~/.pgadmin/pgadmin4.db ~/.pgadmin/pgadmin4.db_old


--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Jul 19, 2017 at 5:08 PM, Mike Surcouf 
mailto:mi...@surcouf.co.uk>> wrote:
package pgadmin4-v1-web.noarch  1.6-2.rhel7
After update of the above package from 1.5  I now see no nodes in the browser 
column soI cant do anything.

sample of my error log

[Wed Jul 19 12:31:13.159426 2017] [:error] [pid 1428] URLError: 
[Wed Jul 19 12:31:15.904561 2017] [:error] [pid 1428] 2017-07-19 12:31:15,904: 
ERROR\tpgadmin:\tException when checking for update
[Wed Jul 19 12:31:15.904576 2017] [:error] [pid 1428] Traceback (most recent 
call last):
[Wed Jul 19 12:31:15.904579 2017] [:error] [pid 1428]   File 
"/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/browser/__init__.py", 
line 482, in index
[Wed Jul 19 12:31:15.904582 2017] [:error] [pid 1428] response = 
urlreq.urlopen(url, data, 5)
[Wed Jul 19 12:31:15.904584 2017] [:error] [pid 1428]   File 
"/usr/lib64/python2.7/urllib2.py", line 154, in urlopen
[Wed Jul 19 12:31:15.904587 2017] [:error] [pid 1428] return 
opener.open(url, data, timeout)
[Wed Jul 19 12:31:15.904589 2017] [:error] [pid 1428]   File 
"/usr/lib64/python2.7/urllib2.py", line 431, in open
[Wed Jul 19 12:31:15.904591 2017] [:error] [pid 1428] response = 
self._open(req, data)
[Wed Jul 19 12:31:15.904594 2017] [:error] [pid 1428]   File 
"/usr/lib64/python2.7/urllib2.py", line 449, in _open
[Wed Jul 19 12:31:15.904596 2017] [:error] [pid 1428] '_open', req)
[Wed Jul 19 12:31:15.904599 2017] [:error] [pid 1428]   File 
"/usr/lib64/python2.7/urllib2.py", line 409, in _call_chain
[Wed Jul 19 12:31:15.904617 2017] [:error] [pid 1428] result = func(*args)
[Wed Jul 19 12:31:15.904620 2017] [:error] [pid 1428]   File 
"/usr/lib64/python2.7/urllib2.py", line 1258, in https_open
[Wed Jul 19 12:31:15.904622 2017] [:error] [pid 1428] 
context=self._context, check_hostname=self._check_hostname)
[Wed Jul 19 12:31:15.904625 2017] [:error] [pid 1428]   File 
"/usr/lib64/python2.7/urllib2.py", line 1214, in do_open
[Wed Jul 19 12:31:15.904627 2017] [:error] [pid 1428] raise URLError(err)
[Wed Jul 19 12:31:15.904629 2017] [:error] [pid 1428] URLError: 

Re: Cant browse servers after update to pgadmin 1.6 (server version)

[Murtuza Zabuawala]

Hi,

It looks like you pgAdmin4 configuration file got corrupted.
Can you rename your pgAdmin4 configuration file and try to start pgAdmin4
again?

mv ~/.pgadmin/pgadmin4.db ~/.pgadmin/pgadmin4.db_old


--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Jul 19, 2017 at 5:08 PM, Mike Surcouf  wrote:

> package pgadmin4-v1-web.noarch  1.6-2.rhel7
> After update of the above package from 1.5  I now see no nodes in the
> browser column soI cant do anything.
>
> sample of my error log
>
> [Wed Jul 19 12:31:13.159426 2017] [:error] [pid 1428] URLError:  error [Errno 101] Network is unreachable>
> [Wed Jul 19 12:31:15.904561 2017] [:error] [pid 1428] 2017-07-19
> 12:31:15,904: ERROR\tpgadmin:\tException when checking for update
> [Wed Jul 19 12:31:15.904576 2017] [:error] [pid 1428] Traceback (most
> recent call last):
> [Wed Jul 19 12:31:15.904579 2017] [:error] [pid 1428]   File
> "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/browser/__init__.py",
> line 482, in index
> [Wed Jul 19 12:31:15.904582 2017] [:error] [pid 1428] response =
> urlreq.urlopen(url, data, 5)
> [Wed Jul 19 12:31:15.904584 2017] [:error] [pid 1428]   File
> "/usr/lib64/python2.7/urllib2.py", line 154, in urlopen
> [Wed Jul 19 12:31:15.904587 2017] [:error] [pid 1428] return
> opener.open(url, data, timeout)
> [Wed Jul 19 12:31:15.904589 2017] [:error] [pid 1428]   File
> "/usr/lib64/python2.7/urllib2.py", line 431, in open
> [Wed Jul 19 12:31:15.904591 2017] [:error] [pid 1428] response =
> self._open(req, data)
> [Wed Jul 19 12:31:15.904594 2017] [:error] [pid 1428]   File
> "/usr/lib64/python2.7/urllib2.py", line 449, in _open
> [Wed Jul 19 12:31:15.904596 2017] [:error] [pid 1428] '_open', req)
> [Wed Jul 19 12:31:15.904599 2017] [:error] [pid 1428]   File
> "/usr/lib64/python2.7/urllib2.py", line 409, in _call_chain
> [Wed Jul 19 12:31:15.904617 2017] [:error] [pid 1428] result =
> func(*args)
> [Wed Jul 19 12:31:15.904620 2017] [:error] [pid 1428]   File
> "/usr/lib64/python2.7/urllib2.py", line 1258, in https_open
> [Wed Jul 19 12:31:15.904622 2017] [:error] [pid 1428]
>  context=self._context, check_hostname=self._check_hostname)
> [Wed Jul 19 12:31:15.904625 2017] [:error] [pid 1428]   File
> "/usr/lib64/python2.7/urllib2.py", line 1214, in do_open
> [Wed Jul 19 12:31:15.904627 2017] [:error] [pid 1428] raise
> URLError(err)
> [Wed Jul 19 12:31:15.904629 2017] [:error] [pid 1428] URLError:  error [Errno 101] Network is unreachable>
>

Re: New font for testing in Query Editor tool

[Dave Page]

On Wed, Jul 19, 2017 at 9:34 AM, Mike Surcouf  wrote:

> Maybe I’m missing something,
>
>
>
> Shouldn’t all code including SQL use fixed width font?
>

It does. The question is, *which* fixed width font.


>
>
> *From:* Dave Page [mailto:dp...@pgadmin.org]
> *Sent:* 19 July 2017 09:00
> *To:* Anthony DeBarros
> *Cc:* pgAdmin Support; Shirley Wang
> *Subject:* Re: New font for testing in Query Editor tool
>
>
>
>
>
>
>
> On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros 
> wrote:
>
> I like it! I agree with the earlier poster that the line height could be
> decreased -- but not by much. Perhaps a pixel or two.
>
>
>
> Yeah, something was bugging me about it too - I think it was the line
> height.
>
>
>
>
>
> Anthony
>
>
>
>
>
>
>
>
>
> Hello
>
>
>
> We're testing out a new font for the SQL in the Query Editor tool. Here is
> a link to test builds for both windows and mac: https://developer.
> pgadmin.org/~dpage/query_tool_font_test/
>
>
>
> Let us know what your thoughts are on these font changes along with why
> you think these changes need to occur.
>
>
>
> Thanks!
>
> Shirley & Pivotal Team
>
>
>
>
>
> --
>
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>



-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

RE: New font for testing in Query Editor tool

[Mike Surcouf]

Maybe I’m missing something,

Shouldn’t all code including SQL use fixed width font?

From: Dave Page [mailto:dp...@pgadmin.org]
Sent: 19 July 2017 09:00
To: Anthony DeBarros
Cc: pgAdmin Support; Shirley Wang
Subject: Re: New font for testing in Query Editor tool



On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros 
mailto:adebar...@gmail.com>> wrote:
I like it! I agree with the earlier poster that the line height could be 
decreased -- but not by much. Perhaps a pixel or two.

Yeah, something was bugging me about it too - I think it was the line height.


Anthony




Hello

We're testing out a new font for the SQL in the Query Editor tool. Here is a 
link to test builds for both windows and mac: 
https://developer.pgadmin.org/~dpage/query_tool_font_test/

Let us know what your thoughts are on these font changes along with why you 
think these changes need to occur.

Thanks!
Shirley & Pivotal Team


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: pgAdmin 4 v1.6 Released!

[Johann Spies]

  pts rule name  description
  -- --
 -1.0 ALL_TRUSTEDPassed through trusted hosts only via SMTP
  0.5 RP_MATCHES_RCVDEnvelope sender domain matches handover relay 
domain
  2.5 BAYES_50   BODY: Bayes spam probability is 40 to 60%
 [score: 0.5000]
X-Pg-Spam-Score: -4.2 ()

On Wed, Jul 19, 2017 at 09:12:12AM +0100, Dave Page wrote:

> That certainly screams of 'messed up installation'. It gets that number
> from config.py.

I stopped using pgadmin4 after the first few versions and will probably
try it out again.  One of the things that makes me less enthusiastic
about trying out again is the installation process.  I do not want to go
through all the "README"'s and installation instructions again every
time there is a new version just to get it working.

Fortunately I have seen somewhere there is a promise of a package for
Debian.  I will wait for it.

Making the installation process (or at least the update process) easier
should be a prioirity.

Regards
Johann
-- 
Johann SpiesTelefoon: 021-808 4699
Databestuurder /  Data manager  Faks: 021-883 3691

Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology 
Universiteit Stellenbosch.

The integrity and confidentiality of this email is governed by these terms / 
Hierdie terme bepaal die integriteit en vertroulikheid van hierdie epos. 
http://www.sun.ac.za/emaildisclaimer

Re: pgAdmin 4 v1.6 Released!

[Dave Page]

[Narrowing the addressee list]

Hi

On Tue, Jul 18, 2017 at 11:14 PM, Pawel Hadam  wrote:

> Hi Dave,
>
> Thank you for this advise.
>
> Please find attached my files:
>
> 1) C:\Users\pawelhadam\AppData\Roaming\pgAdmin\pgadmin4.log
>
> I cannot understand why this log file says "Starting pgAdmin 4 v1.5..." as
> I have installed v1.6 from pgadmin4-1.6-x86.exe
>

That certainly screams of 'messed up installation'. It gets that number
from config.py.


>
> 2) C:\Program Files (x86)\pgAdmin 4\v1\web\config_local.py
>

I'm surprised it even works with that - it looks like a direct copy of
config.py, and if you look at the end is basically importing itself.

Please uninstall pgAdmin, and ensure C:\Program Files (x86)\pgAdmin 4 is
completely removed. I would also suggest removing %APPDATA%\pgAdmin as well
(note that will delete your config database so you'll have to re-add any
registered servers).

Then, using regedit.exe, remove the registry key:
HKEY_CURRENT_USER\Software\pgadmin\pgadmin4

Once the system is completely cleaned, try a fresh installation.

Regards, Dave.


>
> Thank you and kind regards
> Pawel
>
>
> On 17 July 2017 at 09:36, Dave Page  wrote:
>
>>
>>
>> On Fri, Jul 14, 2017 at 1:58 PM, Pawel Hadam  wrote:
>>
>>> Thank you Dave and Khushboo for advises.
>>>
>>> 1) (re)moving 'pgadmin4.db' - did not help.
>>>
>>> 2) I have disabled teredo - did not help.
>>>
>>> 3) localhost is resolved to IPv6 address:
>>>
>>> $ ping localhost
>>>
>>> Pinging ogrodowa [::1] with 32 bytes of data:
>>> Reply from ::1: time<1ms
>>> Reply from ::1: time<1ms
>>> Reply from ::1: time<1ms
>>> Reply from ::1: time<1ms
>>>
>>> 4) I DO use IPv4 as well.
>>>
>>> 5) No entries for localhost in hosts file.
>>>
>>> 6) On which address/port the server should be listening?
>>>
>>> $ netstat -a | grep LISTEN | grep "127.0.0.1"
>>>   TCP127.0.0.1:3212 ogrodowa:0 LISTENING
>>>   TCP127.0.0.1:3213 ogrodowa:0 LISTENING
>>>   TCP127.0.0.1:4370 ogrodowa:0 LISTENING
>>>   TCP127.0.0.1:4371 ogrodowa:0 LISTENING
>>>   TCP127.0.0.1:4380 ogrodowa:0 LISTENING
>>>   TCP127.0.0.1:4381 ogrodowa:0 LISTENING
>>>   TCP127.0.0.1:5037 ogrodowa:0 LISTENING
>>>   TCP127.0.0.1:9990 ogrodowa:0 LISTENING
>>>   TCP127.0.0.1:3ogrodowa:0 LISTENING
>>>   TCP127.0.0.1:49674ogrodowa:0 LISTENING
>>>
>>> 7) ping to 127.0.0.1 works well:
>>>
>>> $ ping 127.0.0.1
>>>
>>> Pinging 127.0.0.1 with 32 bytes of data:
>>> Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
>>> Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
>>> Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
>>> Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
>>>
>>>
>>> Not sure what else I need to check...
>>>
>>
>> In the web/ subdirectory of the installation, you should find a file
>> called config.py. Please create a file called config_local.py in the same
>> directory, containing the following lines (excluding the  lines) :
>>
>> 
>> from config import *
>>
>> # Debug mode
>> DEBUG = True
>>
>> # Log
>> CONSOLE_LOG_LEVEL = DEBUG
>> FILE_LOG_LEVEL = DEBUG
>> 
>>
>> Then, try to start pgAdmin. That should create a more useful logfile in
>> %APPDATA%\pgAdmin to share with us.
>>
>> Thanks.
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: New font for testing in Query Editor tool

[Dave Page]

On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros 
wrote:

> I like it! I agree with the earlier poster that the line height could be
> decreased -- but not by much. Perhaps a pixel or two.
>

Yeah, something was bugging me about it too - I think it was the line
height.


>
> Anthony
>
>
>
>
> Hello
>
>
>
> We're testing out a new font for the SQL in the Query Editor tool. Here is
> a link to test builds for both windows and mac: https://developer.
> pgadmin.org/~dpage/query_tool_font_test/
>
>
>
> Let us know what your thoughts are on these font changes along with why
> you think these changes need to occur.
>
>
>
> Thanks!
>
> Shirley & Pivotal Team
>
>


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company