From: "Adam O'Toole" <adamnb1(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: pgsql-novice(at)postgresql(dot)org
Subject:
Date: 2005-08-12 16:08:06
Message-ID: BAY102-F32D74D4C815B779BC75649FBBC0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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

Responses

  • Re: at 2005-08-12 16:22:05 from Richard Huxton
  • Re: [despammed] at 2005-08-12 16:25:42 from Kretschmer Andreas

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2005-08-12 16:10:35 Re: Conversion of Database to schema aware
Previous Message Richard Sydney-Smith 2005-08-12 15:36:01 Conversion of Database to schema aware

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Huxton 2005-08-12 16:22:05 Re:
Previous Message Bruce Momjian 2005-08-12 16:04:25 Re: Forcing WAL switch