Fedora Core 4 Upgrade hosed Postgresql
Bob Ambroso
bambroso at gmail.com
Tue Jun 6 22:05:42 UTC 2006
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://lists.fedoraproject.org/pipermail/users/attachments/20060606/4acf38c9/attachment-0002.html
More information about the users
mailing list