Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 425989FB235 for ; Tue, 13 Mar 2007 17:42:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 85077-04 for ; Tue, 13 Mar 2007 17:42:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mi1.bluebottle.com (mi1.bluebottle.com [206.188.25.14]) by postgresql.org (Postfix) with ESMTP id A1FDE9FB253 for ; Tue, 13 Mar 2007 17:42:47 -0300 (ADT) Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by mi1.bluebottle.com (8.13.1/8.13.1) with ESMTP id l2DKgkmt003286 for ; Tue, 13 Mar 2007 13:42:46 -0700 DomainKey-Signature: a=rsa-sha1; s=mail; d=bluebottle.com; c=simple; q=dns; h=received:date:from:user-agent:mime-version:to:cc:subject: references:in-reply-to:x-enigmail-version:content-type:content-transfer-encoding; b=R9gPDaBgQI/vkh2fSCHjcx+YIODnb5abUR9a4hNgVBNbIa+hDRUrdGNpTUodM+Ip+ nx4sudxkn09FfexktyS0anGps3gAPFhTWrvJwRLw8RBe8Rt5Fy4Smu8zHEcaN/N Message-Id: <200703132042.l2DKgkmt003286@mi1.bluebottle.com> Received: from [10.0.0.4] (bas3-kitchener06-1096623463.dsl.bell.ca [65.93.37.103]) (authenticated bits=0) by fe1.bluebottle.com (8.13.1/8.13.1) with ESMTP id l2DKgiJ2032065 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 13 Mar 2007 13:42:45 -0700 Date: Tue, 13 Mar 2007 16:43:15 -0400 From: Greg Toombs User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: "Ezequias R. da Rocha" CC: pgsql-sql@postgresql.org Subject: Re: Maintence DB References: <45F705F9.1000205@fastcon.com.br> In-Reply-To: <45F705F9.1000205@fastcon.com.br> X-Enigmail-Version: 0.94.2.0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88.4, clamav-milter version 0.88.4 on localhost X-Virus-Status: Clean X-Trusted-Delivery: <7f6096a0643422468e7460d99af1dc38> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/178 X-Sequence-Number: 27816

(From the pgadmin documentation)

"The maintenance DB field is used to specify the initial database that pgAdmin connects to, and that will be expected to have the pgAgent schema and adminpack objects installed (both optional). On PostgreSQL 8.1 and above, the maintenance DB is normally called 'postgres', and on earlier versions 'template1' is often used, though it is preferrable to create a 'postgres' database for this purpose to avoid cluttering the template database."

Ezequias R. da Rocha wrote:

Hi list,

Could someone tell me in a simple way what does Maintence DB means ?

Regards

Ezequias