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 <path" > parameter will be *very* important. > > Jason Minion > > -----Original Message----- > From: pgsql-admin-owner@xxxxxxxxxxxxxx > [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Alfred Lau - > FORMotion Systems > Sent: Wednesday, January 18, 2006 10:47 AM > To: pgsql-admin@xxxxxxxxxxxxxx > 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 <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 > > ---------------------------(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@xxxxxxxxxxxxxxxxxxxx
