Re: PostgreSQL Database Transfer between machines(again) - Mailing list pgsql-general

From AgentM
Subject Re: PostgreSQL Database Transfer between machines(again)
Date
Msg-id 142EECAF-870D-42CF-88FE-5879FDB6AC6B@themactionfaction.com
Whole thread Raw
In response to Re: PostgreSQL Database Transfer between machines(again)  ("Brian J. Erickson" <ericksbr@infocon-inc.com>)
Responses Re: PostgreSQL Database Transfer between machines(again)  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
On Oct 5, 2006, at 19:10 , Brian J. Erickson wrote:

>> And since it's a text file, can't someone fix it with $EDITOR?
>
> I tried to edit the file, but I get the Input/Output error.
>
> The recommendatation was to re-install the OS.
> However, I DO NOT want to lose my database,
> so I am tring to backup the database.

You can boot from any rescue CD, mount the partition, copy the
database directory away and then copy it back once you have
reinstalled. This is safe because it is on the same machine. It is
not safe to copy the database to some arbitrary computer and expect
it to run. Make sure to match the database version. Good luck!

-M

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: PostgreSQL Database Transfer between machines(again)
Next
From: Jean-Christophe Roux
Date:
Subject: Re: Storing images in PostgreSQL databases (again)