| From: | Richard Broersma <richard(dot)broersma(at)gmail(dot)com> |
|---|---|
| To: | dgcatanzaro(at)gmail(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Moving postgresql data to another computer |
| Date: | 2010-05-11 21:00:33 |
| Message-ID: | AANLkTikNnaRj55z81aSAR75lJOQaZtOnVRqxomFHxKum@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, May 11, 2010 at 1:52 PM, Donald Catanzaro, PhD
<dgcatanzaro(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christoph Zwerschke | 2010-05-11 21:04:00 | Re: Finding rows with text columns beginning with other text columns |
| Previous Message | Donald Catanzaro, PhD | 2010-05-11 20:52:49 | Re: Moving postgresql data to another computer |