Re: PostgreSQL Database Transfer between machines(again)

From: "Brian J(dot) Erickson" <ericksbr(at)infocon-inc(dot)com>
To: "PostgreSQL Mailing lists" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL Database Transfer between machines(again)
Date: 2006-10-13 16:39:35
Message-ID: 017601c6eee6$2b647350$4700a8c0@p000014
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


The machine did boot and PostgreSQL started backup, etc.

Thanks.

----- Original Message -----
From: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
To: "Brian J. Erickson" <ericksbr(at)infocon-inc(dot)com>
Cc: "PostgreSQL Mailing lists" <pgsql-general(at)postgresql(dot)org>
Sent: Friday, October 06, 2006 9:17 AM
Subject: Re: [GENERAL] 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/
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2006-10-13 16:42:02 Query
Previous Message Roman Neuhauser 2006-10-13 16:30:39 Re: more anti-postgresql FUD