Re: PGAdmin Version 2.1

[Murtuza Zabuawala]

Hello,

I think you have enabled "Show system objects" option from Preferences
dialog due to which you are able to see them in types.

Could you confirm that by navigating "File" -> "Preferences" -> "Browser"
-> "Display" (Check screenshot for more information), If it is set to
"True" then this not a bug and it is expected behaviour, You can set it to
"False" and reload pgAdmin4 if you don't want to display system objects.

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


On Mon, Jan 29, 2018 at 8:19 PM, ldrlj1 
wrote:

> Hello,
> I believe I have found a bug.
>
> OS Windows 7.
> Postgres 9.6.5
> PGAdmin Version 2.1
>   - Python Version 2.7.13
>   - Flask Version 0.12.2
>   - Application Mode Desktop
>
> When viewing my DB through PGAdmin, it shows I have 233 types. It seems
> that
> PGAdmin is displaying every sequence and table as a type. The create type
> command in the SQL window has the tableoid, cmax, xmax, cmin, xmin and ctid
> columns as well as table column names. The sequence create type command
> shows the same system columns as well as all of the properties of a
> sequence.
>
> None of those types show when I execute \dT from psql or when I view types
> within PGAdmin 3.
>
>
>
>
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support
> -f2191615.html
>
>

Re: Select, Update, and Insert script generation fails to load

[Khushboo Vashi]

Hi,

Please provide below details:

1. Screen-shot for the same
2. pgAdmin logs, please refer https://www.pgadmin.org/faq/#8 to enable
logging
3. Is this issue reproducible with some particular scenario?

Thanks,
Khushboo

On Tue, Jan 30, 2018 at 2:39 AM, Michael Rasmussen 
wrote:

> *Version*
>
> 2.1
>
> *Copyright*
>
> Copyright 2013 - 2018, The pgAdmin Development Team
>
> *Python Version*
>
> 2.7.10 (default, Jul 30 2016, 19:40:32) [GCC 4.2.1 Compatible Apple LLVM
> 8.0.0 (clang-800.0.34)]
>
> *Flask Version*
>
> 0.11.1
>
> *Application Mode*
>
> Desktop
>
> *Current User*
>
> pgadm...@pgadmin.org
>
>
>
> *Operating System*
>
> macOS High Sierra 10.13.2
>
>
>
> *PostgreSQL Cluster*
>
> PostgreSQL 9.6.5 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.7.2-5)
> 4.7.2, 64-bit
>
>
>
> *What is happening:*
>
>1. Right click on a table in the object browser
>2. Select Scripts
>3. Pick any of the following:
>   1. INSERT Script
>   2. SELECT Script
>   3. UPDATE Script
>4. A new tab opens with spinning wait wheel
>5. When the spinning wheel clears the text editor is empty
>
>
>
> Note: the CREATE and DELETE script properly load
>
>
>
> *What is expected:*
>
> The new tab should populate with the appropriate SQL.
>
>
>
> --
>
> Michael Rasmussen
>
> Sr. Data Engineer
>
> Porch
>

Select, Update, and Insert script generation fails to load

[Michael Rasmussen]

Version
2.1
Copyright
Copyright 2013 - 2018, The pgAdmin Development Team
Python Version
2.7.10 (default, Jul 30 2016, 19:40:32) [GCC 4.2.1 Compatible Apple LLVM 8.0.0 
(clang-800.0.34)]
Flask Version
0.11.1
Application Mode
Desktop
Current User
pgadm...@pgadmin.org

Operating System
macOS High Sierra 10.13.2

PostgreSQL Cluster
PostgreSQL 9.6.5 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.7.2-5) 
4.7.2, 64-bit

What is happening:

  1.  Right click on a table in the object browser
  2.  Select Scripts
  3.  Pick any of the following:
 *   INSERT Script
 *   SELECT Script
 *   UPDATE Script
  4.  A new tab opens with spinning wait wheel
  5.  When the spinning wheel clears the text editor is empty

Note: the CREATE and DELETE script properly load

What is expected:
The new tab should populate with the appropriate SQL.

--
Michael Rasmussen
Sr. Data Engineer
Porch

PGAdmin Version 2.1

[ldrlj1]

Hello,
I believe I have found a bug.

OS Windows 7.
Postgres 9.6.5
PGAdmin Version 2.1
  - Python Version 2.7.13
  - Flask Version 0.12.2
  - Application Mode Desktop

When viewing my DB through PGAdmin, it shows I have 233 types. It seems that
PGAdmin is displaying every sequence and table as a type. The create type
command in the SQL window has the tableoid, cmax, xmax, cmin, xmin and ctid
columns as well as table column names. The sequence create type command
shows the same system columns as well as all of the properties of a
sequence.

None of those types show when I execute \dT from psql or when I view types
within PGAdmin 3.




--
Sent from: 
http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

RE: Problems connecting PGAdmin to server

[Samuel Holmes]

I think it’s more likely to be my university’s WiFi.  I use the same computer 
at home as I do in university (my laptop).  How do I check to make sure that 
Heroku isn’t blocking traffic?

So if I speak to my university’s IT department, what do I need to tell them?  
Is it just a case of opening that port, or do I need to do something else?

Thanks,

[Ulster University]
Samuel Holmes
PhD Researcher
T: 028 9036 8132
E: holme...@ulster.ac.uk W: www.ulster.ac.uk
Social: Twitter: @SamuelH1982
 LinkedIn: samuelholmes82


From: David G. Johnston [mailto:david.g.johns...@gmail.com]
Sent: 29 January 2018 16:03
To: Samuel Holmes 
Cc: pgadmin-support@lists.postgresql.org
Subject: Re: Problems connecting PGAdmin to server

On Mon, Jan 29, 2018 at 8:46 AM, Samuel Holmes 
> wrote:
I am using Pgadmin as a frontend to maintain a Postgresql database hosted on 
Heroku.  If I connect to the database from my home wifi connection, it connects 
successfully.  It also connects successfully if I tether using my mobile phone. 
 However if I use my university’s student WiFi, I cannot connect and I get the 
following error:

could not connect to server: Connection timed out (0x274C/10060) Is the 
server running on host  () and accepting TCP/IP 
connections on port 5432?

How do I even begin to troubleshoot this?  I have checked that Pgadmin has 
permission in my firewall (it does), and I have checked that port, username, 
host, and password are correct (which they are as it works from home).  I 
thought maybe the port was blocked, so I used an online port checker – while it 
DID say port 5432 was closed on my university WiFi it also says this when 
tethered with my phone – but the connection DOES work on my phone.

Two simple possibilities:
Heroku is blocking on their (the server) side, not yours (the client).​
The University is blocking outbound traffic on that port.

I suspect you can check and configure the first one; the second one you'd need 
to inquire with your university's IT department.

You are using the same machine at home and at the university?  If so that 
should preclude it being your machine (though its possible your firewall has 
different settings when connected to the different wifi networks).

Online port checkers are prone to false negatives.

David J.



This email and any attachments are confidential and intended solely for the use 
of the addressee and may contain information which is covered by legal, 
professional or other privilege. If you have received this email in error 
please notify the system manager at postmas...@ulster.ac.uk and delete this 
email immediately. Any views or opinions expressed are solely those of the 
author and do not necessarily represent those of Ulster University.
The University's computer systems may be monitored and communications carried 
out on them may be recorded to secure the effective operation of the system and 
for other lawful purposes. Ulster University does not guarantee that this email 
or any attachments are free from viruses or 100% secure. Unless expressly 
stated in the body of a separate attachment, the text of email is not intended 
to form a binding contract. Correspondence to and from the University may be 
subject to requests for disclosure by 3rd parties under relevant legislation.
The Ulster University was founded by Royal Charter in 1984 and is registered 
with company number RC000726 and VAT registered number GB672390524.The primary 
contact address for Ulster University in Northern Ireland is Cromore Road, 
Coleraine, Co. Londonderry BT52 1SA

Re: Problems connecting PGAdmin to server

[David G. Johnston]

On Mon, Jan 29, 2018 at 8:46 AM, Samuel Holmes 
wrote:

> I am using Pgadmin as a frontend to maintain a Postgresql database hosted
> on Heroku.  If I connect to the database from my home wifi connection, it
> connects successfully.  It also connects successfully if I tether using my
> mobile phone.  However if I use my university’s student WiFi, I cannot
> connect and I get the following error:
>
>
>
> could not connect to server: Connection timed out (0x274C/10060) Is
> the server running on host  () and accepting TCP/IP
> connections on port 5432?
>
>
>
> How do I even begin to troubleshoot this?  I have checked that Pgadmin has
> permission in my firewall (it does), and I have checked that port,
> username, host, and password are correct (which they are as it works from
> home).  I thought maybe the port was blocked, so I used an online port
> checker – while it DID say port 5432 was closed on my university WiFi it
> also says this when tethered with my phone – but the connection DOES work
> on my phone.
>

Two simple possibilities:
Heroku is blocking on their (the server) side, not yours (the client).​
The University is blocking outbound traffic on that port.

I suspect you can check and configure the first one; the second one you'd
need to inquire with your university's IT department.

You are using the same machine at home and at the university?  If so that
should preclude it being your machine (though its possible your firewall
has different settings when connected to the different wifi networks).

Online port checkers are prone to false negatives.

David J.

Problems connecting PGAdmin to server

[Samuel Holmes]

Hi there,

I'm having an issue with Pgadmin and I'd appreciate some input as I cannot find 
anything online!

I am using Pgadmin as a frontend to maintain a Postgresql database hosted on 
Heroku.  If I connect to the database from my home wifi connection, it connects 
successfully.  It also connects successfully if I tether using my mobile phone. 
 However if I use my university's student WiFi, I cannot connect and I get the 
following error:

could not connect to server: Connection timed out (0x274C/10060) Is the 
server running on host  () and accepting TCP/IP 
connections on port 5432?

How do I even begin to troubleshoot this?  I have checked that Pgadmin has 
permission in my firewall (it does), and I have checked that port, username, 
host, and password are correct (which they are as it works from home).  I 
thought maybe the port was blocked, so I used an online port checker - while it 
DID say port 5432 was closed on my university WiFi it also says this when 
tethered with my phone - but the connection DOES work on my phone.

I really need this to be working, as it means that I cannot access the database 
from within university - pointless as it is part of my course to do so!

Thanks,

Sam



This email and any attachments are confidential and intended solely for the use 
of the addressee and may contain information which is covered by legal, 
professional or other privilege. If you have received this email in error 
please notify the system manager at postmas...@ulster.ac.uk and delete this 
email immediately. Any views or opinions expressed are solely those of the 
author and do not necessarily represent those of Ulster University.
The University's computer systems may be monitored and communications carried 
out on them may be recorded to secure the effective operation of the system and 
for other lawful purposes. Ulster University does not guarantee that this email 
or any attachments are free from viruses or 100% secure. Unless expressly 
stated in the body of a separate attachment, the text of email is not intended 
to form a binding contract. Correspondence to and from the University may be 
subject to requests for disclosure by 3rd parties under relevant legislation.
The Ulster University was founded by Royal Charter in 1984 and is registered 
with company number RC000726 and VAT registered number GB672390524.The primary 
contact address for Ulster University in Northern Ireland is Cromore Road, 
Coleraine, Co. Londonderry BT52 1SA

Re: Request for feedback: Alternate desktop runtime architecture

[Dave Page]

Hi

On Mon, Jan 29, 2018 at 2:31 AM, Anthony DeBarros 
wrote:

>
> Hi, Dave,
>
> I've been testing this on macOS High Sierra for a few days. Overall, very
> positive feedback. The app seems fast, and I've experience no glitches yet.
>

Great, thanks for testing.


>
> One minor point:
>
> In the desktop app, hovering the mouse over a cell of type "text" will
> show a tool tip with all text in that cell (e.g. the overflow that's not
> visible). That's missing in the web app.
>

It works for me in Chrome (on Sierra). What browser are you using?


>
> Aside from that, I'm not seeing anything here of concern. Nice job.
>
> Anthony
>
>
> On January 23, 2018 at 9:48:43 AM, Dave Page (dp...@pgadmin.org) wrote:
>
> All,
>
> As you may know, the most troublesome part of pgAdmin 4 has been the
> desktop runtime application, which has relied on QtWebKit and QtWebEngine
> (of various origins and versions) to render the UI as part of the Qt
> framework.
>
> This has caused performance issues, rendering issues with remote desktop
> sessions, keyboard navigation issues and more. It probably accounts for 25%
> or more of the bugs reports we deal with.
>
> Unfortunately, whilst there are alternatives to Qt for this purpose, none
> that we've found are mature enough for our purposes, and would require a
> significant amount of effort to add the features we would need to support
> pgAdmin.
>
> I've therefore been experimenting with another approach in which pgAdmin
> is rendered in a regular web browser when running in desktop mode. Like
> some other similar applications, a server process is launched and lives in
> the system tray, from where it can be shutdown at any time, or new windows
> opened. When it is first started, it will launch a browser window to render
> pgAdmin automatically. If additional instances are launched, the previously
> running instance will be re-used to avoid wasting resources.
>
> This is a proof of concept at the moment, for which I would appreciate any
> feedback. Windows and Mac builds can be found here:
>
> https://developer.pgadmin.org/~dpage/runtime-revamp/
>
> and the GIT branch can be found here:
>
> https://git.postgresql.org/gitweb/?p=pgadmin4.git;a=
> shortlog;h=refs/heads/runtime-revamp
>
> Thanks!
>
> --
> 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: pgAdmin4 from apt.postgresql.org

[Johann Spies]

On Sun, Jan 28, 2018 at 04:17:17PM +, Raymond O'Donnell wrote:
> 
> done and thanks to the packagers for their hard work.

ditto.

> However, I'm having problems installing it on my Debian Jessie laptop - I'm
> probably doing something silly and would appreciate help:

I am running buster and had to temporarily change my sources.list for
the standaard Debian packages  to sid to get all the dependencies.

> What am I doing wrong?

I am not sure.

A second option would be to download the pgadmin4, pgadmin4-common and
pgadmin4-doc packages and then install it using "dpkg -i" which will
through a lot of dependency-missing errors.  Then try apt-get -f
install.

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 e-mail is governed by these terms / 
Die integriteit en vertroulikheid van hierdie e-pos word deur die volgende 
bepalings gereël. http://www.sun.ac.za/emaildisclaimer