From alfred.lau@gmail.com Tue Jan 17 15:57:52 2006 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 D767D9DC989 for ; Tue, 17 Jan 2006 11:57:52 -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 89836-05 for ; Tue, 17 Jan 2006 11:57:56 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.206]) by postgresql.org (Postfix) with ESMTP id 3482F9DC981 for ; Tue, 17 Jan 2006 11:57:49 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 14so1379106nzn for ; Tue, 17 Jan 2006 07:57:55 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:user-agent:mime-version:to:subject:content-type; b=ehSKdX0LkGy9+3xxFhwj772PF6nC30CfTomOJZbEVpYCK5a+ScuiKzoVkjQXGIFltYaai/GL/bOnmaZS1DCVTtN4/55oaCP9q8Ez+rSGtrFtVhpU4la+bLHQBc1V3R5GlavXggZnkrKY5KFt72EoBYOr2sKHveyfLQ7eKNh0MZ4= Received: by 10.65.112.3 with SMTP id p3mr1461863qbm; Tue, 17 Jan 2006 07:57:54 -0800 (PST) Received: from ?192.168.1.2? ( [70.48.153.234]) by mx.gmail.com with ESMTP id f18sm2941358qba.2006.01.17.07.57.54; Tue, 17 Jan 2006 07:57:54 -0800 (PST) Message-ID: <43CD1403.4010806@gmail.com> Date: Tue, 17 Jan 2006 10:57:55 -0500 From: Alfred Reply-To: alfred.lau@formotionsystems.com User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Transferring DATA directory Content-Type: multipart/alternative; boundary="------------040407030801050203020206" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200601/222 X-Sequence-Number: 20310 This is a multi-part message in MIME format. --------------040407030801050203020206 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 --------------040407030801050203020206 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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 <postgre-home>\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
--------------040407030801050203020206-- From alfred.lau@formotionsystems.com Wed Jan 18 17:03:07 2006 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 23ECD9DC9AC for ; Wed, 18 Jan 2006 13:03:07 -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 81492-08 for ; Wed, 18 Jan 2006 13:03:05 -0400 (AST) X-Greylist: delayed 00:15:53.223279 by SQLgrey- Received: from ex02.blacksun.ca (ex02.blacksun.ca [69.27.98.2]) by postgresql.org (Postfix) with ESMTP id 6E71B9DC87F for ; Wed, 18 Jan 2006 13:03:02 -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 k0IGl4c12122 for ; Wed, 18 Jan 2006 10:47:04 -0600 From: "Alfred Lau - FORMotion Systems" To: pgsql-admin@postgresql.org Reply-To: alfred.lau@formotionsystems.com Subject: Transferring DATA directory Date: Wed, 18 Jan 2006 11:47:04 -0500 Message-Id: <20060118164515.M1335@formotionsystems.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 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200601/189 X-Sequence-Number: 20277 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 From jason.minion@sigler.com Wed Jan 18 17:27:44 2006 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 DF9319DC833 for ; Wed, 18 Jan 2006 13:27:44 -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 87927-02 for ; Wed, 18 Jan 2006 13:27:41 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 7E44A9DC9AC for ; Wed, 18 Jan 2006 13:27:40 -0400 (AST) Received: from exchange.siglercompanies.com (sig-gw.isunet.net [63.175.165.221]) by svr4.postgresql.org (Postfix) with ESMTP id EF9195AF18C for ; Wed, 18 Jan 2006 17:27:39 +0000 (GMT) X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Re: Transferring DATA directory Date: Wed, 18 Jan 2006 11:26:26 -0600 Message-ID: <0105A1BF505D304E9E5AF38B63E40E4ED7EBEC@EXCHANGE.siglercompanies.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] Transferring DATA directory thread-index: AcYcUQpdhvk4nNEUSO2idbGOGVsmbgAAqlZA From: "Jason Minion" To: , X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.478 required=5 tests=[AWL=0.478] X-Spam-Score: 0.478 X-Spam-Level: X-Archive-Number: 200601/191 X-Sequence-Number: 20279 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 \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 From alfred.lau@formotionsystems.com Fri Jan 20 14:47:15 2006 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 From systemguards@gmail.com Sat Jan 21 16:50:59 2006 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 ;)