Re: [despammed] - Mailing list pgsql-novice

From Kretschmer Andreas
Subject Re: [despammed]
Date
Msg-id 20050812162542.GA1431@kaufbach.delug.de
Whole thread Raw
In response to ...  ("Adam O'Toole" <adamnb1@hotmail.com>)
List pgsql-novice
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° ;-)

pgsql-novice by date:

Previous
From: "Adam O'Toole"
Date:
Subject: ...
Next
From: "Adam O'Toole"
Date:
Subject: Re: [GENERAL]