Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 40B362E0059 for ; Tue, 6 May 2008 00:22:16 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 51103-04-2 for ; Tue, 6 May 2008 00:22:03 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by developer.postgresql.org (Postfix) with ESMTP id 810462E0048 for ; Tue, 6 May 2008 00:20:59 -0300 (ADT) Received: from [192.168.1.226] (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m463LjQK020976 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Mon, 5 May 2008 20:21:46 -0700 Message-ID: <481FCE92.7090309@commandprompt.com> Date: Mon, 05 May 2008 20:20:50 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: Patrick Roberts CC: pgsql-admin@postgresql.org Subject: Re: restore postgres system database 8.1.11 References: <4544e0330804282205odfcac5al6bca78bd27c8751b@mail.gmail.com> <25410.1209448864@sss.pgh.pa.us> <481AD7F1.3030708@fastmail.net> <317D66738A25D74A88E3E9B7C1814A3603978A0F@Garuda.lpint.net> In-Reply-To: <317D66738A25D74A88E3E9B7C1814A3603978A0F@Garuda.lpint.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Mon, 05 May 2008 20:21:46 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/35 X-Sequence-Number: 29119 Patrick Roberts wrote: > Hi All, > > On a newly created server I stupidly restored over the top of the > postgres system database using the GUI...(postgresql n00b) and am > wondering a couple of things. > > Firstly, if this database is overwritten, is it detrimental to the > running of PostgreSQL? The "postgres" database is basically an empty holder so that when you do this: psql as the user postgres, you actually get into the system. > > Secondly is it just a simple matter of restoring it using a backup > from a different PostgreSQL instance installed elsewhere. If you are indeed speaking about the "postgres" database yes. Sincerely, Joshua D. Drake