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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
