Re: Transferring DATA directory

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(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Alfred Lau -
> FORMotion Systems
> Sent: Wednesday, January 18, 2006 10:47 AM
> To: pgsql-admin(at)postgresql(dot)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 <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(dot)lau(at)formotionsystems(dot)com