Fedora Core 4 Upgrade hosed Postgresql

[Bob Ambroso]

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



Sheesh... they sure dont make it easy... Not that I did anything to make it
so... ;-)

Thanks for any help..

On 5/25/06, Craig White <craigwhite at azapple.com> wrote:
>
> 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 at azapple.com> 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 at redhat.com
> >         To unsubscribe:
> >         https://www.redhat.com/mailman/listinfo/fedora-list
> >
> > --
> > fedora-list mailing list
> > fedora-list at redhat.com
> > To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
>
> --
> fedora-list mailing list
> fedora-list at redhat.com
> To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/fedora-list/attachments/20060606/4acf38c9/attachment-0001.htm>