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.
pgpyoKPx0EYdN.pgp
Description: PGP signature