X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id AEE9F9DCA0B for ; Mon, 30 Jan 2006 04:04:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 29089-05 for ; Mon, 30 Jan 2006 04:04:52 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from uproxy.gmail.com (uproxy.gmail.com [66.249.92.203]) by postgresql.org (Postfix) with ESMTP id 300DF9DC850 for ; Mon, 30 Jan 2006 04:04:48 -0400 (AST) Received: by uproxy.gmail.com with SMTP id h2so362270ugf for ; Mon, 30 Jan 2006 00:04:49 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=BeuALhIRGEGStnArj23JQo9ooxzewmahgM4Q5qQC1plq/Iq/f23oBlozmrwrO1lmWyll33GjPCE3Eub9/UjvG5EaD+lUN+hmqmM49iIpLbxhbCG0uxiz0OUsO95F5BWa2lIy266ARscB2JIIZzriA25cJRjGIH7YaekLeECzVpQ= Received: by 10.48.254.9 with SMTP id b9mr651962nfi; Mon, 30 Jan 2006 00:04:49 -0800 (PST) Received: by 10.48.255.12 with HTTP; Mon, 30 Jan 2006 00:04:49 -0800 (PST) Message-ID: Date: Mon, 30 Jan 2006 09:04:49 +0100 From: Christian Sengstock To: "Uwe C. Schroeder" Subject: Re: Copy database Cc: pgsql-admin@postgresql.org, Krzysztof Szadkowski , pgsql-admin-owner@postgresql.org In-Reply-To: <200601291931.29829.uwe@oss4u.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1923_30205929.1138608289627" References: <000001c61ff9$f6eb2080$1401a8c0@eldipsrv> <200601291931.29829.uwe@oss4u.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=2.603 required=5 tests=[AWL=-0.159, DOMAIN_4U2=1.429, HTML_MESSAGE=0.001, RCVD_IN_BL_SPAMCOP_NET=1.332] X-Spam-Score: 2.603 X-Spam-Level: ** X-Archive-Number: 200601/317 X-Sequence-Number: 20405 ------=_Part_1923_30205929.1138608289627 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 2006/1/30, Uwe C. Schroeder : > > > > On Monday 23 January 2006 00:49, Krzysztof Szadkowski wrote: > > Hi all, > > > > I am looking for a way to copy whole database to another existing > > database. > > Any suggestions ? Sometimes you want to copy the whole DBMS to another machine where the same postgres version is running. You can just copy the ./data directory, check the permissions (chown -R postgres ./data) and run postmaster with this dat= a directory (postmaster ... -d ./data). Note: Like that, you can't copy a certain database. You have to use the sam= e postgres version for that... Chris ------=_Part_1923_30205929.1138608289627 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

2006/1/30, Uwe C. Schroeder <uwe@oss4u.com>:



On Monday 23 January= 2006 00:49, Krzysztof Szadkowski wrote:
> Hi all,
>
> I = am looking for a way to copy whole database to another existing
> database.
> Any suggestions ?
 
Sometimes you want to copy the whole DBMS to another machine wher= e the same postgres version is running. You can just copy the ./data direct= ory, check the permissions (chown -R postgres ./data) and run postmaster wi= th this data directory (postmaster ... -d ./data).
 
Note: Like that, you can't copy a certain database. You have to use th= e same postgres version for that...
 
Chris


 
------=_Part_1923_30205929.1138608289627--