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