Skip site navigation (1) Skip section navigation (2)

Re: Restoring pg_dump Backup with psql Fails

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>
Cc: "'Joshua D(dot) Drake'" <jd(at)commandprompt(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Restoring pg_dump Backup with psql Fails
Date: 2007-12-31 01:59:52
Message-ID: 18927.1199066392@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"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

Responses

pgsql-admin by date

Next:From: Phillip SmithDate: 2007-12-31 02:18:19
Subject: Re: Restoring pg_dump Backup with psql Fails
Previous:From: Phillip SmithDate: 2007-12-31 01:40:12
Subject: Re: Restoring pg_dump Backup with psql Fails

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group