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° ;-)