X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 12C7F52867 for ; Tue, 28 Jun 2005 02:03:47 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 18488-04 for ; Tue, 28 Jun 2005 05:03:43 +0000 (GMT) Received: from mail.jobflash.com (mail.jobflash.com [64.62.211.41]) by svr1.postgresql.org (Postfix) with ESMTP id A02BA52835 for ; Tue, 28 Jun 2005 02:03:42 -0300 (ADT) Received: from [192.168.2.22] (user-2ivfj4o.dialup.mindspring.com [165.247.204.152]) by mail.jobflash.com (Postfix) with ESMTP id DE881420C5; Mon, 27 Jun 2005 22:03:41 -0700 (PDT) Message-ID: <42C0DA28.30201@jobflash.com> Date: Mon, 27 Jun 2005 22:03:36 -0700 From: Tom Arthurs User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Paul Keyes Cc: pgsql-admin@postgresql.org Subject: Re: moving database to diff. server References: <20050622200224.67912.qmail@web33413.mail.mud.yahoo.com> In-Reply-To: <20050622200224.67912.qmail@web33413.mail.mud.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/250 X-Sequence-Number: 18005 use initdb to create the cluster (including the template db's), if you haven't already done so. Paul Keyes wrote: > Hi All, > > I'm confused about one aspect of backing up and moving > a database to a different server. > I've used pg_dump to dump the database and moved he > resulting file to the new server, where Postgresql is > istalled and configured (as far as I know). > But I know that before I run psql on the backup I have > to create the database with something like (createdb > -T template0 dbname). How do I make that template0? > I assume I've got to make it from the old > server/existing database but am unclear about how. > Any advice is greatly appreciated. > Thanks, > Paul > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > > >