|
Home > Archive > PostgreSQL JDBC > December 2005 > What is the exact Deal with Maintenance DB ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
What is the exact Deal with Maintenance DB ?
|
|
| Aydın Toprak 2005-12-01, 1:23 pm |
| 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
| |
| Csaba Nagy 2005-12-01, 1:23 pm |
| 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
| |
| Jaime Casanova 2005-12-01, 1:23 pm |
| 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/pgsq...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 ;)
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly
|
|
|
|
|