<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=UTF-8" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#000000"> <blockquote cite="mid20060411220821.CA59973B63@hormel.redhat.com" type="cite"> <pre wrap="">On Tue, 2006-04-11 at 22:41 +0200, Marcel Janssen wrote: </pre> <blockquote type="cite"> <pre wrap="">On Tuesday 11 April 2006 22:07, Craig White wrote: </pre> <blockquote type="cite"> <pre wrap="">you do backup postgresql files using pg_dump right? </pre> </blockquote> <pre wrap="">You're absolutely right that I should have, but in this case I just started to use postgresql last week as a testcase (not production yet). I haven't set up backups for this yet. It's not a big disaster when I loose the data, but would be nice if I could save it. </pre> </blockquote> <pre wrap="">---- I did much the same thing - I think it was upgrade from FC-2 to FC-4 and Postgres 7.4.x to 8.0.x and I chalked it up to a learning curve but I did have a pg_dump to go back to, it did teach me a lesson though. I have a cron job that regularly dumps my postgresql db's now. Craig </pre> </blockquote> I read somewhere in documentation, that pg_dump and pg_dumpall both understand old format (to a certain point). That should give us an option of making a backup after upgrade. I did not try it myself - just a thought. In my case I only had to recreate user account manually - everything else went smoothly per notes. Leon </body> </html>