Re: Transferring DATA directory

On 1/17/06, Alfred <alfred(dot)lau(at)gmail(dot)com> 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 ;)