Hi, This issue has been already reported. https://redmine.postgresql. org/issues/3361
For time being, you can set the 'Show system objects?' to True to list down the template0 and template1. This is just a work around, this issue will be fixed. Thanks, Khushboo On Mon, 28 May 2018, 20:28 Steve Hawes, <steve.ha...@tmlep.com> wrote: > 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* <020%203355%209796> > M: *+34 681 259 532* <+34%20681%20259%20532> > E: *steve.ha...@tmlep.com* <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> > [image: > TMLEP | The Medico-Legal Experts Practice] <http://www.tmlep.com> > 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. > >
