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


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to