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

From Brian J. Erickson
Subject Re: PostgreSQL Database Transfer between machines(again)
Date
Msg-id 017601c6eee6$2b647350$4700a8c0@p000014
Whole thread Raw
In response to Storing images in PostgreSQL databases (again)  (TIJod <tijod@yahoo.fr>)
List pgsql-general
The machine did boot and PostgreSQL started backup, etc.

Thanks.

----- Original Message -----
From: "Joshua D. Drake" <jd@commandprompt.com>
To: "Brian J. Erickson" <ericksbr@infocon-inc.com>
Cc: "PostgreSQL Mailing lists" <pgsql-general@postgresql.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@commandprompt.com>
> > To: "AgentM" <agentm@themactionfaction.com>
> > Cc: "PostgreSQL Mailing lists" <pgsql-general@postgresql.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
>


pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: exploiting features of pg to obtain polymorphism
Next
From: Bob Pawley
Date:
Subject: Query