| From: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
|---|---|
| To: | Postgres Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | template0 and template1 databases |
| Date: | 2001-09-06 12:20:14 |
| Message-ID: | 20010906122014.17128.qmail@web13407.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I notice that template0 can't be vacuumed; and that
template1 gets vacuumed but has "no relations" per \d.
What do these databases do?
I have a python script that finds all database names
per 'psql -l', vacuums and analyzes them ('vacuumdb -a
-z'), and then pg_dumps them through gzip into
separate files in a defined backup directory.
Currently, the script excludes template0 and template1
from being dumped and gzipped. Is this correct? Does
this matter?
I would like to offer up this script and one other for
others to use; but am trying to clean them up first.
Thanks,
Andrew
__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | J.H.M. Dassen (Ray) | 2001-09-06 12:34:07 | Re: template0 and template1 databases |
| Previous Message | Eric Kolve | 2001-09-06 12:01:41 | getting inherited table name |