John Hansen wrote:
> On a fresh installation of postgrsql 8.1 if you drop the
> 'postgres' database,
> psql, createdb, etc. no longer works.
>
> psql -l; ignores -dtemplate1, and createdb doesn't have such an option.
>
I can't test createdb here but on the psql... what happens if you just:
psql -Upostgres template1?
> Maybe it should fallback to template1 if the postgres database doesn't
> exist?
>
> ... John
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>