Thread: ...
Hello. I have an instance of postgreSQL 7.4.7 with one database called dbmedia. We are moving to postgreSQL 8.1 running on windows2003 server. Can I just copy the entire $PGDATA directory to the new 8.1 instance of postgreSQL? Using PG_dump/restore? I heard that I might run into problems because of the difference in PG versions and server architectures. If this wont work, what would be the best way to get my dbmedia database moved over to the 8.1 instance running on windows? Thank you so much, Adam
Adam O'Toole <adamnb1@hotmail.com> schrieb: > Hello. > I have an instance of postgreSQL 7.4.7 with one database called dbmedia. We > are moving to postgreSQL 8.1 running on windows2003 server. Can I just copy > the entire $PGDATA directory to the new 8.1 instance of postgreSQL? Using No! Don't try it, it is useless and dangerous. Btw.: actual version is 8.0.3, not 8.1. > PG_dump/restore? Yes, and use the pg_dump from the 8.0 - Version to dump the old database. > I heard that I might run into problems because of the difference in PG > versions and server architectures. If this wont work, what would be the > best way to get my dbmedia database moved over to the 8.1 instance running Under Linux/UNIX, from the new machine: (principle) pg_dump -h <old_server> <options> | psql <options> Andreas -- Diese Message wurde erstellt mit freundlicher Unterstützung eines freilau- fenden Pinguins aus artgerechter Freilandhaltung. Er ist garantiert frei von Micro$oft'schen Viren. (#97922 http://counter.li.org) GPG 7F4584DA Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889° ;-)
Adam O'Toole wrote: > Hello. > I have an instance of postgreSQL 7.4.7 with one database called dbmedia. > We are moving to postgreSQL 8.1 running on windows2003 server. Can I > just copy the entire $PGDATA directory to the new 8.1 instance of > postgreSQL? No. And 8.1 isn't out yet. > Using PG_dump/restore? Yes > I heard that I might run into problems because of the difference in PG > versions and server architectures. If this wont work, what would be the > best way to get my dbmedia database moved over to the 8.1 instance > running on windows? Test it first - there might be something different between 7.4 and 8.0 that you're relying on. Read the release notes in 8.0 to find out what might affect you. It's generally easier to dump/restore using a version 8 pg_dump - each version is a bit smarter, and can talk to older servers. Oh - and make sure you're familiar with the Unicode issues on Windows. -- Richard Huxton Archonet Ltd