Re: Transferring DATA directory

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 ;)


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux