Re: Reduce size of $PGDATA for "demo cdrom"?

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@g2switchworks.com> 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.