Re: [GENERAL] template0 and template1 databases

2001-09-06 Thread Andrew Gould
ake sure you don't do so in the > interim :-) > > - Original Message - > From: "Andrew Gould" <[EMAIL PROTECTED]> > To: "J.H.M. Dassen (Ray)" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Thursday, September 06, 2001 7:51 AM > Subj

Re: [GENERAL] template0 and template1 databases

2001-09-06 Thread Jeff Eckermann
uot; <[EMAIL PROTECTED]> To: "J.H.M. Dassen (Ray)" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, September 06, 2001 7:51 AM Subject: Re: [GENERAL] template0 and template1 databases > Thanks for the info and link. > > So if I'm running PostgreSQL

[GENERAL] template0 and template1 databases

2001-09-06 Thread Andrew Gould
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 separa