| From: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Gould <andrewgould(at)yahoo(dot)com> |
| Cc: | "J(dot)H(dot)M(dot) Dassen \(Ray\)" <jdassen(at)cistron(dot)nl>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: template0 and template1 databases |
| Date: | 2001-09-06 19:35:31 |
| Message-ID: | 20010906193531.78065.qmail@web13403.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Okay, so I don't need to pg_dump the template*
databases; and I should not dropdb them.
My scripts aren't anything to brag about; but I think
newbies (such as myself) may find them useful. Who
reviews contributions for /contrib?
Andrew
--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Andrew Gould <andrewgould(at)yahoo(dot)com> writes:
> > So if I'm running PostgreSQL 7.1.3 and have
> pg_dumped
> > my databases, I can 'dropdb template0'?
>
> That would be A Bad Move. template0 is what
> pg_dumpall expects to use
> to build new databases. See the discussion near the
> bottom of
>
http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/sql-createdatabase.html
> (possibly this should be duplicated somewhere in the
> Administrator's Guide).
>
> regards, tom lane
__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-09-06 19:42:28 | Re: template0 and template1 databases |
| Previous Message | Andrew Gould | 2001-09-06 19:27:17 | Re: template0 and template1 databases |