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??
<br><br>How do I take the upgraded postgres server back to bare bones.. initdb again??<br><br><br><br>Sheesh... they sure dont make it easy... Not that I did anything to make it so... ;-)<br><br>Thanks for any help..<br>
<br><div><span class="gmail_quote">On 5/25/06, <b class="gmail_sendername">Craig White</b> <<a href="mailto:craigwhite@azapple.com">craigwhite@azapple.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Yes, you have to move the data onto a system that has the same version<br>of postgresql - tarball is fine. Then you ***may*** have to<br>remove/reinstall postgresql-server to get the base data files installed.<br><br>Craig
<br><br>On Thu, 2006-05-25 at 19:36 -0700, Bob Ambroso wrote:<br>> Can you tell me how to do a pg_dump when the server wont start? It<br>> complains about data in an earlier format... Tar up data directory and<br>> move it???
<br>><br>> Any help is appreciated..<br>><br>> \Bob<br>><br>> On 5/25/06, Craig White <<a href="mailto:craigwhite@azapple.com">craigwhite@azapple.com</a>> wrote:<br>> On Thu, 2006-05-25 at 19:12 -0700, Bob Ambroso wrote:
<br>> > It is a test server. I normally use MYSQL and it was a test<br>> app that<br>> > required Postgresql.. It is test data.. Quite alot actually<br>> but to<br>> > answer your question.. No.. I blindly upgraded (have done so
<br>> in the<br>> > past with MYSQL) and now it is hose and I assume my test dat<br>> is as<br>> > well...<br>> ----<br>> postgresql does not update it's db files. They are most likely
<br>> not hosed<br>> but rather still in earlier format. If you can move them to<br>> another<br>> computer using the same version of postgresql that you were<br>> using, you
<br>> should be able to then pg_dump all the data and them load it<br>> into the<br>> newer version. That is the way postgresql has always worked.<br>><br>> You should be regularly 'dumping' your data from any sql db as
<br>> a backup<br>> whether it is mysql, postgresql or ???<br>><br>> You should be backing up your data prior to any OS 'upgrade'<br>><br>> I did the same thing myself in upgrading Fedora Core 2 to
<br>> Fedora Core 4<br>> but I did have a pg_dump file that was a few days old.<br>><br>> ;-)<br>><br>> Craig<br>><br>> --<br>> fedora-list mailing list
<br>> <a href="mailto:fedora-list@redhat.com">fedora-list@redhat.com</a><br>> To unsubscribe:<br>> <a href="https://www.redhat.com/mailman/listinfo/fedora-list">https://www.redhat.com/mailman/listinfo/fedora-list
</a><br>><br>> --<br>> fedora-list mailing list<br>> <a href="mailto:fedora-list@redhat.com">fedora-list@redhat.com</a><br>> To unsubscribe: <a href="https://www.redhat.com/mailman/listinfo/fedora-list">https://www.redhat.com/mailman/listinfo/fedora-list
</a><br><br>--<br>fedora-list mailing list<br><a href="mailto:fedora-list@redhat.com">fedora-list@redhat.com</a><br>To unsubscribe: <a href="https://www.redhat.com/mailman/listinfo/fedora-list">https://www.redhat.com/mailman/listinfo/fedora-list
</a><br></blockquote></div><br>