Problems on MacOS High Sierra
Hi, I seem to be having a lot of issues on MacOS High Sierra with regard to being able to click and scroll. 1. Frequently the cursor changes to the compass one used for moving things around and no matter what I do I cannot get it to change back to a pointer and therefore cannot click on anything. This mostly seems to happen after I have used a two finger tap to right click on something. 2. Scrolling with a three-finger swipe is horrendously slow compared to other applications I have open and swiping the whole height of the trackpad sometimes only moves the display by 2 or 3 lines. 3. Trying to scroll on the data returned from a query (again using the 3-finger swipe) will often scroll the Browser pane instead of the data pane, even though the cursor is over the data pane. 4. Trying to click on a scrollbar and move it does not work. My version information is: Version2.1 CopyrightCopyright 2013 - 2018, The pgAdmin Development Team Python Version2.7.10 (default, Jul 30 2016, 19:40:32) [GCC 4.2.1 Compatible Apple LLVM 8.0.0 (clang-800.0.34)] Flask Version0.11.1 Application Mode Desktop Current User pgadm...@pgadmin.org My OS version is MacOS High Sierra 10.13.3 running on a 27” Late 2015 Retina 5K iMac. Can anyone suggest how to resolve these issues or are they bugs? Thanks Steve Steve Hawes CIO T: 020 3355 9796 M: +34 681 259 532 E: steve.ha...@tmlep.com W: www.tmlep.com A: 67 The Innovation Centre, University Road, Canterbury, Kent, CT2 7FG TMLEP | The Medico-Legal Experts Practice Consider the environment. Do you really need to print this email? TMLE Limited is a company registered in England and Wales under number 08092743. The company's registered office is The Chestnuts,Brewers End, Takeley, Essex CM22 6QJ United Kingdom. This message contains confidential information and is intended only for the intended recipients. If you are not an intended recipient you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. TMLEP may monitor email traffic data and also the content of emails for compliance purposes and to protect its business.
Re: Problems on MacOS High Sierra
Wow – what a quick response!! Thanks for the information. I have downloaded the new version using the link provided and it seems to work perfectly. The increase in the user experience is fantastic. Thanks for your help. P.S. Never used a mailing list before so hope I’ve replied correctly. Steve Hawes CIO T: 020 3355 9796 M: +34 681 259 532 E: steve.ha...@tmlep.com W: www.tmlep.com A: 67 The Innovation Centre, University Road, Canterbury, Kent, CT2 7FG TMLEP | The Medico-Legal Experts Practice Consider the environment. Do you really need to print this email? TMLE Limited is a company registered in England and Wales under number 08092743. The company's registered office is The Chestnuts,Brewers End, Takeley, Essex CM22 6QJ United Kingdom. This message contains confidential information and is intended only for the intended recipients. If you are not an intended recipient you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. TMLEP may monitor email traffic data and also the content of emails for compliance purposes and to protect its business. From: Dave Page Date: Wednesday, 31 January 2018 at 13:49 To: Steve Hawes Cc: "pgadmin-support@lists.postgresql.org" Subject: Re: Problems on MacOS High Sierra On Wed, Jan 31, 2018 at 1:46 PM, Steve Hawes mailto:steve.ha...@tmlep.com>> wrote: Hi, I seem to be having a lot of issues on MacOS High Sierra with regard to being able to click and scroll. 1. Frequently the cursor changes to the compass one used for moving things around and no matter what I do I cannot get it to change back to a pointer and therefore cannot click on anything. This mostly seems to happen after I have used a two finger tap to right click on something. 2. Scrolling with a three-finger swipe is horrendously slow compared to other applications I have open and swiping the whole height of the trackpad sometimes only moves the display by 2 or 3 lines. 3. Trying to scroll on the data returned from a query (again using the 3-finger swipe) will often scroll the Browser pane instead of the data pane, even though the cursor is over the data pane. 4. Trying to click on a scrollbar and move it does not work. My version information is: Version2.1 CopyrightCopyright 2013 - 2018, The pgAdmin Development Team Python Version2.7.10 (default, Jul 30 2016, 19:40:32) [GCC 4.2.1 Compatible Apple LLVM 8.0.0 (clang-800.0.34)] Flask Version0.11.1 Application Mode Desktop Current User pgadm...@pgadmin.org<mailto:pgadm...@pgadmin.org> My OS version is MacOS High Sierra 10.13.3 running on a 27” Late 2015 Retina 5K iMac. Can anyone suggest how to resolve these issues or are they bugs? They seem to be incompatibilities between High Sierra and QtWebEngine. Please try the test build at https://developer.pgadmin.org/~dpage/runtime-revamp/ which will use your default browser instead. Thanks. Thanks Steve Steve Hawes CIO [X][cid:image933000.png@5B1E594E.8E041946] T: 020 3355 9796 M: +34 681 259 532 E: steve.ha...@tmlep.com<mailto:steve.ha...@tmlep.com> W: www.tmlep.com<http://www.tmlep.com> A: 67 The Innovation Centre, University Road, Canterbury, Kent, CT2 7FG<https://www.google.com/maps/place/47+The+Innovation+Centre,+University+Road,+Canterbury,+Kent,+CT2+7FG> [TMLEP | The Medico-Legal Experts Practice]<http://www.tmlep.com/> [cid:image691002.png@2CD7E88A.71B58A48] Consider the environment. Do you really need to print this email? TMLE Limited is a company registered in England and Wales under number 08092743. The company's registered office is The Chestnuts,Brewers End, Takeley, Essex CM22 6QJ United Kingdom. This message contains confidential information and is intended only for the intended recipients. If you are not an intended recipient you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which a
Problem creating database with Postgres 10.4 on MacOS Sierra
Hi, I have just installed a clean copy of Postgres 10.4 and pgAdmin4 V3.0. When I try to create a new DB I cannot select template0 or template1 as the template because they do not appear in the list. If I execute: select datname,datistemplate from pg_database; I get the following output: datname datistemplate "postgres" false "template1" true "template0" true The templates exist but are not showing. How can I fix this please? Version 3.0 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.12.2 Application Mode Desktop Current User pgadm...@pgadmin.org Thanks Steve Steve Hawes CIO T: 020 3355 9796 M: +34 681 259 532 E: steve.ha...@tmlep.com W: www.tmlep.com A: 67 The Innovation Centre, University Road, Canterbury, Kent, CT2 7FG TMLEP | The Medico-Legal Experts Practice Consider the environment. Do you really need to print this email? TMLE Limited is a company registered in England and Wales under number 08092743. The company's registered office is The Chestnuts, Brewers End, Takeley, Essex CM22 6QJ United Kingdom. This message contains confidential information and is intended only for the intended recipients. If you are not an intended recipient you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. TMLEP may monitor email traffic data and also the content of emails for compliance purposes and to protect its business.
Change browser in MacOS
Hi, Can anyone help me with changing the browser used by pgAdmin in MacOS Mojave. I have Google Chrome installed and can see that there is a box for entering the Browser Command in the pgAdmin configuration but I cannot work out the syntax for getting Chrome to launch instead of Safari. Any help appreciated. Many thanks Steve Steve Hawes CIO T: 020 3355 9796 M: +34 681 259 532 E: steve.ha...@tmlep.com W: www.tmlep.com TMLEP | The Medico-Legal Experts Practice Consider the environment. Do you really need to print this email? TMLE Limited is a company registered in England and Wales under number 08092743. The company's registered office is The Chestnuts, Brewers End, Takeley, Essex CM22 6QJ United Kingdom. This message contains confidential information and is intended only for the intended recipients. If you are not an intended recipient you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. TMLEP may monitor email traffic data and also the content of emails for compliance purposes and to protect its business.
Re: Change browser in MacOS
Sheldon, The /usr/bin/firefox %URL% is the placeholder text that is used as an example for the browser command. I have tried with Chrome as my default browser and this works fine but I want to keep Safari as the default browser but use Chrome only for pgAdmin. Following the reply I got from Richard Coleman and after a bit of Googling for the correct command I have found the syntax to be: open -a “Google Chrome” %URL% Hope this helps someone else as well. Thanks Steve Steve Hawes CIO T: 020 3355 9796 M: +34 681 259 532 E: steve.ha...@tmlep.com W: www.tmlep.com TMLEP | The Medico-Legal Experts Practice Consider the environment. Do you really need to print this email? TMLE Limited is a company registered in England and Wales under number 08092743. The company's registered office is The Chestnuts, Brewers End, Takeley, Essex CM22 6QJ United Kingdom. This message contains confidential information and is intended only for the intended recipients. If you are not an intended recipient you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. TMLEP may monitor email traffic data and also the content of emails for compliance purposes and to protect its business. From: "Strauch, Sheldon" Date: Tuesday, 8 January 2019 at 15:42 To: richard coleman Cc: Steve Hawes , "pgadmin-support@lists.postgresql.org" Subject: Re: Change browser in MacOS Interestingly enough, I use Chrome exclusively and my Browser Command is configured to: /usr/bin/firefox %URL% When selecting New pgAdmin 4 Window... the new window opens in Chrome. Seeing as firefox is not even installed, I believe in the absence of a working command pgAdmin 4 reverts to OSX's default browser, which I do have configured to be chrome. HTH! On Tue, Jan 8, 2019 at 9:33 AM richard coleman mailto:rcoleman.ascen...@gmail.com>> wrote: Steve, Well I have mine set to launch chromium with this command: chromium-browser %URL% So I would imagine substituting the command to start chrome from the command line would suffice. Just a thought, rik. On Tue, Jan 8, 2019 at 10:02 AM Steve Hawes mailto:steve.ha...@tmlep.com>> wrote: Hi, Can anyone help me with changing the browser used by pgAdmin in MacOS Mojave. I have Google Chrome installed and can see that there is a box for entering the Browser Command in the pgAdmin configuration but I cannot work out the syntax for getting Chrome to launch instead of Safari. Any help appreciated. Many thanks Steve Steve Hawes CIO [X][cid:1682e178a07b43dd9c91] T: 020 3355 9796 M: +34 681 259 532 E: steve.ha...@tmlep.com<mailto:steve.ha...@tmlep.com> W: www.tmlep.com<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.tmlep.com&d=DwMFaQ&c=lEzKI_JJakPtcnbAQ6Q5xQ&r=3P3-5UqoQFsuwPHL1Gr-FtP4nR5GVvvXlP89XkF_Y4w&m=ItFmqS4jlcSFtQt5WH3mI1ujKvH_bBilNXKIDgD13NI&s=EbGcqC0BAITAQWtO6ao0R_gjD03R87-QTz-5k95p-co&e=> [TMLEP | The Medico-Legal Experts Practice]<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.tmlep.com&d=DwMFaQ&c=lEzKI_JJakPtcnbAQ6Q5xQ&r=3P3-5UqoQFsuwPHL1Gr-FtP4nR5GVvvXlP89XkF_Y4w&m=ItFmqS4jlcSFtQt5WH3mI1ujKvH_bBilNXKIDgD13NI&s=EbGcqC0BAITAQWtO6ao0R_gjD03R87-QTz-5k95p-co&e=> [cid:1682e178a07f49eec743] Consider the environment. Do you really need to print this email? TMLE Limited is a company registered in England and Wales under number 08092743. The company's registered office is The Chestnuts, Brewers End, Takeley, Essex CM22 6QJ United Kingdom. This message contains confidential information and is intended only for the intended recipients. If you are not an intended recipient you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. TMLEP may monitor email traffic data and also the content of emails for compliance purposes and to protect its business. -- Look after your data, and you
Progress window not closing
Hi, I started a VACUUM on a table from pgAdmin and a progress window opened as expected. Unfortunately the remote database was shutdown and restarted whilst the job was running and the process was killed on the DB server. When I got pgAdmin connected again the progress window popped straight back up (even though the vacuum is not running on the server) and I cannot find any way to get rid of it. [cid:image001.png@01D4B773.B46B9B20] Can anyone suggest anything please? Thanks Steve Steve Hawes CIO T: 020 3355 9796 M: +34 681 259 532 E: steve.ha...@tmlep.com W: www.tmlep.com A: The Chestnuts, Takeley, Essex, CM22 6QJ TMLEP | The Medico-Legal Experts Practice Consider the environment. Do you really need to print this email? TMLE Limited is a company registered in England and Wales under number 08092743. The company's registered office is The Chestnuts, Brewers End, Takeley, Essex CM22 6QJ United Kingdom. This message contains confidential information and is intended only for the intended recipients. If you are not an intended recipient you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. TMLEP may monitor email traffic data and also the content of emails for compliance purposes and to protect its business.
Re: Progress window not closing
I have done that and nothing at all happens. If I click the X to close the window it goes away for a few seconds and then immediately comes back again. I am going to try restarting the server and pgAdmin once more. Thanks Steve Steve Hawes CIO T: 020 3355 9796 M: +34 681 259 532 E: steve.ha...@tmlep.com W: www.tmlep.com A: The Chestnuts, Takeley, Essex, CM22 6QJ TMLEP | The Medico-Legal Experts Practice Consider the environment. Do you really need to print this email? TMLE Limited is a company registered in England and Wales under number 08092743. The company's registered office is The Chestnuts, Brewers End, Takeley, Essex CM22 6QJ United Kingdom. This message contains confidential information and is intended only for the intended recipients. If you are not an intended recipient you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. TMLEP may monitor email traffic data and also the content of emails for compliance purposes and to protect its business. From: Khushboo Vashi Date: Tuesday, 29 January 2019 at 03:57 To: Steve Hawes Cc: "pgadmin-support@lists.postgresql.org" Subject: Re: Progress window not closing On Tue, Jan 29, 2019 at 7:11 AM Steve Hawes mailto:steve.ha...@tmlep.com>> wrote: Hi, I started a VACUUM on a table from pgAdmin and a progress window opened as expected. Unfortunately the remote database was shutdown and restarted whilst the job was running and the process was killed on the DB server. When I got pgAdmin connected again the progress window popped straight back up (even though the vacuum is not running on the server) and I cannot find any way to get rid of it. [cid:16897bee0f24cff311] Try to stop the process by clicking on the 'Stop Process' button (red button). Can anyone suggest anything please? Thanks Steve Steve Hawes CIO [X][cid:16897bee0f25487bf902] T: 020 3355 9796 M: +34 681 259 532 E: steve.ha...@tmlep.com<mailto:steve.ha...@tmlep.com> W: www.tmlep.com<http://www.tmlep.com> A: The Chestnuts, Takeley, Essex, CM22 6QJ<https://www.google.com/maps/place/47+The+Innovation+Centre,+University+Road,+Canterbury,+Kent,+CT2+7FG> [TMLEP | The Medico-Legal Experts Practice]<http://www.tmlep.com/> [cid:16897bee0f2eac1aa0e4] Consider the environment. Do you really need to print this email? TMLE Limited is a company registered in England and Wales under number 08092743. The company's registered office is The Chestnuts, Brewers End, Takeley, Essex CM22 6QJ United Kingdom. This message contains confidential information and is intended only for the intended recipients. If you are not an intended recipient you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. TMLEP may monitor email traffic data and also the content of emails for compliance purposes and to protect its business.
Spellcheck and Autocorrect in pgAdmin interface
Hi, Is it possible to disable the browser spellcheck and auto-correct in the pgAdmin interface? Whenever I create a new database the browser changes the database name whenever I type a character that ends a word (_, - etc) if the name is not a known word. Eg. “tmle” becomes “tale”. Thanks Steve Steve Hawes CIO T: 020 3355 9796 M: +34 681 259 532 E: steve.ha...@tmlep.com W: www.tmlep.com A: The Chestnuts, Takeley, Essex, CM22 6QJ TMLEP | The Medico-Legal Experts Practice Consider the environment. Do you really need to print this email? TMLE Limited is a company registered in England and Wales under number 08092743. The company's registered office is The Chestnuts, Brewers End, Takeley, Essex CM22 6QJ United Kingdom. This message contains confidential information and is intended only for the intended recipients. If you are not an intended recipient you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. TMLEP may monitor email traffic data and also the content of emails for compliance purposes and to protect its business.