Thread: database upgrade. Urgent!!!
Hello sir/madam
I am university student and i am using postgres as a backend for an application called Focalpoint.
I upgraded focalpoint but during the upgradig process from lower version to higher version, i didn't get the page which describes about the database upgrade.
In other installations, i get the page and when i click ok, the database gets upgraded along with focalpoint.
Now, my question is: Is there any way to check in postgres files, logs or pgAdmin to check if the database has been upgraded or not??
By upgrade, i mean the upgradation of database, not the version number increment of postgres like from 8.0 to 8.2..
Thanks in advance
Kenny
On 07/01/2008 20:48, Bomken Basar wrote: > By upgrade, i mean the upgradation of database, not the version number > increment of postgres like from 8.0 to 8.2.. If you upgrade Postgres to a new major version (IIRC this means either of the first two parts of the version number, e.g. 8.1 -> 8.2), then usually you have to do a dump and reload of the data. The release notes for the new version of PostgreSQL will tell you if you're not sure. If you don't do this, then I'd imagine PostgreSQL simply won't work. - not that I've tried it myself, mind. :-) A minor version upgrade (e.g. 8.2.4 -> 8.2.5) usually doesn't need a dump/restore: again, the release notes will tell you. If you can establish the version of PostgreSQL you're using (PgAdmin will tell you, or you can execute "select version()"), then you can check the PG documentation at http://www.postgresql.org/docs/ to see whether a dump/reload was required.....though if you can connect with PgAdmin after the upgrade, then all is probably well. HTH, Ray. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie ---------------------------------------------------------------
On 07/01/2008 20:48, Bomken Basar wrote: > Now, my question is: Is there any way to check in postgres files, logs > or pgAdmin to check if the database has been upgraded or not?? To answer this question a bit more succinctly than my last essay :-) .... I don't think so, because a major upgrade requires initdb to be run, which prepares the data directly afresh from scratch. Ray. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie ---------------------------------------------------------------