Re: PostgreSQL Database Transfer between machines(again)

Brian J. Erickson wrote:
>>> 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.
> That is basically the plan but I want to make sure that I have all of the
> data.
>
>> O.k. hold on... are you getting any errors in /var/log/messages?
> Here is some of the "/var/log/messages" file

That's odd. Have you tried removing /etc/mtab manually and rebooting?
does the problem still occur? As far as PostgreSQL... you need to look
in to postgresql logs.

Did you compile from source? What version of Linux is this?

Joshua D. Drake

> -------------------------------------------Begin----------------------------
> ----------------------
> Oct 6 07:57:27 Info1A kernel: PCI: Using configuration type 1
> Oct 6 07:57:27 Info1A kernel: PCI: Probing PCI hardware
> Oct 6 07:57:27 Info1A mount: mount: can't open /etc/mtab for writing:
> Input/output error
> Oct 6 07:57:27 Info1A kernel: PCI: Probing PCI hardware (bus 00)
> Oct 6 07:57:27 Info1A netfs: Mounting other filesystems: failed
> .
> .
> .
> Oct 6 07:57:33 Info1A su(pam_unix)[1229]: session opened for user postgres
> by (uid=0)
> Oct 6 07:57:33 Info1A su(pam_unix)[1229]: session closed for user postgres
> Oct 6 07:57:34 Info1A postgresql: Starting postgresql service: failed
> ---------------------------------------------End----------------------------
> ---------------------
>
>
>
> ----- Original Message -----
> From: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
> To: "AgentM" <agentm(at)themactionfaction(dot)com>
> Cc: "PostgreSQL Mailing lists" <pgsql-general(at)postgresql(dot)org>
> Sent: Thursday, October 05, 2006 5:42 PM
> Subject: Re: [GENERAL] 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/
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 3: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/docs/faq
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

--

=== 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/