Обсуждение: Reloading Template1
Hello,
I've accidently created a whole bunch of tables and sequences in template1.
I didn't actually want the information in template1 but with the slip of a key my script piped all the commands into it and now all the info is there, doh!.
Problem is now that I try to create the DB I want, all the view and structures are already there.
How to I recreate an empty template1?
Thanks
I've accidently created a whole bunch of tables and sequences in template1.
I didn't actually want the information in template1 but with the slip of a key my script piped all the commands into it and now all the info is there, doh!.
Problem is now that I try to create the DB I want, all the view and structures are already there.
How to I recreate an empty template1?
Thanks
--
|
Dear Hadley Willan ,
Read This
http://techdocs.postgresql.org/redir.php?link=/techdocs/pgsqladventuresep1.php
Read This
http://techdocs.postgresql.org/redir.php?link=/techdocs/pgsqladventuresep1.php
-- Regards, Vishal Kashyap ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~* I Know you believe my words so logon to Jabber.org and add vishalkashyap@jabber.org to your roster. OR Seek Me at 264360076 ~*~*~*~*~*~*~*~* I am usually called as Vishal Kashyap but my Girlfriend calls me as Vishal CASH UP. This is because others identify me because of my generosity but my Girlfriend identify me because of my CASH. ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Dear Hadley Willan ,
Read This
http://techdocs.postgresql.org/redir.php?link=/techdocs/pgsqladventuresep1.php
Read This
http://techdocs.postgresql.org/redir.php?link=/techdocs/pgsqladventuresep1.php
-- Regards, Vishal Kashyap ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~* I Know you believe my words so logon to Jabber.org and add vishalkashyap@jabber.org to your roster. OR Seek Me at 264360076 ~*~*~*~*~*~*~*~* I am usually called as Vishal Kashyap but my Girlfriend calls me as Vishal CASH UP. This is because others identify me because of my generosity but my Girlfriend identify me because of my CASH. ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
On Tuesday 27 January 2004 08:13, Hadley Willan wrote: > Hello, > I've accidently created a whole bunch of tables and sequences in > template1. > > I didn't actually want the information in template1 but with the slip of > a key my script piped all the commands into it and now all the info is > there, doh!. We all have doh! moments, you are not the first to be here. > How to I recreate an empty template1? Two options: 1. Manually undo all the changes (no, didn't think you liked that one) 2. Drop template1 and recreate it using template0 The createdb command has a flag to let you base your new database on something other than template1. Actually, IIRC this is exactly why we have template0 - for those occasions where you want to regenerate template1. -- Richard Huxton Archonet Ltd
Richard Huxton <dev@archonet.com> writes: > Actually, IIRC this is exactly why we have template0 - > for those occasions where you want to regenerate template1. Well, that's one of its uses. IIRC there is a page on techdocs.postgresql.org that will walk you through this procedure. There are a couple of safety interlocks you need to defeat temporarily, so it's a bit more than a DROP and a CREATE. regards, tom lane
Thanks everybody for your help.
It was a pretty simple procedure at the end of the day and I've learned a valuable lesson, remember which DB its all going to!
Thanks again.
Hadley
On Wed, 2004-01-28 at 10:13, Hadley Willan wrote:
It was a pretty simple procedure at the end of the day and I've learned a valuable lesson, remember which DB its all going to!
Thanks again.
Hadley
On Wed, 2004-01-28 at 10:13, Hadley Willan wrote:
Hello,
I've accidently created a whole bunch of tables and sequences in template1.
I didn't actually want the information in template1 but with the slip of a key my script piped all the commands into it and now all the info is there, doh!.
Problem is now that I try to create the DB I want, all the view and structures are already there.
How to I recreate an empty template1?
Thanks