Received: from merganser.its.uu.se (merganser.its.uu.se [130.238.6.236]) by hub.org (8.10.1/8.10.1) with ESMTP id e5IEIgM16127 for ; Sun, 18 Jun 2000 10:18:42 -0400 (EDT) Received: from regulus.student.UU.SE ([130.238.5.2]:60563 "EHLO regulus.its.uu.se") by merganser.its.uu.se with ESMTP id ; Sun, 18 Jun 2000 16:18:14 +0200 Received: from peter (helo=localhost) by regulus.its.uu.se with local-esmtp (Exim 3.02 #2) id 133g0C-0000JZ-00; Sun, 18 Jun 2000 16:24:44 +0200 Date: Sun, 18 Jun 2000 16:24:43 +0200 (CEST) From: Peter Eisentraut To: Craig May cc: PGSQL-SQL Subject: Re: Database Transfer In-Reply-To: <20000618090707.L21329@s2.enthdimension.com.au> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-1 Content-Transfer-Encoding: 8BIT X-Archive-Number: 200006/172 Craig May writes: > I have two servers running pgsql. Is there a command to transfer the > databases > between them? pg_dump and psql. "Back up" one database and "restore" it on the other server. Don't even think about moving files around. :) -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden