| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
| Cc: | Philip Hallstrom <postgresql(at)philip(dot)pjkh(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Reduce size of $PGDATA for "demo cdrom"? |
| Date: | 2005-04-28 13:14:11 |
| Message-ID: | 1114694051.13303.1322.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)g2switchworks(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ElayaRaja S | 2005-04-28 13:19:07 | Help |
| Previous Message | Marco Colombo | 2005-04-28 12:04:29 | Re: PRIMARY KEY on a *group* of columns imply that each column is |