Yes, you have to move the data onto a system that has the same version of postgresql - tarball is fine. Then you ***may*** have to remove/reinstall postgresql-server to get the base data files installed. Craig On Thu, 2006-05-25 at 19:36 -0700, Bob Ambroso wrote: > Can you tell me how to do a pg_dump when the server wont start? It > complains about data in an earlier format... Tar up data directory and > move it??? > > Any help is appreciated.. > > \Bob > > On 5/25/06, Craig White <craigwhite@xxxxxxxxxxx> wrote: > On Thu, 2006-05-25 at 19:12 -0700, Bob Ambroso wrote: > > It is a test server. I normally use MYSQL and it was a test > app that > > required Postgresql.. It is test data.. Quite alot actually > but to > > answer your question.. No.. I blindly upgraded (have done so > in the > > past with MYSQL) and now it is hose and I assume my test dat > is as > > well... > ---- > postgresql does not update it's db files. They are most likely > not hosed > but rather still in earlier format. If you can move them to > another > computer using the same version of postgresql that you were > using, you > should be able to then pg_dump all the data and them load it > into the > newer version. That is the way postgresql has always worked. > > You should be regularly 'dumping' your data from any sql db as > a backup > whether it is mysql, postgresql or ??? > > You should be backing up your data prior to any OS 'upgrade' > > I did the same thing myself in upgrading Fedora Core 2 to > Fedora Core 4 > but I did have a pg_dump file that was a few days old. > > ;-) > > Craig > > -- > fedora-list mailing list > fedora-list@xxxxxxxxxx > To unsubscribe: > https://www.redhat.com/mailman/listinfo/fedora-list > > -- > fedora-list mailing list > fedora-list@xxxxxxxxxx > To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
