Roy Cabaniss <[EMAIL PROTECTED]> writes:
> southern=# DROP DATABASE template1;
> ERROR: DROP DATABASE: database is marked as a template
Sorry about that; but perhaps you should have read the whole section I
pointed you to. The procedure that would actually work would be
something like (as super
half Of Roy Cabaniss
> Sent: Thursday, February 14, 2002 3:44 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [ADMIN] restoring template1
>
>
> On Wednesday 13 February 2002 16:03, Tom Lane wrote:
> > Roy Cabaniss <[EMAIL PROTECTED]> writes:
> > > So how can I get the
On Wednesday 13 February 2002 16:03, Tom Lane wrote:
> Roy Cabaniss <[EMAIL PROTECTED]> writes:
> > So how can I get the original template1 back from template0
Just to help others who find themself in a similar situation to me.
To recap. I accidently overwrote my template1 when doing a restore
Roy Cabaniss <[EMAIL PROTECTED]> writes:
> So how can I get the original template1 back from template0
DROP DATABASE; CREATE DATABASE. Note the comments in
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/managing-databases.html#MANAGE-AG-TEMPLATEDBS
regards,
I inadvertantly wrote over the template1 file when I restored my data from a
pgdump.
So how can I get the original template1 back from template0 now that they
name the files with numbers. It's gotta be something simple but I can't find
it in the manual.
--
Dr. Roy F. Cabaniss
Associate
