Re: upgrading, but learned about pg_dumpall too late

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

 



On Sat, Feb 20, 2010 at 10:42 PM, Andrzej Zawadzki <zawadaa@xxxxxxxxx> wrote:
> Downgrade to 7.4
> Dump
> Upgrade
> Restore
>

Actually that's not the best way.

The best way is to install 7.4 and 8.1.19 (not 8.1.11 which has known
bugs) at the same time.

Use the pg_dump *from* *8.1.19* to connect to the 7.4 server and dump
the database.
Then shut down 7.4 and start up 8.1.19 and use pg_restore to restore
the database.

-- 
greg

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux