Re: PostgreSQL Database Transfer between machines(again)

AgentM wrote:
>
> 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.
>>

O.k. hold on... are you getting any errors in /var/log/messages?

Joshua D. Drake

>> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/