Re: Problem creating database with Postgres 10.4 on MacOS Sierra

On Mon, May 28, 2018 at 8:43 PM, Khushboo Vashi <
khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:

> 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.
>
> You can find this setting through File > Preferences > Browser > Display .

> Thanks,
> Khushboo
>
>
> On Mon, 28 May 2018, 20:28 Steve Hawes, <steve(dot)hawes(at)tmlep(dot)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*
>>
>> pgadmin4(at)pgadmin(dot)org
>>
>>
>>
>> Thanks
>>
>> Steve
>>
>> Steve Hawes​
>> CIO
>>
>> T: *020 3355 9796* <020%203355%209796>
>> M: *+34 681 259 532* <+34%20681%20259%20532>
>> E: *steve(dot)hawes(at)tmlep(dot)com* <steve(dot)hawes(at)tmlep(dot)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.
>>
>>