Re: Fedora Core 4 Upgrade hosed Postgresql

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

 



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