Re: Fedora Core 4 Upgrade hosed Postgresql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
[Index of Archives]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [Fedora Magazine]     [Fedora News]     [Fedora Summer Coding]     [Fedora Laptop]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Maintainers]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Legacy]     [Fedora Desktop]     [Fedora Fonts]     [ATA RAID]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [SSH]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Centos]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Tux]     [Yosemite News]     [Gnome Users]     [KDE Users]     [Fedora Art]     [Fedora Docs]     [Asterisk PBX]     [Fedora Sparc]     [Fedora Universal Network Connector]     [Libvirt Users]     [Fedora ARM]

  Powered by Linux