>-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of >Russell Aspinwall >Sent: woensdag 17 oktober 2007 9:34 >To: pgsql-general@postgresql.org >Subject: [GENERAL] newbie question > >Hi, > >[snip] For example, if you had a >built a database and application using version 3 and then >upgraded the version 7, it was possible to set the database >configuration to version 3 and then continue to use the same >database and applications without having to dump the database >tables and data then import them into a version 7 database or >update applications. >Does this feature exist in ProgreSQL, can a v8 access a >database created using v7?
No it cannot. You must perform a dump and restore. Also note that between different architectures (and sometimes between different compiles) the file format might also be different. See also: http://www.postgresql.org/docs/8.1/interactive/install-upgrading.html. However all queries running on v7 should work on v8. The application should not require any modifications. In practice you should, of course, test that before putting it into production. - Joris ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
