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 868489DC9D1 for ; Sun, 29 Jan 2006 23:31:29 -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 74107-04 for ; Sun, 29 Jan 2006 23:31:32 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from oss4u.com (oss4u.com [64.142.76.151]) by postgresql.org (Postfix) with SMTP id 8D4CD9DC9FF for ; Sun, 29 Jan 2006 23:31:25 -0400 (AST) Received: (qmail 22992 invoked from network); 30 Jan 2006 03:32:45 -0000 Received: from tiburon.oss4u.com (192.168.1.4) by gw.oss4u.com (192.168.1.1) with ESMTP; 30 Jan 2006 03:32:45 -0000 From: "Uwe C. Schroeder" To: pgsql-admin@postgresql.org Subject: Re: Copy database Date: Sun, 29 Jan 2006 19:31:29 -0800 User-Agent: KMail/1.7.1 Cc: "Krzysztof Szadkowski" , pgsql-admin-owner@postgresql.org References: <000001c61ff9$f6eb2080$1401a8c0@eldipsrv> In-Reply-To: <000001c61ff9$f6eb2080$1401a8c0@eldipsrv> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200601291931.29829.uwe@oss4u.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.103 required=5 tests=[AWL=0.103] X-Spam-Score: 0.103 X-Spam-Level: X-Archive-Number: 200601/316 X-Sequence-Number: 20404 pg_dump -h sourcehost -U sourceuser sourcedatabase | psql -h desthost -U destuser destdatabase you may have to add a parameter for the password depending on your pg_hba.conf settings. Both databases need to be network enabled and have a pg_hba.conf entry for the machine you're running this command on. 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 ? > > --------------------------------------------- > Best regards, > Krzysztof Szadkowski > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match -- UC -- Open Source Solutions 4U, LLC 1618 Kelly St Phone: +1 707 568 3056 Santa Rosa, CA 95401 Cell: +1 650 302 2405 United States Fax: +1 707 568 6416