Re: Gary Griffith 2015-01-22 <cag9dotfpfe2-ix-o5wblmu_-srrevfvcnphyyf9saex95q2...@mail.gmail.com> > We're migrating a database running on PostgreSQL 9.2.4 that was init'd a > looong time ago (8+years) - being moved to an Ubuntu 14.0.4 server running > the PostgreSQL 9.2.9-1 DEB package. We've always cloned data on disk > (never had time to do a dump->restore when we had to go from 8.3 -> 9.2, > etc.) so we still have floating-point datetimes. After cloning the files, > I try to mount and get "The database cluster was initialized without > HAVE_INT64_TIMESTAMP but the server was compiled with > HAVE_INT64_TIMESTAMP." Our legacy system runs Postgres that we compiled > with "--disable-integer-datetimes" but on our new systems, we'd like to not > compile our own major applications, and use the Ubuntu packaging systems > and appreciate vendor-provided updates. > > I just need to recompile with --disable-integer-datetimes but would like to > match exactly the flags used when the > postgresql-9.2_9.2.9-1.pgdg14.04+1_amd64.deb was packaged. My initial run > of "configure --disable-integer-datetimes; make; make install" produces a > executable that mounts our non-integer datetime database files just fine. > > Is there a configure.log available that explains the way these packages are > built so we can compile with as few differences between the supported > version and ours?
I'd grab the Debian source package and edit debian/rules to add the flag. http://apt.postgresql.org/pub/repos/apt/pool/main/p/postgresql-9.2/ If you have "devscripts" installed, do dget http://apt.postgresql.org/pub/repos/apt/pool/main/p/postgresql-9.2/postgresql-9.2_9.2.9-1.pgdg14.04%2b1.dsc (possibly with -u) Christoph -- c...@df7cb.de | http://www.df7cb.de/ _______________________________________________ Pkg-postgresql-public mailing list Pkg-postgresql-public@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public