Re: [despammed]

Adam O'Toole <adamnb1(at)hotmail(dot)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° ;-)