From ezequias@fastcon.com.br Tue Mar 13 20:16:06 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4D5F49FB636 for ; Tue, 13 Mar 2007 17:16:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 78782-07 for ; Tue, 13 Mar 2007 17:16:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from correio2.docasdoporto.com.br (8.144.199.200.docasdoporto.com.br [200.199.144.8]) by postgresql.org (Postfix) with ESMTP id 3A0C69FB1CB for ; Tue, 13 Mar 2007 17:16:01 -0300 (ADT) Received: from [201.30.172.2] (account ezequias@fastcon.com.br HELO [192.168.0.110]) by correio2.docasdoporto.com.br (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 46397987 for pgsql-sql@postgresql.org; Tue, 13 Mar 2007 17:33:10 -0300 Message-ID: <45F705F9.1000205@fastcon.com.br> Date: Tue, 13 Mar 2007 17:13:45 -0300 From: "Ezequias R. da Rocha" User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Maintence DB Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/177 X-Sequence-Number: 27815 Hi list, Could someone tell me in a simple way what does Maintence DB means ? Regards Ezequias From greg.toombs@bluebottle.com Tue Mar 13 20:42:51 2007 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

From jonah.harris@gmail.com Wed Mar 14 01:45:06 2007 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A616D9FA6A2 for ; Tue, 13 Mar 2007 22:45:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 16960-08 for ; Tue, 13 Mar 2007 22:44:57 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.172]) by postgresql.org (Postfix) with ESMTP id 58FA69FA2F4 for ; Tue, 13 Mar 2007 22:44:57 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id k3so389547ugf for ; Tue, 13 Mar 2007 18:44:55 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=d/+j8ch9hl1GHRdN9D3CjzlzbNvqwtXxUx24+2uer9xXJCu9NVnzOBx3KUmoV8uTLoeWrhI6TQy1Wpa6Qg575oPhw/x6QI09FrWbSBuitLKGtvUXQq6x0tjJ2PWwEKb9Dgg/S+SW1F/5ALIoKMEuv/lgCk10hfKVQL5rtEF7j8A= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=lZDYBqY60ipUFfR58U5ASffOHRUIUe35zbi2jpsQx5+/UtpWTD9/SDjh03gCv5bGC9y5I1wyn0E9U6grjVzLplkM+4lliGlToym9g/iUEkdLfCJ/byRK/0otSK7mnxp492RjzjzvYxerCvXjP/sTizhhpk0Wr1pWf5I1GmIXmBo= Received: by 10.115.76.1 with SMTP id d1mr2682085wal.1173836694702; Tue, 13 Mar 2007 18:44:54 -0700 (PDT) Received: by 10.114.181.14 with HTTP; Tue, 13 Mar 2007 18:44:54 -0700 (PDT) Message-ID: <36e682920703131844w3354ef26p244ed68b746b10ce@mail.gmail.com> Date: Tue, 13 Mar 2007 21:44:54 -0400 From: "Jonah H. Harris" To: "Ezequias R. da Rocha" Subject: Re: Maintence DB Cc: pgsql-sql@postgresql.org In-Reply-To: <45F705F9.1000205@fastcon.com.br> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <45F705F9.1000205@fastcon.com.br> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/189 X-Sequence-Number: 27827 On 3/13/07, Ezequias R. da Rocha wrote: > Could someone tell me in a simple way what does Maintence DB means ? Ezequias, Not trying to be a PITA here, because I'm more than happy to help. But it seems like you ask a lot of questions that could easily be answered if you read the manual. As a suggestion, before asking a question next time, please try and find the answer in the manual first... it will save you a flame or two from some people on this list :) -- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 33 Wood Ave S, 3rd Floor | jharris@enterprisedb.com Iselin, New Jersey 08830 | http://www.enterprisedb.com/