Postgres Pro
Downloads
Home   >   mailing lists

Re: Moving postgresql data to another computer - Mailing list pgsql-general

From Richard Broersma
Subject Re: Moving postgresql data to another computer
Date
Msg-id AANLkTikNnaRj55z81aSAR75lJOQaZtOnVRqxomFHxKum@mail.gmail.com
Whole thread Raw
In response to Re: Moving postgresql data to another computer  ("Donald Catanzaro, PhD" <dgcatanzaro@gmail.com>)
List pgsql-general
Tree view 
On Tue, May 11, 2010 at 1:52 PM, Donald Catanzaro, PhD
<dgcatanzaro@gmail.com> wrote:

> Well, needless to say I naively copied the data over.
> First off I did not stop the database server (thus violating
> http://www.postgresql.org/docs/8.4/interactive/backup-file.html) and I am
> not near my desktop.  Does that mean my copy is in essence useless and I
> have to start over ?

I did this once myself and because of a hard drive crash, there was no
other alternative for me.   However, I was helped to find a solution.

http://archives.postgresql.org/pgsql-general/2006-10/msg00387.php
http://www.postgresql.org/docs/8.4/interactive/app-pgresetxlog.html

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

pgsql-general by date:

Previous
From: "Donald Catanzaro, PhD"
Date:
Subject: Re: Moving postgresql data to another computer
Next
From: Christoph Zwerschke
Date:
Subject: Re: Finding rows with text columns beginning with other text columns