From: Jaime Casanova <systemguards@gmail.com>
To: alfred.lau@formotionsystems.com
Cc: pgsql-admin@postgresql.org
Subject: Re: Transferring DATA directory
Date: Sat, 21 Jan 2006 11:50:55 -0500
Message-ID: <c2d9e70e0601210850q7cb65f17o82a4575739f169cb@mail.gmail.com> (raw)
In-Reply-To: <43CD1403.4010806@gmail.com>
References: <43CD1403.4010806@gmail.com>
On 1/17/06, Alfred <alfred.lau@gmail.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 ;)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: systemguards@gmail.com, alfred.lau@formotionsystems.com
Subject: Re: Transferring DATA directory
In-Reply-To: <c2d9e70e0601210850q7cb65f17o82a4575739f169cb@mail.gmail.com>
References: <43CD1403.4010806@gmail.com> <c2d9e70e0601210850q7cb65f17o82a4575739f169cb@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox