On 1/17/06, Alfred <alfred.lau@xxxxxxxxx> 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 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 > 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 ;)
