Alex Mayrhofer <axelm@xxxxxxxx> writes: > Jim C. Nasby wrote: >> 811? 812? We don't have anything close to those version numbers... > I'm well aware that PostgreSQL itself is currently at 8.1.0 - however, i'm > upgrading from 8.1beta2, and it seems to me that the backend version was > modified between those two versions - "811" and "812" seem to be backend > version identifiers which are reported when i'm trying to start the 8.1.0 > postmaster on the 8.1beta2 cluster: > FATAL: database files are incompatible with server > DETAIL: The database cluster was initialized with PG_CONTROL_VERSION 811, > but the server was compiled with PG_CONTROL_VERSION 812. Those are internal version numbers that no one normally ever sees, and certainly no one thinks about. You shouldn't try to outsmart us by referring to versions in other than the standard terms. The short answer, though, is that if the postmaster won't restart then you need a dump with the old code and reload with the new. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly