Re: What is the exact Deal with Maintenance DB ? - Mailing list pgsql-jdbc

From Jaime Casanova
Subject Re: What is the exact Deal with Maintenance DB ?
Date
Msg-id c2d9e70e0512010949k42c68d30kab2cac74b801d54b@mail.gmail.com
Whole thread Raw
In response to What is the exact Deal with Maintenance DB ?  (Aydın Toprak <aydin.toprak@intengo.com>)
List pgsql-jdbc
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 ;)

pgsql-jdbc by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: What is the exact Deal with Maintenance DB ?
Next
From: "Kevin Grittner"
Date:
Subject: .cvsignore patch