Re: Optional postgres database not so optional in 8.1

On Fri, Nov 18, 2005 at 12:01:31AM +1100, 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.

What distribution? I've never seen this "postgres" database you speak
of. It certainly not on any systems I've used. Do you have a PGDATABASE
variable in your environment?

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.