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 007901c6e962$7abecfb0$4700a8c0@p000014
Whole thread Raw
In response to Storing images in PostgreSQL databases (again)  (TIJod <tijod@yahoo.fr>)
Responses Re: PostgreSQL Database Transfer between machines(again)
List pgsql-general
> > 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@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
>


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: server closed the connection unexpectedly
Next
From: Tom Lane
Date:
Subject: Re: Europe/Moscow timezone