Re: template Database

I think you want template0 and template1 because they can do important
things. Using the psql program type (or one of the GUI database front
ends like pgPhpAdmin):



         CREATE DATABASE test;


This should get you going. However, I think  "DROP template1" might be
really bad and might require another initdb or reinstall (not sure :(
I would reinstall just to be safe :)


Jeff


<excerpt><fontfamily><param>Arial</param><smaller> Template0 is
unuseable and refuses connections. Template1 is the default</smaller></fontfamily>

<fontfamily><param>Arial</param><smaller>template database. I tried
but can not drop template0. How do I rid my server of the useless
template0. The server consol will and does show Fatals when</smaller></fontfamily>

<fontfamily><param>Arial</param><smaller>inoperation.</smaller></fontfamily>

 

<fontfamily><param>Arial</param><smaller>So How do I drop the useless
template?</smaller></fontfamily>

 

<fontfamily><param>Arial</param><smaller>BobT</smaller></fontfamily>

</excerpt>I think you want template0 and template1 because they can do important
things. Using the psql program type (or one of the GUI database front
ends like pgPhpAdmin):

          CREATE DATABASE test;

This should get you going. However, I think  "DROP template1" might be
really bad and might require another initdb or reinstall (not sure :( I
would reinstall just to be safe :)

Jeff

>  Template0 is unuseable and refuses connections. Template1 is the
> default
> template database. I tried but can not drop template0. How do I rid my
> server of the useless template0. The server consol will and does show
> Fatals when
> inoperation.
>  
> So How do I drop the useless template?
>  
> BobT