Re: [GENERAL] pg_upgrade from 8.3 to 9.1 and Flag --disable-integer-datetimes

2014-06-07 Thread Kevin Grittner
Bruce Momjian wrote: > On Tue, May 27, 2014 at 04:29:19PM +0200, Meik Weißbach wrote: >> How do we determine, whether or not a server is built with >> disable-integer-datetimes? > > pg_upgrade --check will definitely complain about a timestamp storage > mismatch.  Odds are your packager built 8.3

Re: [GENERAL] pg_upgrade from 8.3 to 9.1 and Flag --disable-integer-datetimes

2014-05-27 Thread Bruce Momjian
On Tue, May 27, 2014 at 04:29:19PM +0200, Meik Weißbach wrote: > Hello all, > > we want to upgrade our database from Postgres 8.3.23 to 9.1.12 using > pg_upgrade. The documentation on pg_upgrade > (http://www.postgresql.org/docs/9.1/static/pgupgrade.html) states > the following: > > "Also, the de

Re: [GENERAL] pg_upgrade from 8.3 to 9.1 and Flag --disable-integer-datetimes

2014-05-27 Thread Adrian Klaver
On 05/27/2014 07:29 AM, Meik Weißbach wrote: Hello all, we want to upgrade our database from Postgres 8.3.23 to 9.1.12 using pg_upgrade. The documentation on pg_upgrade (http://www.postgresql.org/docs/9.1/static/pgupgrade.html) states the following: "Also, the default datetime storage format ch

[GENERAL] pg_upgrade from 8.3 to 9.1 and Flag --disable-integer-datetimes

2014-05-27 Thread Meik Weißbach
Hello all, we want to upgrade our database from Postgres 8.3.23 to 9.1.12 using pg_upgrade. The documentation on pg_upgrade (http://www.postgresql.org/docs/9.1/static/pgupgrade.html) states the following: "Also, the default datetime storage format changed to integer after PostgreSQL 8.3. pg