"Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au> writes:
> I think I've found my problem:
> I don't know how or when those tables were created in template1 - they're
> certainly not supposed to be there or needed. Is it safe to just DROP the
> tables from template1?
Yeah, but what other user-created stuff (functions for instance) might
be in there?
You might want to drop template1 and recreate it from template0.
(There's a blow-by-blow article about doing that on techdocs, IIRC.)
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Phillip Smith||Date: 2007-12-31 02:18:19|
|Subject: Re: Restoring pg_dump Backup with psql Fails |
|Previous:||From: Phillip Smith||Date: 2007-12-31 01:40:12|
|Subject: Re: Restoring pg_dump Backup with psql Fails|