Re: PostgreSQL Database Transfer between machines(again)

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