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 606179DC801 for ; Sat, 21 Jan 2006 12:50:59 -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 00933-08 for ; Sat, 21 Jan 2006 12:50:58 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.202]) by postgresql.org (Postfix) with ESMTP id 3FD9C9DC824 for ; Sat, 21 Jan 2006 12:50:57 -0400 (AST) Received: by wproxy.gmail.com with SMTP id 57so667876wri for ; Sat, 21 Jan 2006 08:50:55 -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:content-transfer-encoding:content-disposition:references; b=qvHLpMAJzW0XTzQ/YWL6bZEPtI9u7uQ+QXf9Pix7qgmjQRakhAOe1V82RZMFeD8z3Y3NpBSaGXOgi6Y02To2U69PqnNsfm8YDQytJBQDBAaUNanjchgmLAOruWbfplCXUuzWNomHVHRWCSv78XmBbq6t8ThdPjfYolqgtDGv8to= Received: by 10.54.114.2 with SMTP id m2mr3868690wrc; Sat, 21 Jan 2006 08:50:55 -0800 (PST) Received: by 10.54.93.8 with HTTP; Sat, 21 Jan 2006 08:50:55 -0800 (PST) Message-ID: Date: Sat, 21 Jan 2006 11:50:55 -0500 From: Jaime Casanova To: alfred.lau@formotionsystems.com Subject: Re: Transferring DATA directory Cc: pgsql-admin@postgresql.org In-Reply-To: <43CD1403.4010806@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <43CD1403.4010806@gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.086 required=5 tests=[AWL=0.086] X-Spam-Score: 0.086 X-Spam-Level: X-Archive-Number: 200601/253 X-Sequence-Number: 20341 On 1/17/06, Alfred wrote: > Hi, > > I'm trying to transfer large amounts of data between two PostgreSQL 8.1.2 > database Windows XP platforms using the physical filesystem backup method= . I > used the same PostgreSQL installer on both machines and the same PostgreS= QL > configuration. I also used default options with PostGIS options. I did th= e > following: > > 1. shut down the database on each of machine A and machine B, > 2. zipped up the \DATA directory on machine A and unzipped= it > onto machine B. > 3. when I started up PostgreSQL on machine B with machine A's data > directory, the following message is returned: > > "The PostgreSQL Database Server 8.1 service could not be started. > > The service did not report an error. > > More help is available by typing NET HELPMSG 3534" > > I'm trying not to transfer data using pg_dump as it's quite a lot of data > and highly time consuming. Does anyone know if this is possible. I've > verified that there is no .pid file in the DATA directory. Are there othe= r > files I am missing? Anything else I might try? > > Thanks, > > Alfred Lau > i have already done that... - just install the server in machine B and run postgresql on machine B (this is important to be sure everything is correctly installed) - stop both servers (the one in machine A and in machine B) - Copy the data directory from machine A and paste it in machine B (previously you must be deleted the machines B's data directory or at least its contents) - start service in machine B -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)