it worked.. Thanks for taking the time and you can bet I will become very intimate with the pg_dump command set! Take care... \Bob <div>On 6/6/06, Lonni J Friedman <<a href="mailto:netllama@gmail.com">netllama@gmail.com</a>> wrote:<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> On 6/6/06, Bob Ambroso <<a href="mailto:bambroso@gmail.com">bambroso@gmail.com</a>> wrote: > I did as you instructed... Installed FC2 on another computer did a > filesystem backup of the "upgraded" data folder and moved it to the new/old > FC2 system. Performed a cursory configuration on the 7.4 postgres and then I > un-tarred the backup into the data folder. Started up the postgres server > and got no errors. I performed the pg_dumpall and moved the dumpall.dmp file > to the "upgraded" or 8.x system. Now I am really in a loop because I cannot > restore the dump file unless the server is running but it will not run > because the data format is different.. I would assume I have to nuke the > thing back to bare bones and then create the old databases and then perform > a restore.... Does this sound right?? > > How do I take the upgraded postgres server back to bare bones.. initdb > again?? Delete the contents of /var/lib/pgsql, then "service postgres start", and then import the DB dump. -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ L. Friedman <a href="mailto:netllama@gmail.com">netllama@gmail.com</a> LlamaLand <a href="http://netllama.linux-sxs.org">http://netllama.linux-sxs.org</a> -- fedora-list mailing list <a href="mailto:fedora-list@redhat.com">fedora-list@redhat.com</a> To unsubscribe: <a href="https://www.redhat.com/mailman/listinfo/fedora-list">https://www.redhat.com/mailman/listinfo/fedora-list </a> </blockquote></div>