Thread: What is the exact Deal with Maintenance DB ?
Hiii, I trying to understand what is the exact usage of Matenance DB "postgres" ... ,I think It is a template like "template1" ... and If we want to generate a database we create new one from "postgres" template... However I cant do it, but I can create a new databse from template1 ... I really dont understand the functionality of "postgres" ... If I create a connection from template 1, and create another connection from the conneciton 1, It clones the DB on the first conneciton to the second ... If I drop the DB from one connection, then the second conneciton looses the DB as well ... in what circumtances, we may need two conneciton on the same Posqgresql server ?... sorry I am really confused about that...
This (JDBC) is the wrong list for this question (GENERAL would have been better), but basically: you can't create a new data base based on template1 if somebody else is also connected to it. You can only use template1 if you're the ONLY one connection to it. This will make you impossible to create new data bases if somebody connects to template1 and forgets to disconnect for ages... So the postgres data base is used to connect to, and template1 to be used as a template. You shouldn't connect anymore to template1, so it can be always used as a template without problems. HTH, Csaba. On Thu, 2005-12-01 at 18:20, Aydın Toprak wrote: > Hiii, > > I trying to understand what is the exact usage of Matenance DB > "postgres" ... > > ,I think It is a template like "template1" ... and If we want to > generate a database we create new one from "postgres" template... > > However I cant do it, but I can create a new databse from template1 ... > I really dont understand the functionality of "postgres" ... > > If I create a connection from template 1, and create another connection > from the conneciton 1, It clones the DB on the first conneciton to the > second ... > > If I drop the DB from one connection, then the second conneciton looses > the DB as well ... > > > in what circumtances, we may need two conneciton on the same Posqgresql > server ?... > > sorry I am really confused about that... > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster
On 12/1/05, Aydın Toprak <aydin.toprak@intengo.com> wrote: > Hiii, > > I trying to understand what is the exact usage of Matenance DB > "postgres" ... > > ,I think It is a template like "template1" ... and If we want to > generate a database we create new one from "postgres" template... > > However I cant do it, but I can create a new databse from template1 ... > I really dont understand the functionality of "postgres" ... > http://archives.postgresql.org/pgsql-hackers/2005-11/msg00904.php > If I create a connection from template 1, and create another connection > from the conneciton 1, It clones the DB on the first conneciton to the > second ... > > If I drop the DB from one connection, then the second conneciton looses > the DB as well ... > > > in what circumtances, we may need two conneciton on the same Posqgresql > server ?... > > sorry I am really confused about that... > > -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)