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