The machine did boot and PostgreSQL started backup, etc. Thanks. ----- Original Message ----- From: "Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx> To: "Brian J. Erickson" <ericksbr@xxxxxxxxxxxxxxx> Cc: "PostgreSQL Mailing lists" <pgsql-general@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxx> > > To: "AgentM" <agentm@xxxxxxxxxxxxxxxxxxxxx> > > Cc: "PostgreSQL Mailing lists" <pgsql-general@xxxxxxxxxxxxxx> > > 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 >
