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

Re: What is the exact Deal with Maintenance DB ?

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 (view raw or flat)
Thread:
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 ;)

In response to

pgsql-jdbc by date

Next:From: Kevin GrittnerDate: 2005-12-01 22:05:01
Subject: .cvsignore patch
Previous:From: Csaba NagyDate: 2005-12-01 17:33:56
Subject: Re: What is the exact Deal with Maintenance DB ?

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