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 B821D9DC9FF for ; Fri, 20 Jan 2006 10:47:15 -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 81939-09 for ; Fri, 20 Jan 2006 10:47:19 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ex02.blacksun.ca (ex02.blacksun.ca [69.27.98.2]) by postgresql.org (Postfix) with ESMTP id 34FE39DC889 for ; Fri, 20 Jan 2006 10:47:12 -0400 (AST) Received: from www.formotionsystems.com (localhost [127.0.0.1]) by ex02.blacksun.ca (8.11.6/8.11.6) with ESMTP id k0KElCS13226; Fri, 20 Jan 2006 08:47:13 -0600 From: "Alfred Lau - FORMotion Systems" To: "Jason Minion" , Reply-To: alfred.lau@formotionsystems.com Subject: Re: Transferring DATA directory Date: Fri, 20 Jan 2006 09:47:12 -0500 Message-Id: <20060120144624.M57451@formotionsystems.com> In-Reply-To: <0105A1BF505D304E9E5AF38B63E40E4ED7EBEC@EXCHANGE.siglercompanies.com> References: <0105A1BF505D304E9E5AF38B63E40E4ED7EBEC@EXCHANGE.siglercompanies.com> X-Mailer: Open WebMail 2.32 20040709 X-OriginatingIP: 70.48.153.234 (alau) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-yoursite-MailScanner-Information: Please contact the ISP for more information X-yoursite-MailScanner: Found to be clean X-MailScanner-From: alfred.lau@formotionsystems.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200601/237 X-Sequence-Number: 20325 Hi Jason, Permssions was the exact problem. After disabling the simple file sharing option in Folder Options (under Windows XP Professional), I was able to see the permissions of the DATA folder and change them appropriately. Gracias, Alfred. On Wed, 18 Jan 2006 11:26:26 -0600, Jason Minion wrote > Does the local postgresql user account on machine B have the correct > permissions for the files you copied over? Also make sure to try > starting postgresql from the command line using pg_ctl, and check > your service properties to get an idea of the command being used > there to attempt to start postgresql. Things like the "-D parameter will be *very* important. > > Jason Minion > > -----Original Message----- > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Alfred Lau - > FORMotion Systems > Sent: Wednesday, January 18, 2006 10:47 AM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] Transferring DATA directory > > 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 PostgreSQL configuration. I also used default options with PostGIS > options. I did the > 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 other files I am missing? Anything else I might try? > > Thanks, > > Alfred Lau > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings Alfred Lau Software Developer FORMotion Systems Inc. alfred.lau@formotionsystems.com