On 11/17/05, Martijn van Oosterhout <kleptog@svana.org> wrote: > 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. > >
That database exists beginning with 8.1... I don't think it's optional... i remember a comments from Tom telling that this database will be used to connect to for CREATE DATABASE porpouses: http://archives.postgresql.org/pgsql-committers/2005-06/msg00302.php -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster