On Wed, 2005-04-27 at 20:44, Bruno Wolff III wrote:
> On Wed, Apr 27, 2005 at 10:23:19 -0500,
> Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> wrote:
> >
> > My first recommendation would be to put everything into one database.
> > it looks like you've got 6 databases. If you've still got the template0
> > database, you can probably get rid of that one as well. If you're not
> > going to need to create any new databases you can maybe drop template1
> > too.
>
> Isn't template0 needed for dumps, since they are relative to template0?
No, it's template1, and you only need it for pg_dumpall. pg_dump should
still work.
Note that without template1, things like psql -l will fail. But you can
still connect to the one database you know the name of.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
