| Lists: | pgsql-jdbc |
|---|
| From: | Aydın Toprak <aydin(dot)toprak(at)intengo(dot)com> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | What is the exact Deal with Maintenance DB ? |
| Date: | 2005-12-01 17:20:07 |
| Message-ID: | 438F30C7.7000600@intengo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
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...
| 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: | 1133458436.4779.92.camel@coppola.muc.ecircle.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
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
| From: | Jaime Casanova <systemguards(at)gmail(dot)com> |
|---|---|
| To: | Aydın Toprak <aydin(dot)toprak(at)intengo(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: What is the exact Deal with Maintenance DB ? |
| Date: | 2005-12-01 17:49:51 |
| Message-ID: | c2d9e70e0512010949k42c68d30kab2cac74b801d54b@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
On 12/1/05, Aydın Toprak <aydin(dot)toprak(at)intengo(dot)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 ;)