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

Re: What is the exact Deal with Maintenance DB ?

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Aydın Toprak <aydin(dot)toprak(at)intengo(dot)com>
Cc: Postgres JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: What is the exact Deal with Maintenance DB ?
Date: 2005-12-01 17:33:56
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
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.


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

In response to

pgsql-jdbc by date

Next:From: Jaime CasanovaDate: 2005-12-01 17:49:51
Subject: Re: What is the exact Deal with Maintenance DB ?
Previous:From: Aydın ToprakDate: 2005-12-01 17:20:07
Subject: What is the exact Deal with Maintenance DB ?

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