From: | "Joris Dobbelsteen" <Joris(at)familiedobbelsteen(dot)nl> |
---|---|
To: | "Russell Aspinwall" <russell(dot)aspinwall(at)flomerics(dot)co(dot)uk> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: newbie question |
Date: | 2007-10-17 09:10:31 |
Message-ID: | 73427AD314CC364C8DF0FFF9C4D693FF037CB9@nehemiah.joris2k.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>-----Original Message-----
>From: pgsql-general-owner(at)postgresql(dot)org
>[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of
>Russell Aspinwall
>Sent: woensdag 17 oktober 2007 9:34
>To: pgsql-general(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2007-10-17 09:23:46 | Re: replicating to a stopped server |
Previous Message | Joao Miguel Ferreira | 2007-10-17 09:07:55 | Re: Index Usage |